Getting "Domo is ready, but the requested file does not exist." for Excel file

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    edited October 2023 Answer ✓

    Have you ensured that the excel file is shared with your OneDrive Domo account in OneDrive? And that the shared file name matches exactly including ".xlsx"?

    At my company we have a shared files master list dataset for onedrive that shows every file that has been shared properly to troubleshoot this exact situation.

    If I solved your problem, please select "yes" above

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Do you have a shared files master list dataset for onedrive that shows every file that has been shared? This has helped us many times in troubleshooting these types of errors. Use the OneDrive for business connector and select the Shared Items report type. Then look through the data and see if your file is there. If not, it has not been shared properly. If it is, copy and paste the name directly from the data table into the "Shared File Name" box in your other OneDrive connector.

    Screen Shot 2023-10-04 at 10.36.09 AM.png

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited October 2023 Answer ✓

    Have you ensured that the excel file is shared with your OneDrive Domo account in OneDrive? And that the shared file name matches exactly including ".xlsx"?

    At my company we have a shared files master list dataset for onedrive that shows every file that has been shared properly to troubleshoot this exact situation.

    If I solved your problem, please select "yes" above

  • ColeStuart
    ColeStuart Member

    I'm using the Microsoft OneDrive Business Connector to try and pull in an xlsx file into Domo. The file was shared with the Major Domo account at my company and when I log in and set it up the way several others are, yet still getting this error. What else can I try?

    Originally the excel file had a date in the filename like 9.27.2023, thought that was the issue and had the file renamed.

    I set this up yesterday and tested again today wondering if it might take a bit for the API to figure out the change, or Domo/OneDrive to refresh, but it's still not working.

    What else can I try?

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Do you have a shared files master list dataset for onedrive that shows every file that has been shared? This has helped us many times in troubleshooting these types of errors. Use the OneDrive for business connector and select the Shared Items report type. Then look through the data and see if your file is there. If not, it has not been shared properly. If it is, copy and paste the name directly from the data table into the "Shared File Name" box in your other OneDrive connector.

    Screen Shot 2023-10-04 at 10.36.09 AM.png

    If I solved your problem, please select "yes" above

  • ColeStuart
    ColeStuart Member

    Thanks ColemenWilson - I had not included the .xlsx as I thought that was done in the file type field, but it is also needed in the filename. That simple.

  • Gagliardi
    Gagliardi Member
    https://community-forums.domo.com/main/discussion/comment/78562#Comment_78562

    Great tip to try the "Shared Items" report. Helped me troubleshoot an issue I was having. If anyone else is having the issue I had getting Domo to find a file where Domo says "file does not exist": note that when using "Download Shared File (SharedWithMe Endpoint)" the name of that report is very literal. The Shared Items report revealed that One Drive files I owned were NOT in the list of Items shared with me. I had to Share the file with another users in OneDrive, then use their Domo - OneDrive account as the credentials for the report. None of the other report types seemed to work in connecting to files that I owned but hadn't shared when using my own Domo OneDrive Account.

  • ColemenWilson
    ColemenWilson Coach

    @gagliardi we created a service account to solve this very issue. Highly recommend!

    If I solved your problem, please select "yes" above

Categories