search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
16.05k stars 4.11k forks source link

[source-quickbooks] Error while running sync job and testing connection with quickbooks #41288

Open spac30 opened 3 months ago

spac30 commented 3 months ago

Connector Name

source-quickbooks

Connector Version

3.0.8

What step the error happened?

During the sync

Relevant information

I have connection from quickbook to bigquery. I have this error while running sync job and while testing the quickbook connector connection. Checked online platform like stackoverflow error 401 is for authentication failed. But here I am using new refresh token and access token.

Not sure what is wrong here.

Relevant log output

'Unable to connect to stream accounts - Request to https://quickbooks.api.intuit.com/v3/company/{ACC_ID}/query?query=SELECT+%2A+FROM+Account+WHERE+Metadata.LastUpdatedTime+%3E+%272023-01-01T00%3A00%3A00%2B00%3A00%27+AND+Metadata.LastUpdatedTime+%3C%3D+%272023-01-31T00%3A00%3A00%2B00%3A00%27+AND+Active+IN+%28true%2C+false%29+ORDER+BY+Metadata.LastUpdatedTime+ASC+STARTPOSITION+1+MAXRESULTS+200 failed with status code 401 and error message None'

Contribute

marcosmarxm commented 3 months ago

Thanks for reporting the issue @spac30 Quickbooks is a community connector and it isn’t in the current roadmap for improvements. If you want to contribute fixing the issue please reach me out in Slack so I can provide you instructions to make the contribution.