topic Re: tExtractjasonFields in Talend Studio

tExtractjasonFields

Parikhharshal — Sat, 16 Nov 2024 07:21:38 GMT

Hi there

I am trying to extract json format data from tRestClient and it looks like this.

{"id":3404,"page_views":0,"max_page_views":14,"page_views_level":0,"participations":0,"max_participations":0,"participations_level":0,"tardiness_breakdown":{"missing":0,"late":3,"on_time":0,"floating":1,"total":4}}

I have configured tExtractjasonFields like below:

But it keeps showing me null in the result. I have designed my job like this:

Not sure if I am configuring ExtractJasonFields component wrong. Can you please advise what is the correct way of doing?

Thanks

Harshal.

Re: tExtractjasonFields

root — Sat, 03 Nov 2018 12:47:39 GMT

At least the screenshot you provided does not contain any field mapping of elements you want to extract. Please add mappings of them based on the jsonpath and you shall be all set.

Re: tExtractjasonFields

Parikhharshal — Sun, 04 Nov 2018 08:01:27 GMT

@mbocquet: I completed my mapping for all other fields by selecting jsonpath but still not getting result.

Please see the screenshot above wherein I have got mapping and schema for textractjson fields.

Re: tExtractjasonFields

Parikhharshal — Sun, 04 Nov 2018 08:09:07 GMT

Hi there

I mentioned it as String in Json Field and it worked. Thanks.