How can i connect QuickBooks data with our ETL using an API integration?

Hello there, a-lugaresi-dorel.

I'll direct you to someone who can help you connect QuickBooks data with your ETL using API integration. 

We have a separate online forum called the Intuit Developer Community, where you can post this type of question. I suggest contacting them as they can provide insights and guide you through downloading the order and invoices line to integrate data in your BI.

I'm adding these articles with the topics you can use while recording the customer transactions: 

• The Customer Transaction Workflows in QuickBooks Desktop.
• QuickBooks Desktop Help Articles. This link provides some tips and tricks for managing your QuickBooks account. It guides you in completing your future tasks.
  

You can always post here if you have other questions about QuickBooks Desktop. Take care and stay safe!

@a-lugaresi-dorel 

Which BI app do you have?

We use Pentaho with Microsoft SQL Server DB.

Click on my profile name and you will find our website address to send an email to. We will introduce you to a 3rd party provider. They have developed a connector for your needs to pull data from QBO to Data Warehouse and you can integrate it with Pentaho.

You can connect QuickBooks data to your ETL using the QuickBooks Online API if you’re comfortable working with REST APIs. For a no-code option, platforms like Skyvia offer prebuilt connectors that let you move and transform QuickBooks data without custom development.