| council | phone | fax | address | postaladdress | origin_pattern | origin_url | createdAt | updatedAt | pingedAt | |
|---|---|---|---|---|---|---|---|---|---|---|
| City of Albany | staff@albany.wa.gov.au | (08) 6820 3000 | (08) 9841 4099 | 102 North Road YAKAMIA WA 6330 | PO Box 484, Albany, WA 6331 | https://www.dlgsc.wa.gov.au/localgovernment/forcommunity/Pages/LG-Directory.aspx | https://www.dlgsc.wa.gov.au/localgovernment/forcommunity/Pages/LG-Directory.aspx | 2019-05-21 02:35:00 | 2019-05-21 02:35:00 | 2019-05-21 02:35:00 |
| City of Armadale | info@armadale.wa.gov.au | (08) 9399 0111 | (08) 9399 0184 | 7 Orchard Avenue ARMADALE WA 6112 | Locked Bag No 2 ARMADALE WA 6992 | https://www.dlgsc.wa.gov.au/localgovernment/forcommunity/Pages/LG-Directory.aspx | https://www.dlgsc.wa.gov.au/localgovernment/forcommunity/Pages/LG-Directory.aspx | 2019-05-21 02:35:00 | 2019-05-21 02:35:00 | 2019-05-21 02:35:00 |
| Shire of Ashburton | soa@ashburton.wa.gov.au | (08) 9188 4444 | (08) 9189 2252 | Lot 246 Poinciana Street, Tom Price WA 6751 | PO Box 567 TOM PRICE WA 6751 | https://www.dlgsc.wa.gov.au/localgovernment/forcommunity/Pages/LG-Directory.aspx | https://www.dlgsc.wa.gov.au/localgovernment/forcommunity/Pages/LG-Directory.aspx | 2019-05-21 02:35:00 | 2019-05-21 02:35:00 | 2019-05-21 02:35:00 |
| Shire of Augusta-Margaret River | amrshire@amrshire.wa.gov.au | (08) 9780 5255 | (08) 9757 2512 | 41 Wallcliffe Road MARGARET RIVER WA 6285 | PO Box 61 MARGARET RIVER WA 6285 | https://www.dlgsc.wa.gov.au/localgovernment/forcommunity/Pages/LG-Directory.aspx | https://www.dlgsc.wa.gov.au/localgovernment/forcommunity/Pages/LG-Directory.aspx | 2019-05-21 02:35:00 | 2019-05-21 02:35:00 | 2019-05-21 02:35:00 |
Sample code snippets to quickly import data set into your application
For more information on how to automatically trigger an import please reference our WebHook API guide
Integrating with Java
import java.io.BufferedReader; import java.io.InputStreamReader; import java.net.URL; import java.net.URLConnection; import java.util.Arrays; public class HelloWorld { public static void main(String[] args) { try { URL urlCSV = new URL( "https://cache.getdata.io/n66947_4a6803ec23bd514985df0ae6a958823eeses/latest_all.csv" ); URLConnection urlConn = urlCSV.openConnection(); InputStreamReader inputCSV = new InputStreamReader( ((URLConnection) urlConn).getInputStream() ); BufferedReader br = new BufferedReader(inputCSV); String line; String[] fields; while ((line = br.readLine()) != null) { // Each row fields = line.split(","); System.out.println(Arrays.toString(fields)); } // clean up buffered reader br.close(); } catch (Exception e) { System.out.println(e.getMessage()); } } }
Integrating with NodeJs
const csv = require('csv-parser'); const https = require('https'); const fs = require('fs'); const file = fs.createWriteStream("temp_download.csv"); const request = https.get( "https://cache.getdata.io/n66947_4a6803ec23bd514985df0ae6a958823eeses/latest_all.csv", function(response) { response.pipe(file); } ); file.on('finish', function() { file.close(); fs.createReadStream('temp_download.csv').pipe(csv()).on('data', (row) => { // Each row console.log(row); }).on('end', () => { console.log('CSV file successfully processed'); }); });
Integrating with PHP
$data = file_get_contents("https://cache.getdata.io/n66947_4a6803ec23bd514985df0ae6a958823eeses/latest_all.csv"); $rows = explode("\n",$data); $s = array(); foreach($rows as $row) { # Each row var_dump( $row); }
Integrating with Python
import csv import urllib2 url = 'https://cache.getdata.io/n66947_4a6803ec23bd514985df0ae6a958823eeses/latest_all.csv' response = urllib2.urlopen(url) cr = csv.reader(response) for row in cr: # Each row print row
Integrating with Ruby
require 'open-uri' require 'tempfile' require 'csv' temp_file = Tempfile.new( "getdata", :encoding => 'ascii-8bit') temp_file << open("https://cache.getdata.io/n66947_4a6803ec23bd514985df0ae6a958823eeses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end
