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

[JY3]

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?

[tnewbie]

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

 

[JY3]

Hi @tech seeker​ ,

if I set

 

I get

 

if I set..

 

I get

 

if I set.

 

I get..

did I make any mistake?

[tnewbie · Accepted solution]

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

 

[JY3]

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

[tnewbie]

Glad, it worked for you