topic Re: Parsing json files using absolute path in Talend Studio

Parsing json files using absolute path

gpinumalla — Thu, 07 Jan 2021 16:52:14 GMT

Hi all,

I was looking to retrive/read a json file using absolute path using talend 7.3.1 . I could see only xpath / jsonpath. In previous versions like 7.1.1 had 3 options : absoute path/xpath/jsonpath. is this feature available in the current versions like 7.3.1 or 7.4.1

Re: Parsing json files using absolute path

Anonymous — Fri, 08 Jan 2021 08:37:17 GMT

Hello,

You can specify the "Relative or absolute path expression" when defining the schema of your JSON file

For more information, please have a look at this online documentation for V 7.3.1

TalendHelpCenter: Setting up JSON metadata for an input file

Best regards

Sabrina

Re: Parsing json files using absolute path

gpinumalla — Mon, 11 Jan 2021 20:50:38 GMT

it helps to parse json. I have logic to pass the complete json file into the rest API component using trestclient. is it possible to parse all json elements into the trestclient?

Re: Parsing json files using absolute path

gpinumalla — Tue, 12 Jan 2021 22:21:51 GMT

@Xiaodi Shi I have a requirement of 153 fields in one json file and call a rest APi call using trestclient component. the problem is that there are multiple arrays and loops within one json file. Is it possible to calling Rest API and mapping json mapping to trestclient? is there a way to pass text file ( convert json file to text format) to call API ?

Re: Parsing json files using absolute path

Anonymous — Tue, 19 Jan 2021 08:15:19 GMT

Hello,

JSON can be passed to a tRestClient and it is a String and not a Document.

You need to send the JSON string to the "string" input and not the "body" of the tRestClient.

Let me know if it works.

Best regards

Sabrina

Re: Parsing json files using absolute path

gpinumalla — Tue, 19 Jan 2021 17:08:49 GMT

@Xiaodi Shi I was not able to parse complete 153 fields instead I used the trawinput file as json body --> trest1 --> response to the textractjson. it worked with trawinput.