azureapiazure-data-factoryquickbooks-online

API to retrieve QuickBooks Online General Ledger Data with Azure Data Factory


I'm trying to use Azure Data Factory to connect to QuickBooks Online General Ledger using OAUTH2. My approach is to first create a pipeline with a Web Activity to perform a POST call to receive the authentication token, then create a Copy Activity to read a JSON returned from QuickBooks. My approach is based on this blog. from Alex Volok Consultancy.

I have been unable to use the Web Activity successfully. I am unsure of the parameters and how to configure the Web Activity but have tried many different combinations trying to get this to work.

My desired result is to get QuickBooks Online data into Azure, is this the correct approach?

If this is not the best approach, what is?

If this is the correct approach, the attached screenshot shows my attempt at creating the Web Activity parameters to retrieve the authentication token that is currently not working. Any help is appreciated.

Azure Data Factory Web Activity


Solution

  • Please follow the below approach. It will solve your problem.

    Sample URL : http://restapi.adequateshop.com/api/authaccount/login

    Postman:

    Using Postman, I generated a bearer Token for testing.

    enter image description here

    I used the same URL with web Activity and generated a bearer Token in the Azure data factory.

    Use Your User id and Password as Body.

    enter image description here

    Output:

    enter image description here

    For more information refer this SO Thread and Blog by Ashok Patel