Not able to connect QuickBooks online through Azure Data Factory

Sanjeev Kumar 1 Reputation point
2022-02-15T16:51:47.647+00:00

ERROR [HY000] [Microsoft][QuickBooks] (60) API Connection Failed (Unauthorized Access). Check credentials. HTTP Response code: 403 ERROR [HY000] [Microsoft][QuickBooks] (60) API Connection Failed (Unauthorized Access). Check credentials. HTTP Response code: 403 Activity ID: 4abbf38e-bf9d-4fd0-9398-7ede4c5dcb57

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,540 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee
    2022-02-16T16:22:03.327+00:00

    Hi @Sanjeev Kumar ,

    Thank you for posting query in Microsoft Q&A Platform.

    Could you please share more details on your implementation and where exactly you are facing this error?

    Are you making API call to quickbooks?
    Are you using quickbooks connector in ADF?
    Are you using Quickbooks dataset as source in Copy activity?

    From error message it seems access related issue. If you have created linked service using quick books connector then kindly check is test connection is getting successful?

    Kindly check is your client ID getting used for Quick book has all roles and permissions to make API call?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.