Forum Discussion

aditya_gupta41's avatar
aditya_gupta41
Contributor
4 years ago

Formatting an XML Output

After a REST POST execute, my response comes as:

I want to remove the part which is enclosed in <>. The output file is in CSV format and should capture data after “CDATA[” and ends at “]]”.

1 Reply

  • j_angelevski's avatar
    j_angelevski
    Contributor III
    4 years ago
    Report

    Hi @aditya.gupta41 ,

    Can you please put the XML code into preformatted text so we can easily copy the data ? Preformatted text

    When you get XML response you can use a mapper with binary output and map the $response as $content and map $[‘content-type’] to “application/xml” in the mapper. Then you can use XML parser to get the XML data form the response and map the field that contains the CDATA.