Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Make sure that you have a working report URL that is retrieving CSV
  2. Add the querystring parameter dateformat=googledocsAdd the querystring parameter columnheaders=firstrow if you want each column to be named

    Tip

    Your final URL should look something like this:

    https://app2.projectorpsa.com/report/code/variance?format=csv&UserName=YOUREMAIL&AccountCode=MYACCOUNTCODE&AuthToken=AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEEEEEEEE&columnheaders=firstrow&dateformat=googledocs

  3. Test your URL by cutting and pasting it into your web browser. The browser should download a csv file.
  4. Select the first cell in the Google Docs spreadsheet.
  5. In the value field, enter the following, replacing "url" with your own URL

...