Get sheet data in real-time using a HTTP request

Requires a Business subscription plan

Each sheet is assigned a unique Live Data URL which you can enable via the Web Application. The Live Data URL allows you to pull data into your system from an Orca Scan sheet using a simple HTTP GET request, for example:

https://api.orcascan.com/sheets/sJ0KYsnp-9b7Rl7i

Change format

You can change the format of the data by appending a file extension, for example https://api.orcascan.com/sheets/sJ0KYsnp-9b7Rl7i.json

The available formats are:

Extension Format Content/Type
.html HTML (default when no extension provided) text/html
.csv CSV (Comma-separated values) text/plain
.json JSON (JavaScript Object Notation) application/json
.xml XML (Extensible Markup Language) text/xml

Include audit trail

You can request all historical changes by appending transactions=true to the URL, for example https://api.orcascan.com/sheets/sJ0KYsnp-9b7Rl7i?transactions=true

An additional row will be added for every change along with three additional columns.

Changed By Changed On Changed Using
user@email.com 19/05/2019, 17:25:09 Chrome 74 (Mac OS)
user@email.com 08/06/2019, 14:19:04 Thomas's iPhone
user@email.com 07/06/2019, 15:31:07 Samsung Galaxy S9

You can request only the changes after a particular period by providing a date in ISO date format using the from param, for example:

https://api.orcascan.com/sheets/sJ0KYsnp-9b7Rl7i?transactions=true&from=2019-06-12T00:00:00

Include deltas

Appending deltas=true to the Live Data URL along with transactions=true will add an additional column containing the delta for each numerical column change, for example:

https://api.orcascan.com/sheets/sJ0KYsnp-9b7Rl7i?transactions=true&deltas=true

Barcode Quantity Quantity (delta)
6344554293308 96 96
6344554293308 10 -86
6344554293308 20 +10

By default the first delta value always matches the first numeric value. You can change this to 0 by appending zerodeltabase=true to the URL.

Change date format

By default all dates are returned in ISO 8601 format. You can change the format using the datetimeformat querystring parameter with the desired format. Date formats are a combination of tokens, for example:

https://api.orcascan.com/sheets/sJ0KYsnp-9b7Rl7i?datetimeformat=DD MMM YYYY

The available tokens are:

  Token Description Example
Day D Day in single digit format 2
  DD Day in double digit format 02
Month M Month in single digit format 3
  MM Month in double digit format 03
  MMM Month in 3 character format Jan, Feb
  MMMM Full name of month January, February
Year YY 2 digit year 19
  YYYY 4 digit year 2019
Hour H 1 digit hour 3
  HH 2 digit hour 03
Minute m m digit minute 3
  HH 2 digit minute 02

Change time zone

Date and times are returned in UTC (timezone 00:00) format. You can adjust the time zone by providing a timezone offset along with datetimeformat parameter, for example:

https://api.orcascan.com/sheets/sJ0KYsnp-9b7Rl7i?DD/MM/YY HH:mm&timezone=-10:00

The available offsets are:

Offset Region
-12:00Eniwetok, Kwajalein
-11:00Midway Island, Samoa
-10:00Hawaii
-09:30Taiohae
-09:00Alaska
-08:00Pacific Time (US & Canada)
-07:00Mountain Time (US & Canada)
-06:00Central Time (US & Canada), Mexico City
-05:00Eastern Time (US & Canada), Bogota, Lima
-04:30Caracas
-04:00Atlantic Time (Canada), Caracas, La Paz
-03:30Newfoundland
-03:00Brazil, Buenos Aires, Georgetown
-02:00Mid-Atlantic
-01:00Azores, Cape Verde Islands
+01:00Brussels, Copenhagen, Madrid, Paris
+02:00Kaliningrad, South Africa
+03:00Baghdad, Riyadh, Moscow, St. Petersburg
+03:30Tehran
+04:00Abu Dhabi, Muscat, Baku, Tbilisi
+04:30Kabul
+05:00Ekaterinburg, Islamabad, Karachi, Tashkent
+05:30Bombay, Calcutta, Madras, New Delhi
+05:45Kathmandu, Pokhara
+06:00Almaty, Dhaka, Colombo
+06:30Yangon, Mandalay
+07:00Bangkok, Hanoi, Jakarta
+08:00Beijing, Perth, Singapore, Hong Kong
+08:45Eucla
+09:00Tokyo, Seoul, Osaka, Sapporo, Yakutsk
+09:30Adelaide, Darwin
+10:00Eastern Australia, Guam, Vladivostok
+10:30Lord Howe Island
+11:00Magadan, Solomon Islands, New Caledonia
+11:30Norfolk Island
+12:00Auckland, Wellington, Fiji, Kamchatka
+12:45Chatham Islands
+13:00Apia, Nukualofa
+14:00Line Islands, Tokelau

Get Live Data Url

You can find the data URL on any of your sheets.

1. Go to Integrations settings

Opening the sheet integration menu

2. Activate the URL and copy the link

Activating the Orca Scan live data URL

3. Save the updates

Saving the integration changes

Next steps

Questions about the Live Data URL?

We're happy to help you troubleshoot any issues, chat with us live or drop us an email.