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.