1407.0.55.002 - ABS.Stat Beta: Web Services, User Guide  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 07/10/2016   
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

Query Examples

Filter expression

If there is a dataset with identifier RES_DWELL and three dimensions; Measure, Region, Frequency, the SDMX-JSON query would look like the following:
http://stat.data.abs.gov.au/sdmx-json/data/RES_DWELL/5.1+2.Q/all?detail=Full&startTime=2014-Q2&endTime=2015-Q4

In this query “RES_DWELL” is the dataset identifier, “5”, “1+2” and “Q” are the identifiers for the requested dimension values for Measure, Region and Frequency respectably, and “all” is the key word to return data from any maintaining agency (in this case the ABS). The data is requested from the second quarter of 2014 to the fourth quarter of 2015 inclusive.

If the full list of regions is required then the “1+2” region identifiers can be replaced by either the full list of region identifiers separated by the plus sign:
http://stat.data.abs.gov.au/sdmx-json/data/RES_DWELL/5.0+1+2+3+4+5+6+7+8.Q/all?detail=Full&startTime=2014-Q2&endTime=2015-Q4

or an empty string:
http://stat.data.abs.gov.au/sdmx-json/data/RES_DWELL/5..Q/all?detail=Full&startTime=2014-Q2&endTime=2015-Q4

To retrieve all (unfiltered) observations of the dataset, replace the entire filter expression with "all":
http://stat.data.abs.gov.au/sdmx-json/data/RES_DWELL/all/all?detail=Full&startTime=2014-Q2&endTime=2015-Q4


DimensionAtObservation parameter for grouping or flat format

Example of allDimensions: Observations are returned in a flat list without any grouping.
http://stat.data.abs.gov.au/sdmx-json/data/RES_DWELL/5.1+2.Q/all?detail=Full&startTime=2014&endTime=2015&dimensionAtObservation=AllDimensions

The observations in the resulting message (without attributes) will contain:

"observations": {
"0:0:0:0": [545.4,0,0],
"0:0:0:1": [548,0,0],
(…)
}

The "0:0:0:0” numbers indicate the zero-based index of the dimension values. The orders of the dimensions and dimension values in the structure section of the SDMX-JSON response define the indexes. In the example query’s case, the dimensions are Measure, Region, Frequency and Time. So "0:0:0:0” means that the observation belongs to the first value of the Measure dimension, the first value of the Region dimension, and so on.

Example of a dimension identifier: observations are grouped on the region dimension
http://stat.data.abs.gov.au/sdmx-json/data/RES_DWELL/5.1+2.Q/all?detail=Full&startTime=2014&endTime=2015&dimensionAtObservation=REGION

The returned data is grouped for all regions selected (NSW and VIC):

"0:0:0": {
"attributes": [0],
"observations": {
"0": [545.4,],
"1": [548,0],
(…)
}

In this case, the Region dimension is attached at the observation level so “0:0:0” indicates the index of the dimension values for Measure, Frequency and Time and “0” and “1” indicate the indexes of NSW and VIC within the Region dimension.