Method Community

Method:CRM

 

Method Community » Method:API » Method:API Q&A » Finding a blank

Finding a blank

Last post 07-18-2019 3:42 PM by boblaw. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 07-18-2019 10:55 AM

    Finding a blank

    Reply Contact
    I am using your API and running a query on our customer table to locate accounts where a specific field is blank (salesrep). I am unable to pull "blanks" or "Null" values. Is there a specific method to return empty fields via your API? Is there a LEN() function in your API strWhereClause?

  • 07-18-2019 2:17 PM In reply to

    Re: Finding a blank

    Reply Contact

    Try using:

    SalesRep IS NULL

  • 07-18-2019 3:42 PM In reply to

    Re: Finding a blank

    Reply Contact

    Perfect. Thanks Hossein
Page 1 of 1 (3 items)