WebService - XML Response Mapping in SOAP

[thiagogosantanasi (Thiago Santana da Silva)]

I’m trying to integrate an authoritative Source into IdentityNow, via Web Service. The Web Service returns a SOAP and within the SOAP envelope the XML, causing the mapping in “Response Information” and “Response Mapping” not to work correctly. Has anyone experienced this and know how to resolve it?

I need to capture the value of “f_num”, which would normally be something like this, for example: //f_num[1] or //f_num
But, it doesn’t work due to SOAP envelope or something related.

Below is the SOAP response:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <soap:Body>
      <GetDadosFuncionariosResponse xmlns="http://tempuri.org/">
         <GetDtFuncResult><![CDATA[<?xml version="1.0" encoding="utf-8"?><Funcionarios xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><dadosFuncionario><f_cod>00087</f_cod><f_num>111111</f_num><f_nom>TESTE_TESTE</f_nom><f_n_end>Rua teste, 123, CASA WW</f_n_end><f_nom_bairro>Vila Teste</f_nom_bairro></dadosFuncionario></Funcionarios>]]></GetDtFuncResult>
      </GetDadosFuncionariosResponse>
   </soap:Body>
</soap:Envelope>

[ashutosh08 (Ashutosh Singh)]

Hi @thiagogosantanasi,

What is the mapping you are currently using get the data? If you can help with the error and mapping, then it will be easy to comment on the issue.

If you just need sample of how to map for xml response then please go through this SailPoint documentation.

Account, Entitlement, or Get Object Aggregation

Thanks

[thiagogosantanasi (Thiago Santana da Silva)]

Hey,
Thanks for your response.

I’m not getting any errors, just no data is returned, I believe the problem is with the data inside “”, as I tested the xml path without CDATA and managed to get the data.

[ashutosh08 (Ashutosh Singh)]

Hi @thiagogosantanasi,

I do not think with the help of XPATH directly you will be able to resolve it. You may use after operation rule to use beanshell code to create response mapping.

Let me know if you need help with the rule.

Thanks