Forum Discussion

axasmgaxa's avatar
axasmgaxa
Occasional Contributor
3 years ago
Solved

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...
  • axasmgaxa's avatar
    axasmgaxa
    3 years ago

    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.