Connect QuickBook Desktop to Azure Data Factory

Question

Can we connect QuickBook Desktop using the API of Qucikbook and connect it with the HTTP connector of Azure Data Factory to fetch its data and import it to Azure SQL Database.

Answer 1

Hello @Shubhi Jain ,

Thanks for the question and using MS Q&A platform.

As I understand the ask here is whether we can connect to QucikBook Desktop using the API of QuickBook and connect it with HTTP connector of Azure Data factory to copy data to Azure SQL DB. Please correct me if I'm not accurate.

I'm not an expert with Quickbooks APIs but could you please confirm if you are able to connect QuickBook Desktop using API of Quickbook? I would recommend testing this first using Postman and see if you are able to connect from Postman. If you able to connect using Postman, then you should be able to connect using HTTP connector. If you are not able to connect using Postman, then I don't think you can achieve it with HTTP connector.

But here is the product team recommendation for copying data from Quickbook Desktop to Azure: The Copy Activity in the service cannot copy data directly from Quickbooks Desktop. To copy data from Quickbooks Desktop, export your Quickbooks data to a comma-separated-values (CSV) file and then upload the file to Azure Blob Storage. From there, you can use the service to copy the data to the sink of your choice.

Here is the reference doc: Copy data from Quickbooks Desktop

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators