Quickbooks REST API

  • 4
  • Question
  • Updated 2 years ago
  • Answered
We tried to get data from Quickbooks. But since it's Oauth1 we noticed, that can be quite a pain.

Quickbooks API:
https://developer.intuit.com/docs/0050_quickbooks_api

Quickbooks Authentication and Authorization:
https://developer.intuit.com/docs/0150_payments/0060_authentication_and_authorization/connect_from_w...

That's what we have so far:

Authentication Provider:


Model Service:


Settings on Inuit dev-account:


Model properties on page:


When we load the page, a popup appears:


Error on page:
1. Error retrieving metadata for Model(s) associated with Data Source 'Quickbooks'. Please check Models' properties to ensure they are set correctly. Error connecting to REST Data Source at URL "https://sandbox-quickbooks.api.intuit.com/v3": Unable to authenticate to service "Quickbooks": Login has been cancelled

If someone knows how to get a step further, we would appreciate that.

Cheers
Photo of JG GBC

JG GBC

  • 694 Points 500 badge 2x thumb

Posted 3 years ago

  • 4
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
Unfortunately, OAuth 1.0 is not currently supported for Skuid Authentication Providers --- the presence of OAuth 1.0 in the dropdown for Authentication Method is due to a regression, it should not be available to select. So unfortunately Quickbooks is not a possible endpoint to connect to with Skuid right now.
Photo of JG GBC

JG GBC

  • 694 Points 500 badge 2x thumb
Thank you for the response....
Photo of Craig Rosenbaum

Craig Rosenbaum

  • 4,776 Points 4k badge 2x thumb
Zach, is this still not possible in Rockaway? QB integration via Skuid would be very helpful for lots of us as I'm sure you know. I just don't want to put our resources into it if its not possible right now.
Photo of Mansour

Mansour

  • 1,932 Points 1k badge 2x thumb
We have been able to achieve this leveraging a middleware called cData (http://www.cdata.com/) - http://www.cdata.com/drivers/qbonline/cloud/

This is an odata layer that allows you to connect Skuid to all tables in QB.