| Column 1 | Column 2 | Column 3 | name | origin_pattern | origin_url | createdAt | updatedAt | pingedAt |
|---|---|---|---|---|---|---|---|---|
| 哈德森博士, 哈德森博士, 9,878, 9,878, 哈德森博士是一輛話不多但才華橫溢的汽車。他不僅擔任鎮法官，還是散熱器泉的常駐醫生。, 哈德森博士是一輛話不... | 哈德森博士 | https://start.getdata.io/ | https://start.getdata.io/ | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | ||
| 哈德森博士是一輛話不多但才華橫溢的汽車。他不僅擔任鎮法官，還是散熱器泉的常駐醫生。 | 圖像, 姓名, 價格, 描述 | 圖像, 圖像, 姓名, 姓名, 價格, 價格, 描述, 描述 | https://start.getdata.io/ | https://start.getdata.io/ | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | |
| 奇克·希克斯, 奇克·希克斯, 2,010, 2,010, 奇克·希克斯 (Chick Hicks) 是一位心懷不滿的賽車老手，也是一位冷酷無情的競爭對手，他通過... | 奇克·希克斯 | https://start.getdata.io/ | https://start.getdata.io/ | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | ||
| 拖母, 拖母, 5,030, 5,030, 母親一生都住在散熱器泉。在他年輕的時候，他曾經是城裡的小混混，對每個人惡作劇，翻拖拉機，在錯誤的時間說不恰當的話，但幸... | 拖母 | https://start.getdata.io/ | https://start.getdata.io/ | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | ||
| 閃電麥昆, 閃電麥昆, 10,122, 10,122, Lightning 是一輛由 Rust-eze 藥用保險槓軟膏贊助的紅色賽車。McQueen 的模型是一輛... | 閃電麥昆 | https://start.getdata.io/ | https://start.getdata.io/ | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 UTC | 2023-09-18 11:54:54 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/n123491_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/n123491_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/n123491_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/n123491_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/n123491_3c64040639f5365e2649c6efeecf18a0eses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end
