Querying based blank and null values and date values

Hi,

I have some different columns. Som of the are blank ('') and some of them are null.

I would like to make an api call (using http endpoint for each data table), where I e.g. can retrieve all records where x column is null or where y column is blank ('').


Also, I can't get querying based on dates both unix epoch format and standard yyyy-mm-dd format to work.

Does anyone of you know how to do that?

3 replies