Java Script Errors?

[Tally]

Hey guys I have the following json object in a Json column

I am trying to use the javascript column type to extract some details on from this object and save it to a column

This is the code I have and the result is just empty rows. Sos pls help

[Himaladin]

Why don’t you just use a Query JSON, it’s easier?

[Tally]

This is much easier for date. I really appreciate your help.

In regards to returning all “item_name” i have difficulty still

[ThinhDinh]

Try $.receipt.item_name

[Tally]

Once again buddy you’ve come through with the solution

[ThinhDinh]

https://try.jsonata.org/

This is a good playground for you on querying JSON.