Download/Use Data of Onedrive Shared Link / Excel Online

As a Workaround, I only see putting the customer's Excel on our own Onedrive Account,

Hi @reservoirdog,

Did the client provide you with his connection user/pw? and make the file sharable?

Hi @itay

Nope, no credentials (I think it's his private/company account), and the Excel is read-only.

That might be the reason why you cannot get the connection working and get to the xls file.

Yea, I already realized that the OnedriveConnector only works if you have full credentials. But that means you can only work with files you are hosting on your own account. I thought there is a way to work with these "shared links", as I can download the Excel via Excel Online without any problem (manually). Perfect would be direct Read-Access on any "Office Online" Files...

Hi @reservoirdog, I think you are correct, accessing a file through a shared link is currently not possible. We would love to get a better understanding of the community's interest in this. And it would be really helpful if you could add your suggestion as a new Idea here.

Hi @reservoirdog

Have you tried to connect through Microsoft Graph API (https://knowledge.safe.com/questions/76488/connection-to-microsoft-graph-api.html ) ? This should work given the right permissions.

Hey @sigtill, thx for your hint!

We solved it hosting the Excel on our own Onedrive Account so that we could easily access it.

If I have a similar case in the future I will get back to your suggestion...

can you share with me how to access onedrive file (xlsx) in personal onedrive account. I tried to use OnedriveConnector (graph) but it failed authentication after i typed my username, passcode sent to my phone.

this is an error message i got after using OnedriveConnector (graph). Can you advise what i should do?thanks.

Hi @pinkautumn,

If you are using a personal OneDrive account you should be able to access it using the default Microsoft OneDrive (Graph) web service rather than the Microsoft (Graph) web connection that is provided on the FME Hub. Are you able to try creating a new web connection in the OneDriveConnector transformer and authenticating using the Microsoft OneDrive (Graph) web service?

I believe the Microsoft (Graph) web connection from the hub should only be required if you are trying to connect to an Azure portal enterprise account.

Hope that helps.

Hi @chrisatsafe thank you for your feedback, yes, i am trying to create a new web connection in the OneDriveConnector transformer and authenticating using the Microsoft OneDrive (Graph) web service in FME 2019.1. After logging in my personal username and password for Onedrive, click Next it asks for verification code sent to my mobile number, after that it showed the error msg that i shared in previous post. I succesfully logged in my Onedrive in portal.office.com outside FME.

Is it possible that you can share with me the screenshot of step that you suggest me to follow in order to successfully connect to onedrive on FME workflow? Thanks and best regards.

Unfortunately I don't have any screenshots of this as I haven't done it myself but do you have admin consent for this and have you tried clearing your cookies before attempting to login re-connect?

Additionally, just to confirm, have you met all of the requirements on https://hub.safe.com/publishers/gerhardatsafe/web-connections/microsoft-graph