# SharePoint Rest API Error 'java.sql.SQLException: Access token is required.'

**URL:** <https://matillioncommunity.discourse.group/t/sharepoint-rest-api-error-java-sql-sqlexception-access-token-is-required/2227>\
**Category:** Matillion ETL\
**Created:** [June 6, 2023, 1:24am UTC](https://matillioncommunity.discourse.group/t/sharepoint-rest-api-error-java-sql-sqlexception-access-token-is-required/2227 "2023-06-06T01:24:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![swathi.rayapu](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@swathi.rayapu](https://matillioncommunity.discourse.group/u/swathi.rayapu)\
**Post date:** [June 6, 2023, 1:24am UTC](https://matillioncommunity.discourse.group/t/sharepoint-rest-api-error-java-sql-sqlexception-access-token-is-required/2227/1 "2023-06-06T01:24:17Z")

</div>

Hi everyone, I'm stuck with this error for a couple days now and any help will be greatly appreciated.

&nbsp;

I'm trying to read an excel file from SharePoint to Azure Blob and I'm getting this error 'java.sql.SQLException: Access token is required.' These are the steps I followed:

&nbsp;

1. Registered new app in Azure Portal. Configured Matillion as redirect url. Generated Client Secret. Provided API permissions 
2. Configured Oauth in Matillion. Manager Oauth \> configured and authorization is successful.
3. When I try a test job using Data Tranfer' component I get this error &nbsp;'java.sql.SQLException: Access token is required.' 

&nbsp;

Looks like I missed a step in the configuration? But I don't what it is.

&nbsp;

Thank you.

---

<div class="post-metadata">

**Author:** ![swathi.rayapu](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@swathi.rayapu](https://matillioncommunity.discourse.group/u/swathi.rayapu)\
**Post date:** [June 6, 2023, 3:44am UTC](https://matillioncommunity.discourse.group/t/sharepoint-rest-api-error-java-sql-sqlexception-access-token-is-required/2227/2 "2023-06-06T03:44:41Z")

</div>

Oh, I just found out that it is a known issue and the workaround Matillion mentioned here works.

https://support.matillion.com/s/article/ErrorAccesstokenisrequiredwhentryingtopullSharepointFilewithDataTransferComponent