Maps->AddLayerFromWeb referencing a csv file from onedrive fails

[KarenLankton_Schmidt]

We are using the Maps->AddLayerFromWeb referencing a csv file from onedrive and it fails with error

"The layer was not created because no locations could be found. Make sure your data has valid location information."

The URL's we are using shows the file correctly when pasted in a browser.

SharePoint and DropBox URL's produce the same results.

The csv file can be dropped into a map and works correctly so the file appears correct.  Latitude and longitude are provided.  Any ideas on what is failing?

[DanPatterson]

It happens with onedrive, dropbox and the like

Cannot add CSV layer from OneDrive to AGOL map. - Esri Community

If drop from there works, then you may have to use that approach.

I have never found the virtual "drives" a consistently safe place to add data from, I usually move to a local drive and add from there.

There are a number of links in the Community related specifically and tangentially to this issue.  The above link is only one example

[KarenLankton_Schmidt]

We finally got it working on One Drive by modifying the Files Embedded URL which looks like this "<iframe src="https://onedrive.live.com/embed?cid=5678909876654443&resid=5678909876654443%2127378&authkey=AGLJgfj8..." width="98" height="120" frameborder="0" scrolling="no"></iframe>"
with
"https://onedrive.live.com/download?cid=5678909876654443&resid=5678909876654443%2127378&authkey=AGLJg..."

I would agree that this is not a safe or robust way to do this. But this is for a prototype for proof of concept and would not be done this way in a production system.

Thanks for your response.