topic Extracting data from a Json array (collection) in Talend Studio

Extracting data from a Json array (collection)

Ema_fr — Thu, 24 Jan 2019 13:34:58 GMT

Hello everyone,

I haven't yet found a way to extract the data given by my tREST component.

Here's the scenario :

My data is a JSON array like :

[
{"@id":201215,"link":{"@rel":"self","@href":"\/api\/groupe\/201215"},"libelle":"test \u00e0 moi 46546846","abrege":"test_dependances_2","entites":"Personne","description":null},
{"@id":201219,"link":{"@rel":"self","@href":"\/api\/groupe\/201219"},"libelle":"test \u00e0 moi 46546846","abrege":"test_dependances_2","entites":"Personne","description":null}
]

The tExtractJSONfields is filled that way :

I can't seem to obtain the response I wish for.

I checked with a tlogRow immediately after the tREST component and the answer is correct so far.

Do you have any idea what's wrong with my reasoning ?

Thanks for your suggestions and help !

Best regards,

Ema

Re: Extracting data from a Json array (collection)

Ema_fr — Thu, 24 Jan 2019 14:15:49 GMT

Hi,

Further info : error log shows :

com.jayway.jsonpath.InvalidPathException: Invalid path $id

=> if I replace the "@" before the tExtractJSONfields, it does the trick;

But, is it really impossible to use the character "@" in field name ?

Thank you all for your insight,

Ema

Re: Extracting data from a Json array (collection)

David_Beaty — Thu, 24 Jan 2019 14:45:34 GMT

Hi,

I think your JSON Query for each column is incorrect, try it as "$.@id"

Re: Extracting data from a Json array (collection)

Ema_fr — Thu, 24 Jan 2019 15:09:25 GMT

Hi,

Thank you so much, It worked !!!!

Best regards !