Embedded SOAP Response XML

[Former Member]

Hi,

Experts ! Check below SOAP Response XML. Instead of returning actual XML data , It has some encoded XML in It .

what is this encoding ?? Can you please help in how to extract data from this embedded string ???

<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">

   <S:Body>

    <getJobResultEmbeddedResponse xmlns="urn:sfobject.sfapi.successfactors.com" xmlns:ns2="urn:fault.sfapi.successfactors.com">

        UEsDBBQACAAIAFGy9UIAAAAAAAAAAAAAAAAkAAAAU0ZBUElfMDcyMjAxMTgzMTY0NF9yZWNydWl0aW5nVjIuY3N2LY+xDcMwDAT7ANnB0AQ29aSpPo1TZgQDroPs3wTmqdGB5P9TbO/vuXyu33K82vPRcrvfbbWCqAIwMwMqiTHrK6DZ1QtzFjSxi2gxE03H7jZREme7T0nSzIoODEFY4AubFRITcBBgLxAWhO1sSDITQ3JKckry3UQ5WDskUIYRt/IPUEsHCNJaSzmBAAAATwEAAFBLAQIUABQACAAIAFGy9ULSWks5gQAAAE8BAAAkAAAAAAAAAAAAAAAAAAAAAABTRkFQSV8wNzIyMDExODMxNjQ0X3JlY3J1aXRpbmdWMi5jc3ZQSwUGAAAAAAEAAQBSAAAA0wAAAAAA

    </getJobResultEmbeddedResponse>

   </S:Body>

</S:Envelope>

[markangelo_dihiansan · Accepted solution]

Hello Prabhat,

It looks like the XML is encoded into a base64 string. You can extract it using a UDF.

Regards,

Mark