Using Get or Has filter with nested JSON

Mike Akister

I am returning JSON from a webhook and it seems that when a value is null, they just don't include it rather than passing a null. This always produces errors when using dot notation and I am unable to capture all the data I need due to this.

I would like to implement this solution, https://community.xano.com/discussion/876844/set-ifhas-conditional-filter but I can't figure out how to use Get or Has with nested JSON as per the image (the icao field is not included in the from Airport)

Michael Udinski

Hi @Mike Akister - It depends what you're doing but I would recommend GET personally especially if you're adding data to your database

Mike Akister

I ended up solving it using dot notation to get to the From JSON and then using a GET filter with a default value of null from that point.

Michael Udinski

Great! You can combine GET and dot notation, GET sort of acts like a "dot" but with the option to have that default value