tRest with XML response export to CSV

Anonymous — Sat, 16 Nov 2024 07:08:37 GMT

Hello all,

this my first work with XML based data and I need some help, I hope you can help me in my case. I have an API where I get a XML post, this post I need to export into a CSV file. Is an easy way existing how to get the API response to CSV?

The RestAPI call is very simple. A link with parameters. I get an XML response back with the following entry:

body
ERROR_CODE

Sample response from API:

<API_RESPONSE><QUANTITIES>

How can I put the response into a table structure?

Many thanks in advancded

Re: tRest with XML response export to CSV

vapukov — Tue, 04 Dec 2018 08:38:22 GMT

you need to use tExtractXMLField

best for study XML using one of XML related tools (easiest way) and test XPath expressions there, like OxygenXML or Altova

some good explanation -

https://www.w3schools.com/xml/xml_xpath.asp

https://msdn.microsoft.com/en-us/library/ms256086%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396

https://goessner.net/articles/JsonPath/

topic Re: tRest with XML response export to CSV in Talend Studio

tRest with XML response export to CSV

Re: tRest with XML response export to CSV