How to extract values from Dynamic JSON fields?

[jerownimow]

Hi Folks,

Good day!

I am new to Talend and badly needed your help. I have this job that consist of the following:

1st subjob:
processing logic -> tHashOutput (contains invoice and other fields)

2nd subjob:
Hash (contains the source of AggGrp - see attachment Source and Expected Output.json) -> tMap (to create JSON RequestBody) -> tAggregateRow (to get only the last generated string) -> tReplicate -> RestClient1 and RestClient2

I can get the response from both of these successfully. The problem is that they have dynamic JSON fields (doesn't look like a JSON field but a value).

Please see attached Response_1.json and Response_2.json for RestClient1 and RestClient2, respectively.

How can I extract these fields and process them to these:

Source and Expected Output.json
(This includes both Source and expected output)

P.S. There are also descriptions on the files on how it will be mapped. Let me know if you need more info.

Please help me. Thank you so much.

[Anonymous]

Glad I could help. You can return the favour by helping others as your experience grows 🙂

[Andreas_B1]

Hello,
this community thread has moved from https://community.talend.com/s/question/0D53p00007vClF4CAK/how-to-extract-values-from-dynamic-json-f... but it seems that the attachment of the json file was not migrated properly, so that the whole solution cannot be comprehended any more.
@jerownimow could you please reattach the file to this thread. Thank you