tExtractJSON where JSON return is 2 arrays

[Anonymous]

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!

[Anonymous]

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

[Anonymous]

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.

[laurbass]

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

[vikramk]

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