Get data from any page you want to get data from.
Need to talk to someone? Contact us—we’d love to help.
Get data from any page you want to get data from.
Need to talk to someone? Contact us—we’d love to help.
We are still busy preparing this batch of data. Please come back in a few minutes.
Seems like this data source was never ran before...
Changes are only available only when you have ran at least a second time.
Nope... guess no Martians around... Maybe set the webhook URL before pressing this button again...
| Class | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16 | Column 17 | Location | Location | Location | Column 21 | Location | location | Location | Column 25 | origin_pattern | origin_url | createdAt | updatedAt | pingedAt |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 10SL [N90_IS12 - 4B538E2C] | Lock 10SL [N90_IS12 - 4B538E2C] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 11SL [N90_IS12 - 4B5E8E37] | Lock 11SL [N90_IS12 - 4B5E8E37] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 12SL [N90_IS12 - 4C8D8E67] | Lock 12SL [N90_IS12 - 4C8D8E67] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 13SL [PDL6100 - 45AE392C] | Lock 13SL [PDL6100 - 45AE392C] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 14SL [N95_IS12 - 88E66DDB] | Lock 14SL [N95_IS12 - 88E66DDB] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 15 SL[N95_IS12 - E1F27B4E] | Lock 15 SL[N95_IS12 - E1F27B4E] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 16 SL[N95_IS12 - 82CB6CB9] | Lock 16 SL[N95_IS12 - 82CB6CB9] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 17SL [N95_IS12 - 88DA6DCF] | Lock 17SL [N95_IS12 - 88DA6DCF] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 18SL[PDL6100 - 2EE7374C] | Lock 18SL[PDL6100 - 2EE7374C] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 19SL [N95_IS12 - E96C7DD2] | Lock 19SL [N95_IS12 - E96C7DD2] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Refresh Badge Filter | Lock 1SL[N90_IS12 - CECD8621] | Lock 1SL[N90_IS12 - CECD8621] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | |||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 20SL [N95_IS12 - E1ED7B49] | Lock 20SL [N95_IS12 - E1ED7B49] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 2LS [N90_IS12 - CE9986ED] | Lock 2LS [N90_IS12 - CE9986ED] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 1SL[N90_IS12 - CECD8621]Lock 2LS [N90_IS12 - CE9986ED]Lock 3SL [N95_IS12 - E... | Lock 1SL[N90_IS12 - CECD8621]Lock 2LS [N90_IS12 - CE9986ED]Lock 3SL [N95_IS12 - E... | Lock 1SL[N90_IS12 - CECD8621]Lock 2LS [N90_IS12 - CE9986ED]Lock 3SL [N95_IS12 - E... | Lock 1SL[N90_IS12 - CECD8621]Lock 2LS [N90_IS12 - CE9986ED]Lock 3SL [N95_IS12 - E... | Lock 1SL[N90_IS12 - CECD8621]Lock 2LS [N90_IS12 - CE9986ED]Lock 3SL [N95_IS12 - E... | Lock 1SL[N90_IS12 - CECD8621]Lock 2LS [N90_IS12 - CE9986ED]Lock 3SL [N95_IS12 - E... | Lock 3SL [N95_IS12 - E1DC7B38] | Lock 1SL[N90_IS12 - CECD8621]Lock 2LS [N90_IS12 - CE9986ED]Lock 3SL [N95_IS12 - E... | Lock 3SL [N95_IS12 - E1DC7B38] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | |||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 4SL [N90_IS12 - CECE8622] | Lock 4SL [N90_IS12 - CECE8622] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 5LS [N90_IS12 - 4C7E8E58] | Lock 5LS [N90_IS12 - 4C7E8E58] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 6LS [N90_IS12 - 4E928E6E] | Lock 6LS [N90_IS12 - 4E928E6E] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 7SL [N90_IS12 - 49398E10] | Lock 7SL [N90_IS12 - 49398E10] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 8SL [N90_IS12 - 494B8E22] | Lock 8SL [N90_IS12 - 494B8E22] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | ||||||||||||||||||
| LOCK Data | LOCK Data | LOCK Data | LOCK Data | LOCK Data | Lock 9SL [N90_IS12 - CEB6860A] | Lock 9SL [N90_IS12 - CEB6860A] | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | http://sqa.airaccess.cloud/System/ViewHistory/ViewHistory.aspx | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 | 2021-07-20 18:30:15 |
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/n94355_db9c40b5f330cfa22879208a51ceb3a0eses/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/n94355_db9c40b5f330cfa22879208a51ceb3a0eses/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/n94355_db9c40b5f330cfa22879208a51ceb3a0eses/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/n94355_db9c40b5f330cfa22879208a51ceb3a0eses/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/n94355_db9c40b5f330cfa22879208a51ceb3a0eses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end