Parsing JSON with tExtractJSONFields (Again)

SMader — Fri, 15 Nov 2024 22:26:25 GMT

New to Talend and Talend Open Studio, at this early stage playing around with different components to understand and later start designing data integration scenarios.

Using Talend Open Studio 8.0.1 on an Ubuntu 22.04.1 LTS hosted on a M1 MAC (ARM64).

I've set up an extremely basic REST service that returns a list of employees:

{"Employees":[{"id":1,"name":"Jane Doe","age":"22"},{"id":2,"name":"John Doe","age":"31"}]}

Using the TRest component and the tExtractJSONFields to "do" something with attributes of each employee.

But I just cannot edit the mapping of the tExtractJSONFields component!

I cannot add any lines to the mapping (although I've really tried hard ...).

I've seen demos, read and reread the documentation, they all show a clean and what seems to be an easy to edit and obtain a mapping.

I'm stuck with a mapping table that only provides one line (and with again no way to add any more lines).

This unique line contains

a value for the Column column with "body" as a value but that I cannot change
and a "Json query" column but that's useless because I can't change the column value and cannot add any lines anyway

What am I getting wrong ? I'm probably missing something.

And why can't I add lines and edit the Column values ?

Is the problem tied to a misunderstanding on my part of how to go about doing the mapping or is it potentially caused by a GUI problem on Eclipse running on Ubuntu ?

Re: Parsing JSON with tExtractJSONFields (Again)

SMader — Thu, 20 Oct 2022 20:25:15 GMT

OK, just needed to create a json schema and reference it.

Re: Parsing JSON with tExtractJSONFields (Again)

Anonymous — Fri, 21 Oct 2022 04:01:40 GMT

Hello,

Thanks for letting us know you've resolved this issue by yourself.

Best regards

Sabrina

topic Parsing JSON with tExtractJSONFields (Again) in Talend Studio

Parsing JSON with tExtractJSONFields (Again)

Re: Parsing JSON with tExtractJSONFields (Again)

Re: Parsing JSON with tExtractJSONFields (Again)