WebService - XML Response Mapping

[srpodeti (Srinivas Podeti)]

Hello Team/Experts,
I am looking for help to parse the XML response in Webservices connector.
response::

soap_response.txt (7.7 KB)

Below are the configuration in WS connector.
Headers
Accept: * / , Content-Type: application/json
Response Information
Root Path: .//MasterDataResponse/MasterDataResult/UserRoles/UserRole
Success Code: 2*
Response Mapping
Schema attributes (on the left column)
GRPNAME
Attribute Path (On the right column)
@GRPNAME

XPath Name Space Mapping:

After Entilement Aggregation i am getting Entitlements Scanned 0.

How should I configure the response to map the attributes like GRPNAME?

Could you please help me?

[sidharth_tarlapally (TARLAPALLY SIDHARTH)]

Helo @srpodeti

Check if these are helpful :

WebServices | Account Aggregation | Mapping of XML Response

Hello, I need help in understanding how to Map an XML Response from a WS Account Aggregation. For example if the response body looked like this, (using Tableau API Response for example only) <?xml version='1.0' encoding='utf-8'?> <tsResponse xmlns="http://tableau.com/api" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://tableau.com/api https://help.tableau.com/samples/en-us/rest_api/ts-api_3_4.xsd"> <pagination pageNumber="1" pageSize="100" totalAvailable="28"…

WebService - XML Response Mapping

Hello Experts, Trying to retrieve the roleKey and text value from the below XML response but unable to get the values. Below are my configurations: Root Path : //UserRoles/UserRole[*] Response Mapping and XPath Namespace Mapping: Attached Actual Response : Attached Kindly help me find the missing configurations [XPath Namespace Mapping] [Response Mapping] [XML Response]

XPath in Entitlement Aggregation

Thanks for the responses, everyone, but I gave up on doing it the conventional way and created this after rule instead haha import java.util.*; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.xpath.XPath; import javax.xml.xpath.XPathExpression; import javax.xml.xpath.XPathFactory; import org.w3c.dom.Document; import org.xml.sax.InputSource; import java.io.StringReader; import org.w3c.dom.NodeList; if (!rawResponseObject.equals("")) { …

Thanks
Sid

[jsosa (Julian Sosa)]

Hi! Pleae try:

Root path:
//MasterDataResponse/MasterDataResult/UserRoles

schema attributes: GRPNAME
attribute path: UserRole/GRPNAME (or maybe /UserRole/GRPNAME)

[srpodeti (Srinivas Podeti)]

Hi @jsosa , Thanks for the reply, The issue is same unable to aggregate the entitlement’s.

[Rohit_Sahu]

Hi @srpodeti ,

Your Root Path and Response Mapping configuration looks good. Once try with the following changes:

Change your header like this: Content-Type: application/xml

And, XPath Name Space Mapping:

xmlns:xsd: http://www.w3.org/2001/XMLSchema
xmlns:soap : http://schemas.xmlsoap.org/soap/envelope/
xmlns: xsi:http://www.w3.org/2001/XMLSchema-instance
xmlns: http://tempuri.org/

Hope this will work!
Rohit

[srpodeti (Srinivas Podeti)]

Hi @Rohit_Sahu ,

I tried the above suggestions still same issue. Zero entitlements are scanned.

[j_place (Jeremy Place)]

Hi @srpodeti - Your Web Service is wrapping the xml you are interested in as a string CDATA blob; my understanding is that that can’t be directly parsed via XPath. If you can’t get the WS to send raw XML, then you are into a more complex solution including perhaps an After Operation Rule to extract the XML body.

[srpodeti (Srinivas Podeti)]

Hi @j_place ,

I wrote the after operation rule and i am getting below error.

Exception during aggregation of Object Type Role on Application Example POC [source]. Reason: java.lang.RuntimeException: An error occurred while aggregating Application Example POC [source] sailpoint.connector.ConnectorException: Error: The application script threw an exception: org.xml.sax.SAXParseException; lineNumber: 75; columnNumber: 17; The element type “p” must be terminated by the matching end-tag "

". BSF info: Example After Operation Rule at line: 0 column: columnNo
comu.txt (1.9 KB)

Could you please help me where this error is coming?

[j_place (Jeremy Place)]

Hi @srpodeti - I’m afraid I don’t have the bandwidth to debug your rule, but please check that you are extracting the CDATA first and then doing the XPath on the result, which looks like it has a root of /schema1/complexType/UserRoles