Forum Discussion

Drei's avatar
Drei
New Member
2 years ago

Microsoft Fabric Notebook data from API Error

Failed to upload blockAuthentication Failed with Access token validation failed   This is the error i always get when I try to import data from an API. It is a decent amount of data 36000 json file...
Need Help
v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi Drei 

 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

The “Access token validation failed” error typically occurs when there’s an issue with the authentication process. Here are some troubleshooting steps that might help you.

  • Check Your Authentication Credentials: Ensure that you have the correct access token or API key for accessing the StatsBomb API. Double-check that you’re using the right token in your Notebook.
  • Verify Token Scope and Permissions: Make sure your token has the necessary permissions to access the specific API endpoint. Some APIs require specific scopes (e.g., read, write, or specific data access). Confirm that your token has the required scope.
  • Token Expiry: Access tokens have a limited lifespan. Verify that your token is still valid. If it has expired, obtain a fresh token.
  • Rate Limiting: Some APIs have rate limits. Make sure you’re not exceeding the allowed number of requests per minute or hour.
  • Debugging with Postman: Use tools like Postman to manually test the API request. Capture a valid access token and simulate the API call outside your Notebook. Observe any error messages or issues.

I hope this information helps. Please do let us know in case if you have further questions.

 

Thanks.