| Aklama | Column 1 | Column 2 | Column 3 | Column 4 | name | Column 6 | Column 7 | Column 8 | origin_pattern | origin_url | createdAt | updatedAt | pingedAt |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chick Hicks is a racing veteran with a chip on his shoulder, a ruthless competito... | https://start.getdata.io/ | https://start.getdata.io/ | 2022-07-15 16:18:39 UTC | 2022-07-15 16:18:39 UTC | 2022-07-15 16:18:39 UTC | ||||||||
| Doc Hudson is a car of few words but many talents. He not only serves as the town... | https://start.getdata.io/assets/doc_hudson.png | 9,878 | Doc Hudson is a car of few words but many talents. He not only serves as the town... | Lightning McQueen | Lightning is a red racecar sponsored by Rust-eze Medicated Bumper Ointment. McQue... | https://start.getdata.io/ | https://start.getdata.io/ | 2022-07-15 16:18:39 UTC | 2022-07-15 16:18:39 UTC | 2022-07-15 16:18:39 UTC | |||
| Lightning is a red racecar sponsored by Rust-eze Medicated Bumper Ointment. McQue... | https://start.getdata.io/ | https://start.getdata.io/ | 2022-07-15 16:18:39 UTC | 2022-07-15 16:18:39 UTC | 2022-07-15 16:18:39 UTC | ||||||||
| Mater's lived in Radiator Springs his whole life. In his younger days, he used to... | https://start.getdata.io/ | https://start.getdata.io/ | 2022-07-15 16:18:39 UTC | 2022-07-15 16:18:39 UTC | 2022-07-15 16:18:39 UTC |
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/n109115_3c64040639f5365e2649c6efeecf18a0eses/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/n109115_3c64040639f5365e2649c6efeecf18a0eses/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/n109115_3c64040639f5365e2649c6efeecf18a0eses/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/n109115_3c64040639f5365e2649c6efeecf18a0eses/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/n109115_3c64040639f5365e2649c6efeecf18a0eses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end
