Forum Discussion

axasmgaxa's avatar
axasmgaxa
Occasional Contributor
4 years ago

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...
REST
SOAP
  • axasmgaxa's avatar
    axasmgaxa
    4 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. 

axasmgaxa's avatar
axasmgaxa
Occasional Contributor
4 years ago

Thanks for the reply nmrao , when you say it is not appropriate; is that because it won't work?


I hope to remove the CDATA tags so that the XML will format properly; can be viewed in the "Outline" tab, and I can manipulate the formatted XML to extract data as needed, as the software was designed to do.

 

If that is not possible I can look at other solutions, but for now, that's what I am aiming to do.

    • axasmgaxa's avatar
      axasmgaxa
      Occasional Contributor
      4 years ago

      Hi nmrao 

       

      thanks again for taking the time to respond.

      I moved to another solution for my problem using the property transfer steps to extract the data I need from the response XML. 

      Seems to work just fine!

       

      Kind Regards,

      Steven.

      • nmrao's avatar
        nmrao
        Champion Level 3
        4 years ago
        Good to hear.