Can the QuickBooks Online driver pull data on Reports? I'm not seeing the Profit & Loss report, or any other reports, in the list of tables and views.
Best answer by Elizabeth G
View original
The driver can indeed pull this data. As they use stored procedures rather than tables or views, you can run that report's stored procedure (such as CreateProfitAndLossDetailReport) to view data from that particular report. A list of stored procedures for the v22 version of the driver can be found at the link below, but the most up-to-date list will be on the documentation on the website.
https://cdn.cdata.com/help/RNH/xls/pg_allsps.htm
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers