Freight Data - Unnamed resource

Unknown

Download URL: https://opendata.transport.nsw.gov.au/system/files/resources/2%20Road%20safety_3.xlsx

Details
Last updated	14/08/2018
Date Created	14/08/2018
File format	XLSX
Licence	License Not Specified

There are no views created for this resource yet.

Additional Information

Field	Value
Title	Unknown
Data last updated	14/08/2018
Metadata last updated	07/06/2023
Format	XLSX
License	License Not Specified
Original URL	https://opendata.transport.nsw.gov.au/system/files/resources/2%20Road%20safety_3.xlsx

CKAN Data API

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Code examples:

curl JavaScript PowerShell Python R

Querying

Get 5 results containing "jones" in any field:

curl https://devweb.datansw.links.com.au/data/api/action/datastore_search \
  -H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d",
  "limit": 5,
  "q": "jones"
}'

const resp = await fetch(`https://devweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: 'c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d",
  "limit": 5,
  "q": "jones"
}
'@
$response = Invoke-RestMethod https://devweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

(using the ckanapi client library)

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://devweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d",
    limit=5,
    q="jones",
)
print(result['records'])

library(httr2)

req <- request("https://devweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = 'c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d',
        limit = 5,
        q = 'jones'))
    req_perform %>% 
    resp_body_json

Get results with either "watershed" or "survey" as subject and "active" as its stage:

curl https://devweb.datansw.links.com.au/data/api/action/datastore_search \
-H"Authorization:$API_TOKEN" -d '
{
"resource_id": "c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}'

const resp = await fetch(`https://devweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({resource_id: 'c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}
'@
$response = Invoke-RestMethod https://devweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://devweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d",
    filters={
      "subject": ["watershed", "survey"],
      "stage": "active",
    },
)
print(result['records'])

library(httr2)

req <- request("https://devweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id='c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d', 
        filters = list(
            subject = list("watershed", "survey"), 
            stage = "active")))
    req_perform %>% 
    resp_body_json

Using the API with this Web Browser

Some API endpoints may be accessed using a GET query string.

Query example (first 5 results)

https://devweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d&limit=5

Query example (results containing 'jones')

https://devweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=c8a9fe83-929c-47fd-bf4e-5e9bfe6ded1d&q=jones