Quickbooks Online: How Can I Query any QBO resource using OR or JOIN operators?

 

Quickbooks Online has the following CEQL limitations:

  • OR operator is not supported in where clauses;
  • GROUP BY and JOIN operator are not supported; 
  • Wildcard character support with LIKE clauses is limited to “%” (wildcard that substitutes for 0 or more characters);
  • The response set returns all properties for each object (that is, projections are not supported).