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!
Hi Use two tExtractJson to extract data from each array, then, merge the output if needed. eg: tRest--main--tReplicate--main--tExtractJsonField1 --main---tExtractJsonfField2
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.
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
