I am wondering if anyone has had the same issue and hoe they solved it. I have a private app with in hubspot. Using the following API it is supposed to return the data that is in the contacts table in the CRM.

: pat-*****&Accept=application/json

I have run the same url on postman, and after having to use OAuth, it returns the content of the table.

Using the copy data activity within Azure Data Factory, and the linked service REST, the connection is OK. But when it is run no data is returned.

Can anyone suggest why I am not getting any data returned? Using REST API means I can bypass Authentication by using the Bearer: though it need Authorization with the same command in Postman, initially.

Is there some outer Authorization I need to do?

In the copy source

When I try to view the data, I get this error

23353 Details Rest call failed with client error, status code 401 Unauthorized, please check your activity settings. Request URL: . Response: {"status":"error","message":"Authentication credentials not found. This API supports OAuth 2.0 authentication and you can find more details at

Any help would be truly appreciated.

Thank you