topic tExtractJSON where JSON return is 2 arrays in Talend Studio

tExtractJSON where JSON return is 2 arrays

Anonymous — Sat, 16 Nov 2024 03:59:48 GMT

Hi,

I'm looking for some help with extracting the data from the JSON return below. I don't know if I need to do the extraction in 2 different tREST/tExtractJSON sections or if it can be done within. I need id, name, state from the sprints sections and estimated.value, estimated.text, completed.value, completed.text from the velocityStatEntries section. Any help would be much appreciated!

Re: tExtractJSON where JSON return is 2 arrays

Anonymous — Thu, 28 Nov 2019 03:57:28 GMT

Hi
Use two tExtractJson to extract data from each array, then, merge the output if needed. eg:
tRest--main--tReplicate--main--tExtractJsonField1
--main---tExtractJsonfField2

Regards
Shong

Re: tExtractJSON where JSON return is 2 arrays

Anonymous — Mon, 02 Dec 2019 13:57:09 GMT

The second set of values is dependent on the first. If you look at my attached image this is not possible because I don't know the top level array value to be able to dig into each set.

Re: tExtractJSON where JSON return is 2 arrays

laurbass — Tue, 14 Jul 2020 14:29:31 GMT

How would I reunite the data after extracting it in this way?

Re: tExtractJSON where JSON return is 2 arrays

vikramk — Thu, 16 Jul 2020 14:46:35 GMT

As I know parent being different you can't fetch all fields into same table. Even I have this kind of requirement, Please let me know if you find out a solution for this