Null value in API

scaphanscaphan Member Posts: 3
how do I get records with a null value in a text field? Tried null , “null” and “” but none work. 

Thanks in advance


  • Alex LugoAlex Lugo Administrator, Lightspeed Staff Posts: 152 moderator

    You can achieve this by using this operator in your query =~,.

    The call below will list all my customers without a company assign to them:
    GET /API/Account/{accountId}/Customer.json?company=~,
    Alex Lugo
    API Support Specialist
    Lightspeed HQ
  • scaphanscaphan Member Posts: 3
    Perfect! Thank you for the quick reply! 
Sign In or Register to comment.