topic Re: extract fields from JSON and assign to globalmap in Talend Studio

extract fields from JSON and assign to globalmap

desanip — Sat, 16 Nov 2024 02:16:33 GMT

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.

Re: extract fields from JSON and assign to globalmap

manodwhb — Tue, 02 Jun 2020 05:21:14 GMT

@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

Re: extract fields from JSON and assign to globalmap

desanip — Tue, 02 Jun 2020 14:24:55 GMT

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

Re: extract fields from JSON and assign to globalmap

manodwhb — Tue, 02 Jun 2020 14:42:18 GMT

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