intuit / oauth-jsclient

Intuit's NodeJS OAuth client provides a set of methods to make it easier to work with OAuth2.0 and Open ID
https://developer.intuit.com/
Apache License 2.0
119 stars 153 forks source link

Can't send "query" request - 400 error (SELECT * FROM ... WHERE DisplayName LIKE ...) #129

Open Twisterking opened 2 years ago

Twisterking commented 2 years ago

I have the following query:

  const selectStatement = `SELECT * FROM Customer WHERE DisplayName LIKE '%MFM 58%'`; // does NOT work!
  // const selectStatement = 'SELECT * FROM Customer'; // works just fine! :)
  const resp = await oauthClient.makeApiCall({
    url: `https://sandbox-quickbooks.api.intuit.com/v3/company/${realmId}/query?query=${selectStatement}&minorversion=65`,
    method: 'GET'
  });

This does NOT work!

I always get a 400 Bad Request - but everything is just fine! NO problems with the auth, because the following selectStatement works just fine: selectStatement = 'SELECT * FROM Customer' ... so what gives? I don't see what is wrong with my call!

Twisterking commented 2 years ago

Is anyone taking care of this repo here? This is still not working!

Twisterking commented 1 year ago

bump ...