https://facdent.hku.hk/staff-profile.php?shortname=amyhchen https://facdent.hku.hk/staff-profile.php?shortname=bchiu09 https://facdent.hku.hk/staff-profile.php?shortname=bollies4 https://facdent.hku.hk/staff-profile.php?shortname=botelho https://facdent.hku.hk/staff-profile.php?shortname=camelia https://facdent.hku.hk/staff-profile.php?shortname=ccsung18 https://facdent.hku.hk/staff-profile.php?shortname=cenrong https://facdent.hku.hk/staff-profile.php?shortname=changww https://facdent.hku.hk/staff-profile.php?shortname=chchu https://facdent.hku.hk/staff-profile.php?shortname=chenxi28 https://facdent.hku.hk/staff-profile.php?shortname=chonrada https://facdent.hku.hk/staff-profile.php?shortname=conson https://facdent.hku.hk/staff-profile.php?shortname=csptsang https://facdent.hku.hk/staff-profile.php?shortname=cyvleung https://facdent.hku.hk/staff-profile.php?shortname=dduang https://facdent.hku.hk/staff-profile.php?shortname=dralice https://facdent.hku.hk/staff-profile.php?shortname=drawong https://facdent.hku.hk/staff-profile.php?shortname=drswtan https://facdent.hku.hk/staff-profile.php?shortname=drzhangk https://facdent.hku.hk/staff-profile.php?shortname=ehnpow https://facdent.hku.hk/staff-profile.php?shortname=ericho8 https://facdent.hku.hk/staff-profile.php?shortname=faran https://facdent.hku.hk/staff-profile.php?shortname=fning https://facdent.hku.hk/staff-profile.php?shortname=irisxyin https://facdent.hku.hk/staff-profile.php?shortname=kcmleung https://facdent.hku.hk/staff-profile.php?shortname=ktyng https://facdent.hku.hk/staff-profile.php?shortname=liazhang https://facdent.hku.hk/staff-profile.php?shortname=loisdx https://facdent.hku.hk/staff-profile.php?shortname=mabetan https://facdent.hku.hk/staff-profile.php?shortname=mfburr58 https://facdent.hku.hk/staff-profile.php?shortname=nizami01 https://facdent.hku.hk/staff-profile.php?shortname=ollieyu https://facdent.hku.hk/staff-profile.php?shortname=prasanna https://facdent.hku.hk/staff-profile.php?shortname=retlaw https://facdent.hku.hk/staff-profile.php?shortname=spcheung https://facdent.hku.hk/staff-profile.php?shortname=sxcyang https://facdent.hku.hk/staff-profile.php?shortname=tongwah https://facdent.hku.hk/staff-profile.php?shortname=wkluka https://facdent.hku.hk/staff-profile.php?shortname=zhangcf https://facdent.hku.hk/staff-profile.php?shortname=zhanyan https://facdent.hku.hk/staff-profile.php?shortname=zouting6
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/n100980_a84718fca8dd6da08bf8f7e87ca3b462eses/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/n100980_a84718fca8dd6da08bf8f7e87ca3b462eses/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/n100980_a84718fca8dd6da08bf8f7e87ca3b462eses/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/n100980_a84718fca8dd6da08bf8f7e87ca3b462eses/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/n100980_a84718fca8dd6da08bf8f7e87ca3b462eses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end
