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

Matillion ETL
1

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

 

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:

 

  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  'java.sql.SQLException: Access token is required.'

 

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

 

Thank you.

2

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