| Column 1 | Column 2 | origin_pattern | origin_url | createdAt | updatedAt | pingedAt |
|---|---|---|---|---|---|---|
| Facilitate collaboration with Jooxter by helping employees reconnect physically i... | https://jooxter.com/en/ | https://jooxter.com/en/ | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | |
| The digital workplace experience to improve team efficiency and well-being | Leader in workplace management and pioneer in hybrid work management, Jooxter has... | https://jooxter.com/en/ | https://jooxter.com/en/ | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC |
| McKinsey & Company, 17th May 2021. "What executives are saying about the future o... | https://jooxter.com/en/ | https://jooxter.com/en/ | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | |
| Organise your on-site and remote work in advance with Jooxter by visualising your... | https://jooxter.com/en/ | https://jooxter.com/en/ | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | |
| The Jooxter solutions are the only ones able to automatically synchronise on-site... | https://jooxter.com/en/ | https://jooxter.com/en/ | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | |
| Understand your teams’ needs in order to optimise your workspace by analysing you... | https://jooxter.com/en/ | https://jooxter.com/en/ | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38:39 UTC | 2021-10-21 12:38: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/n97894_ec92374c6ea47befc3ca8c1e1b157fcceses/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/n97894_ec92374c6ea47befc3ca8c1e1b157fcceses/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/n97894_ec92374c6ea47befc3ca8c1e1b157fcceses/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/n97894_ec92374c6ea47befc3ca8c1e1b157fcceses/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/n97894_ec92374c6ea47befc3ca8c1e1b157fcceses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end
