How to search for Null or empty values?
VintageWineGuy
Member Posts: 131
How do you search for Null or empty values in the Retail API? I am trying to return everything where Custom SKU is null, but apparently don't know the right twist. I have tried customSku=, null and 0 or =!~,% and haven't found it. It may be a noob question - I am working in python, not as familiar with PHP, and don't know if this is a standard implementation of some query format I don't know, or something custom.
Currently I am using : GET /API/Account/{}/Item.json?customSku=!~,%2%
Which works because all of my correctly filled in Custom Skus start with 21, but I would rather look for nulls.
Any help appreciated. The examples in the doc are pretty light - I would love to see more examples in it.
Best Answer
-
LucienVersendaal
Moderator, Lightspeed Staff Posts: 991 moderator
Hi @VintageWineGuy,
Thank you for contacting us.
Yes this is possible, when you do:
/Item?customSku=~,
you'll get the result that you want.
I hope this helps.
Answers
Thank you!