Skip to main content

The Cdata data source for QuickBooks Online doesn’t have all the endpoints in the API available. For instance TaxPayments is missing. (https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/taxpayment)

It is possible to add rsd-files to the file folder in order to get additional tables when synchronizing data. However, there is no sample rsd-file available, and no obvious way to generate schema file. I have tried to copy a rsd file from a REST connector, but then I get the error message when trying to preview: “The operation ‘jsonproviderGet’ could not be found”

Hi @jarle 

I don’t know which one you are using, but I found that I have three different versions.

It may be that the POS one is discontinued, but the two others seem to still be updated.

I don’t know what the major differences between these are or if they even return similar things. Perhaps the online is giving back what the other is missing.

Otherwise we have requested info about missing tables to CData. It is not really possible to add RSD files to this as it isn’t installed locally.

I think I am using the correct connector, because Quickbooks Online is the only one with API functionality like OAuth authentication. The other ones are apparently to the desktop version of the program and POS.

@jarle 

Do you have a list, besides TaxPayments of tables that is missing.

Here is the list of tables. https://cdn.cdata.com/help/RQK/ado/pg_alltables.htm

Here is the list of views. https://cdn.cdata.com/help/RQK/ado/pg_allviews.htm

What do you get if you run the following query against the provider?

SELECT * FROM sys_tables

 

Hi,

The links you mention are for the Desktop version.

These are the links for the online version:

https://cdn.cdata.com/help/RNK/ado/pg_alltables.htm
https://cdn.cdata.com/help/RNK/ado/pg_allviews.htm

I haven’t made a full comparison of this, but for those starting with “tax”, it is like this:

  • TaxClassification = Missing
  • TaxCode = TaxCodes
  • TaxPayment = Missing
  • TaxRate = TaxRates
  • TaxService = Missing
  • TaxSummary = Missing
  • TaxAgency = TaxAgency

It works to run the query as a query table. I then get a list of the tables and views specified in the Cdata documentation:

 

Reply


Terms and ConditionsCookie settings