topic store tREST output in XML file in Talend Studio

store tREST output in XML file

Anonymous — Sat, 16 Nov 2024 03:33:36 GMT

All,

I am trying to get the TOKEN from tableau serve by using tableau rest api methods, i was able to get the token by using Postman, but here i got strucked.

I have a simple REST component where i hardcoded the Body and used a 'logrow' component to capture the output, it works fine.

But when i try to store the same result, it is not properly writing. I need this file later to get the 'TOKEN'.

How to capture the response of tREST in an XML file for further processing?

Re: store tREST output in XML file

Anonymous — Fri, 17 Jan 2020 07:54:32 GMT

Hi
The tRest returns a string, is it a XML format or Json format? If it is latter, use a tExtractJsonField to extract the data from the response and use a tAdvancedFileOutputXML to create a new XML file.

Regards
Shong

Re: store tREST output in XML file

Anonymous — Fri, 17 Jan 2020 13:44:16 GMT

do you mean tRest will not return XML/JSON format?

What is the simple job design to get the TOKEN and store it in a file or variable?

Re: store tREST output in XML file

Anonymous — Mon, 20 Jan 2020 00:42:14 GMT

The response of tRest is a string with XML/Json format, to use tExtractJsonField or tExtractXMLField to extract data from the response depends on it is a Json format or XML format. A simple job design looks like:
tRest--tExtractJsonField--tfileOutputDelimited