0

I have a spreadsheet that analyzes data uploaded into a sheet from a .csv file that is downloaded from my store for various operations and reports that I extract from it. I would like to know if there is a method to make calls directly to my store database to retrieve the report automatically so the sheet always has up to date info.

0

Try IMPORTDATA

Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

Sample Usage

IMPORTDATA("http://www.census.gov/2010census/csv/pop_change.csv")

IMPORTDATA(A2)

  • A very useful tool indeed! Unfortunately, I am learning that IMPORTDATA requires a publicly accessible webpage and my data is sensitive. I am turning to look into an API call to the database instead using my API key and store url. I found a 3dCart API Loader that allows me make queries. Now I need to develop the proper query to return the data set I need (Top Products, Last 30 Days, With Item Options Considered) and it will be complete. Thank you! – Gary D Dec 22 '18 at 17:58
  • Please edit your question to add all the relevant details of what you are looking for. – Rubén Dec 22 '18 at 22:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.