Troubleshooting 403 Unauthorized Access and Table Not Found Errors in Azure Data Factory Integration

Question

Hello Microsoft Community,

I'm working on integrating HubSpot data with Azure Data Factory (ADF) using the Hubspot Linked Service and facing two distinct issues that I need assistance with:

Unauthorized Access Error (HTTP Response code: 403): While attempting to retrieve data through an ADF pipeline, I'm receiving an "API Connection Failed (Unauthorized Access)" error. I've verified the credentials, updated the access and refresh tokens, and ensured proper permissions, but the issue persists.

Table or View Not Found Error: In another activity within the same pipeline, I'm encountering an error that a specific table or view is not found (Hubspot.Hubspot.ad_campaigns). The reference seems to include a doubled schema or database name, and I'm unsure if this is a misconfiguration on my side or something specific to the HubSpot schema.

Here's what I've tried so far:

• Refreshed the access and refresh tokens.
• Checked the OAuth scopes to ensure all necessary permissions.
• Recreated the linked service in Azure Data Factory.
• Verified the query and table references.

Despite these efforts, the issues remain unresolved. I'm looking for guidance on the following:

• How can I troubleshoot the 403 Unauthorized Access error further to understand what might be causing it?
• How can I verify the correct table or view name for the ad_campaigns object within the HubSpot schema?
• Is there anything specific to HubSpot's integration with Azure Data Factory that I need to be aware of to resolve these errors?

Any insights, suggestions, or resources would be greatly appreciated. If additional details are needed, I'm happy to provide them.

Please keep in mind that my ad_campaigns and all other tables I'm trying to access are custom objects within my Hubspot account

Thank you for your assistance!

Answer 1

Recommendations:

Dive deeper into the error logs in ADF. They might provide more specific details about the unauthorized access error.

Reach out to HubSpot's support or community. They might have insights into common issues with ADF integration, especially concerning custom objects.

Set up a test environment in ADF with a smaller dataset from HubSpot. This can help you isolate and troubleshoot issues without affecting the main pipeline.

In summary, for the 403 error, delve deeper into API key validity, IP whitelisting, and rate limits. For the table not found error, recheck the schema reference and the setup of custom objects in HubSpot. Always ensure you're using the latest connectors and refer to official documentation for any nuances in integration.

Please mark if my answer helped you :-)