Trying to remove CDATA from response not working
Hi All, I am hoping someone can help me here! I have have a REST request that is returning a response, which seems to be in JSON format. I don't know much about JSON at all. I can see th...
Oh yes sure!
So the response was returned in JSON; which contained 3 nodes.
The 2nd node contained the XML I needed to extract my necessary data; called "suite_id"
I set up a property called "XMLData"; and a property transfer.
I used the Property Transfer "wizard" to select the 2nd JSON node, via the XPATH path language.
I transferred this to the XMLData Property; so this now contains the XML response.
From here I set up a new property, "SuiteID", and another property transfer.
Using the new property transfer, I was able to extract the SuiteID data from the XMLData property. Again using the XPath language in the property transfer wizard.
I transferred the data to my "SuiteID" property.
