topic Re: reading an array with tXMLMap in Talend Studio

reading an array with tXMLMap

stagliaferri1640766615 — Wed, 29 Dec 2021 08:37:44 GMT

Hello,

I am trying to store in a database table data retrieved from an API.

Though, one of of the input contains an array in one of the sub branch (as you can see in the example).

I am using tXMLMap component to map the API from the trestclient. but in the database I always see the first value of the array. the other are discarded.

How can I fix this?

thanks a lot

Re: reading an array with tXMLMap

Anonymous — Wed, 29 Dec 2021 09:58:30 GMT

Can you upload a screenshot of tXMLMap? Is it possible to provide an sample data for testing?

Regards

Shong

Re: reading an array with tXMLMap

stagliaferri1640766615 — Wed, 29 Dec 2021 10:08:57 GMT

sure !

thank you Shong

Regards,

sergio

Re: reading an array with tXMLMap

stagliaferri1640766615 — Wed, 29 Dec 2021 10:09:17 GMT

Re: reading an array with tXMLMap

Anonymous — Thu, 30 Dec 2021 03:51:59 GMT

I have made some testing, if the json file read by Jsonpath model, all values in array are read.

if the json file read by Xpath model, only the first value in array is read.

So, have a try to uncheck the 'Convert response to DOM Document' box in the advanced setting panel of tRestClient, if the component returns a Json string, then you can use tExtractJsonFields component to extract data from response string with Jsonpath model.

Please try and let me know if it works.

Regards

Shong

Re: reading an array with tXMLMap

stagliaferri1640766615 — Thu, 30 Dec 2021 04:45:57 GMT

hello! it worked!!! thank you very much!!

Re: reading an array with tXMLMap

Anonymous — Thu, 30 Dec 2021 09:41:38 GMT

great! Thanks for your feedback!