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
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
Hi Adis, could you upload some screenshots of errors so we can check the reason behind them?
Thanks
And this is Excel error via OAuthToken
Hi Adis,
did you try something like this C:\Users\adis.prijic\Documents/Desktop/OSA.xlsx for the File Name?
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.
