Can I query for Estimates with NULL ClassRef in Quickbooks API v3?

Question

According to the documents, you should be able to query for NULL ClassRef values like so:

select * from Estimate where ClassRef = ' '

But, that query is causing a validation error:

{
  "Fault": {
    "Error": [
      {
        "Message": "Invalid ID",
        "Detail": "Id should be a valid number. Supplied value: ",
        "code": "2030",
        "element": "ClassRef"
      }
    ],
    "type": "ValidationFault"
  },
  "time": "2014-06-19T12:34:43.37-07:00"
}

How can I query for null ClassRefs?

score 1 · Accepted Answer · answered Jun 20 '14 at 10:36

No you can't search by ClassRef because it is not a filterable attribute for the Estimate entity.

References:

Can I query for Estimates with NULL ClassRef in Quickbooks API v3?

1 Answers1