OAuthToken and OneD...
 
Notifications
Clear all

[Sticky] OAuthToken and OneDrive connection

7 Posts
2 Users
0 Likes
287 Views
Active Member
Joined: 12 months ago
Posts: 4
Topic starter  

Hello, can anyone please explain to me in a little more detail how to make a connection with a OneDrive excel file located on a share location? First of all, I want to create an OAuthToken connection that I will later use for the OneDrive connection to the excel file using the "use token connection" option (predefined checkbox on jedox connection). When I create OAuthToken and use oauth2PasswordCredential and enter my data from O365 and use Access token scope "openid" and Client auth.type body I get error 403 even though everyone has the right to share folder.
I am asking for more detailed instructions on how to create an OAuthToken that is connected to OneDrive and Azure App ID, because the knowledge base on the page is quite "poor"
Thanks in advance


   
Quote
Jedox 4 Beginners
Trusted Member Admin
Joined: 3 years ago
Posts: 32
 

Hi Adis,

Maybe this integrator job can help you.

 

This post was modified 12 months ago 2 times by Jedox 4 Beginners

   
ReplyQuote
Active Member
Joined: 12 months ago
Posts: 4
Topic starter  

Thank you for your reply.
First I need to establish a connection with that excel file that is on onedrive and after that I need to do the whole ETL process.
I successfully establish a connection with OAuthToken, but when I try to establish a connection with an excel file using OAuthToken, I get various errors


   
ReplyQuote
Jedox 4 Beginners
Trusted Member Admin
Joined: 3 years ago
Posts: 32
 

Hi Adis, could you upload some screenshots of errors so we can check the reason behind them?

Thanks


   
ReplyQuote
Active Member
Joined: 12 months ago
Posts: 4
Topic starter  

Hi, 

this is OAuthToken


   
ReplyQuote
Active Member
Joined: 12 months ago
Posts: 4
Topic starter  

And this is Excel error via OAuthToken


   
ReplyQuote
Jedox 4 Beginners
Trusted Member Admin
Joined: 3 years ago
Posts: 32
 

Hi Adis,

did you try something like this C:\Users\adis.prijic\Documents/Desktop/OSA.xlsx for the File Name?


   
ReplyQuote
Share:

Join the Jedox4Beginners forum and engage with a community of passionate Jedox users. Get expert advice, share insights, and find solutions to your Jedox-related queries. Unlock the power of collaboration and accelerate your learning journey in the world of Jedox.

Join the Jedox4Beginners forum!