tExtractjasonFields

[Parikhharshal]

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.

[root]

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.

[Parikhharshal]

@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.

[Parikhharshal · Accepted solution]

Hi there

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