topic Re: Can I add context value in eExtractJSONFields or add parent value of Loop Jsonpath query into output? in Talend Studio

Can I add context value in eExtractJSONFields or add parent value of Loop Jsonpath query into output?

JY3 — Fri, 15 Nov 2024 22:00:42 GMT

Hi experts,

The below is JSON file

{

"id": 895564,

"idn": "35",

"dataDocumentCustomFields": {

"data": [

{

"id": 1674099,

"value": "168177",

{

"id": 1674100,

"value": "168250",

{

"id": 1674101,

"value": "169067",

}

]

"isBudgetOverLimit": false

}

I want to have output as below

However, because idn is above Loop Jsonpath query, I was not able to enter JSONQuery on tExtractJSONFields. So, I assigned idn into context but still Json query can't read it as below. Could you please advise how I can include the parent value of Loop Jsonpath query into output?

Re: Can I add context value in eExtractJSONFields or add parent value of Loop Jsonpath query into output?

tnewbie — Sat, 11 Mar 2023 18:47:00 GMT

You have not shared how and where your context.order is being instantiated.I think the issue is sensibile and is very self explanatory...

have your tried this, because you seem to have an array holding id and values, you may have to introduce [] in your json query, if u start getting ur id and value as null from the below approach

Re: Can I add context value in eExtractJSONFields or add parent value of Loop Jsonpath query into output?

JY3 — Sun, 12 Mar 2023 11:36:59 GMT

Hi @tech seeker ,

if I set

I get

if I set..

I get

if I set.

I get..

did I make any mistake?

Re: Can I add context value in eExtractJSONFields or add parent value of Loop Jsonpath query into output?

tnewbie — Mon, 13 Mar 2023 04:04:22 GMT

ok, here is the complete solution to the problem

Step 1:

I am first fetching the idn value from tExtractJSONField

Step 2:

I am fetch the array elements from data array

tExtractJSONFields_1 schema would look like this :

tExtractJSONFields_2 config and schema would look like this

End result would like this

Re: Can I add context value in eExtractJSONFields or add parent value of Loop Jsonpath query into output?

JY3 — Mon, 13 Mar 2023 04:12:53 GMT

Yes, it worked. Thank you for your help. you saved me.

Re: Can I add context value in eExtractJSONFields or add parent value of Loop Jsonpath query into output?

tnewbie — Mon, 13 Mar 2023 04:44:18 GMT

Glad, it worked for you