UKG Pro Report As A Service - XML Parsing Help

[pdegraaffiam (Paul de Graaff)]

I need help with XML Parsing. I am ok with JSON parsing but XML poses a real challenge. I have an application called UKG Pro where we need to process the process the output of a report that shows the pending terminations. Terminations do not come through in the connector till days after the termination as it is tied to payroll processing. The HR team built a report to get the term dates from an interim location so we can process these terms effectively on the term date. The challenge is to generate report output it is all XML based which is not the easiest (the rest is all JSON based but for some reason they only support XML for this service).

There are four (4) steps to running a report (login, run report report, pick up output and logoff).

The XML response that I need help with is as follows:

<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="
">
   <s:Header>
    <a:Action s:mustUnderstand="1">http://www.ultipro.com/dataservices/bidata/2/IBIDataService/LogOnResponse</a:Action>
</s:Header>
<s:Body>
      <LogOnResponse xmlns="http://www.ultipro.com/dataservices/bidata/2">
           <LogOnResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
               <ServiceId>string value</ServiceId>
               <ClientAccessKey>key</ClientAccessKey>
               <Token>string value</Token>
               <Status>Ok</Status>
               <StatusMessage i:nil="true"/>
               <InstanceKey>string value</InstanceKey>
           </LogOnResult>
       </LogOnResponse>
</s:Body>
</s:Envelope>

I need to parse out the three (3) string values (ServiceID, Token and InstanceKey). Any help is appreciated on how to configure this in a response mapping in the web services connector? The examples in the documentation are limited and I am not great at XML .

Thanks Paul

[officialamitguptaa (Amit Gupta)]

@pdegraaffiam

I need to parse out the three (3) string values (ServiceID, Token and InstanceKey). Any help is appreciated on how to configure this in a response mapping in the web services connector? The examples in the documentation are limited and I am not great at XML

@pdegraaffiam -

Response Mapping configuration

In the operation you’re configuring (the LogOn step), set up the response mapping like this:

Root Path (anchors where attribute XPaths start):

//*[local-name()=‘LogOnResult’]

Attribute mappings (each is relative to the root):

Attribute Name	XPath
ServiceId	*[local-name()='ServiceId']/text()
Token	*[local-name()='Token']/text()
InstanceKey	*[local-name()='InstanceKey']/text()

That’s it for parsing. The local-name()='X' pattern means “any element whose local name is X, ignoring whatever namespace it lives in” — perfect for SOAP responses where you don’t want to register prefixes.

[pdegraaffiam (Paul de Graaff)]

I did as you suggested and I am getting an error on the “root path”. it says unexpected character ?

This is a screenshot of the defined response information

This is a screenshot of the defined response mapping.

I initially had left out the root path, that is why I think there is something with the root path definition.

Thanks for your guidance.