extract fields from JSON and assign to globalmap

[desanip]

Hello Talendians,

How do i extract fields from JSON and assign it to globalmap so that i can reuse the values for later use in downstream components?

Tinputfilejson-->TextractJSON-->Tlogrow-->tglobalmap.

This is the data flow i designed. 

Can someone explain me how i need to configure the json components?

My JSON File is as follows:

{

 "name":"Corporation"

"data":{

"category":"shopping",

"type":"debit",

"dsani":[

{

"dsani":{

"name":"david",

"occupation: "software engineer"

}

{

]

},

................Next few lines.

Do i need to use json path withoutloop for this? If someone can share me example or a reference that would be great.

[manodwhb]

@desanip , your design should be like below. you need to define the xloop path based on it it will extract the particular field from json and set it in global map.

tfileinputjson-->tLogrow-->tGlobalmap

[desanip]

Aren’t we supposed to use textractjsonfield component after input json.

Can you take a look at my json file that I am trying to extract and would appreciate if you could show me how to configure this. Thanks

[manodwhb]

@desanip , Realy not sure about you input json structure ,based on the inputput structure if you are getting json string as single column which you need to extract then you need to use tExtractJsonfields component.