Null value in API

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

Thanks in advance

2 comments

  • Alex LugoAlex Lugo Posts: 131Administrator, Lightspeed Staff moderator
    Hello,

    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 Posts: 3Member
    Perfect! Thank you for the quick reply! 
Sign In or Register to comment.