.REST API for reporting endpoint
- Vilhjálmur Hallgrímsson
The REST API web service enables communication between different software systems over the internet. REST APIs are widely used in modern web development as they provide a simple and standardized way of exchanging data between different systems, making it easier to build scalable and maintainable applications. The service uses HTTPS to encrypt communication between the client and server and uses secure requests to retrieve and send data, and is based on the principles of the REST architecture.
Instructions:
Format the URL with a table name and your token. https://dev.datistica.is/datistica/api/v1.0/public/<TABLENAME>?key=<TOKEN>
Retrieve and view your data in Google Sheets.
The URL format
API format
https://datistica.is/datistica/api/v1.0/public/<TABLENAME>?key=<TOKEN>&<PARAMS>
Please follow these guidelines to generate a token
An example of retrieving data from the table “landingF” using a token and parameters:
https://datistica.is/datistica/api/v1.0/public/landingF?key=ac4a190bd66e7126a3c3fbb5cd7011a3
Please note that this is just an example and the token in invalid. The request will fail.
Example of how to retrieve data from the TFM REST API using Google Sheets
Table names | API tablename | Paremeters |
|---|---|---|
DIM_CHOICES | choiceD |
|
DIM_LOCATIONS | locationD |
|
DIM_COORDINATES | coordinateD |
|
DIM_COUNTRIES | countryD |
|
DIM_DATE | surveydateD |
|
DIM_GEAR | gearD |
|
DIM_LANDING_SITES | siteD |
|
DIM_PARTIES | partyD |
|
DIM_SPECIES | specieD |
|
DIM_TENANTS | tenantD |
|
DIM_VESSELS | vesselD |
|
DIM_VSLCLASS | vesselclassD |
|
FACT_LANDINGS | landingF | &dateFrom &dateTo |
FACT_LICENSES | licenseF | &dateFrom &dateTo |
FACT_LOCATIONS | locationF |
|
FACT_VESSELS | vesselF |
|
LANDINGSVIEW | landingV | &dateFrom &dateTo |
PARTIESVIEW | partyV |
|
LICENSEVIEW | licenseV | &dateFrom &dateTo |