oauth-jsclient icon indicating copy to clipboard operation
oauth-jsclient copied to clipboard

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

Open Twisterking opened this issue 3 years ago • 2 comments

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 avatar May 30 '22 14:05 Twisterking

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

Twisterking avatar Jun 20 '22 14:06 Twisterking

bump ...

Twisterking avatar Jan 11 '23 09:01 Twisterking