OneDrive Excel url with paramters
Hopefully my question will make sense! I have a spreadsheet to display a salesman's quote. I created a tab to display the information. I step through the Get Data wizard > From File > JSON > and specified my URL to our ERP system. This created a data tab with my imported JSON data. Everything works. What I'm hoping I can do is leave this Excel spreadsheet on our SharePoint / OneDrive and email links to it with parameters embedded in the URL. Ideally the URL would have parameters which would be used in the REST API call. Or should I try to upload spreadsheets to our OneDrive and then use the URL to tell which to use as a data source? Thanks in advance.