Hello,
I have a column 'Data' as a json, in which I would like to get the "sku" numbers:
{"ware":"AA","Stkiten":[{"sku":"1","requested":1,"available":0},{"sku":"2","requested":1,"available":0}]}
First I take what is inside the Stkiten "Data" ->> 'Stkiten', giving me back:
[{"sku":"1","requested":1,"available":0},{"sku":"2","requested":1,"available":0}]}
when I try to take from this new column I created (transforming it as a ::JSON), I can't, and I think is because of the '['.
Could somebody help me, please?
Thank you