JSON Collection Help

jmt74eva

New Member
Hey all,

I've been looking around for a few days and trying various code stages to try and fix my issue but not getting any joy from it, so hoping someone might be able to point me in the right direction! :)

I'm using a webAPI and getting the JSON body into a collection because there is more than 1 value returned (I get a Multiple Paths error when I try to split it out from the response e.g $.entries[*].values) so I get a nested collection with rows inside that have them split out if you click into it.

To try and unest the collection I've tried a loop to a calculation to then append to a output collection so it's easier to work with. But I'm having an issue where the data being returned back has DateTime in one row but because the 2nd row at the same column point is blank its advising that its Text so it can't be appended/merged.

Any clues or ideas on how I might be able to get this to work?

Thanks in advance :)
 
Top