tExtractjasonFields

Eight Stars

tExtractjasonFields

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:

 

Screen Shot 2018-11-03 at 4.25.32 pm.png

 

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

 

Screen Shot 2018-11-03 at 4.27.03 pm.png

 

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

 

Thanks

Harshal.

 


Accepted Solutions
Eight Stars

Re: tExtractjasonFields

Hi there

 

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

 

View solution in original post


All Replies
Eight Stars

Re: tExtractjasonFields

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.
Eight Stars

Re: tExtractjasonFields

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

 

Screen Shot 2018-11-04 at 6.59.12 pm.pngScreen Shot 2018-11-04 at 6.59.22 pm.png 

 

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

Eight Stars

Re: tExtractjasonFields

Hi there

 

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

 

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now