The Australian Government coat of Arms

Communities of practice

Communities of practice

ABS Json calls

Hello.
My name is Dan Petrie and I have previously mapped the ABS Json data to get calls for retail sales, labour force and CPI. While the documentation here is very good, I am simply chasing an example of how the JSON calls will look with respect to the proposed calls being introduced.

Here is an example from the ABS.

http://stat.data.abs.gov.au:80/sdmx-json/data/MERCH_EXP/-.001.-1.-.M/all?detail=DataOnly&dimensionAtObservation=AllDimensions&startPeriod=1995-07

If any one sees these posts, I have added in a JSON call for the CPI which you can bring into a google sheet. I will see if I can write some script which gives users a working example.

Happy to provide importjson script for a google sheet and to show anyone who is interest how to set up a call direct from the ABS into a google spreadsheet. Here is a link to the script for the google sheet.
ImportJSON/ImportJSON.gs at master · bradjasper/ImportJSON · GitHub and below is a formula to make an API call for the CPI data -

=ImportJSON(“https://api.data.abs.gov.au/data/CPI/1.10001.10.50.Q/all?startPeriod=2019&format=jsondata","/”, “noInherit,noTruncate,noPrefixHeaders”)

1 Like