https://www.hubspot.com/agencies?page=1 https://www.hubspot.com/agencies?page=2 https://www.hubspot.com/agencies?page=3 https://www.hubspot.com/agencies?page=4 https://www.hubspot.com/agencies?page=5 https://www.hubspot.com/agencies?page=6 https://www.hubspot.com/agencies?page=7 https://www.hubspot.com/agencies?page=8 https://www.hubspot.com/agencies?page=9 https://www.hubspot.com/agencies?page=10 https://www.hubspot.com/agencies?page=11 https://www.hubspot.com/agencies?page=12 https://www.hubspot.com/agencies?page=13 https://www.hubspot.com/agencies?page=14 https://www.hubspot.com/agencies?page=15 https://www.hubspot.com/agencies?page=16 https://www.hubspot.com/agencies?page=17 https://www.hubspot.com/agencies?page=18 https://www.hubspot.com/agencies?page=19 https://www.hubspot.com/agencies?page=20 https://www.hubspot.com/agencies?page=21 https://www.hubspot.com/agencies?page=22 https://www.hubspot.com/agencies?page=23 https://www.hubspot.com/agencies?page=24 https://www.hubspot.com/agencies?page=25 https://www.hubspot.com/agencies?page=26 https://www.hubspot.com/agencies?page=27 https://www.hubspot.com/agencies?page=28 https://www.hubspot.com/agencies?page=29 https://www.hubspot.com/agencies?page=30 https://www.hubspot.com/agencies?page=31 https://www.hubspot.com/agencies?page=32 https://www.hubspot.com/agencies?page=33 https://www.hubspot.com/agencies?page=34 https://www.hubspot.com/agencies?page=35 https://www.hubspot.com/agencies?page=36 https://www.hubspot.com/agencies?page=37 https://www.hubspot.com/agencies?page=38 https://www.hubspot.com/agencies?page=39 https://www.hubspot.com/agencies?page=40 https://www.hubspot.com/agencies?page=41 https://www.hubspot.com/agencies?page=42 https://www.hubspot.com/agencies?page=43 https://www.hubspot.com/agencies?page=44 https://www.hubspot.com/agencies?page=45 https://www.hubspot.com/agencies?page=46 https://www.hubspot.com/agencies?page=47 https://www.hubspot.com/agencies?page=48 https://www.hubspot.com/agencies?page=49 https://www.hubspot.com/agencies?page=50 https://www.hubspot.com/agencies?page=51 https://www.hubspot.com/agencies?page=52 https://www.hubspot.com/agencies?page=53 https://www.hubspot.com/agencies?page=54 https://www.hubspot.com/agencies?page=55 https://www.hubspot.com/agencies?page=56 https://www.hubspot.com/agencies?page=57 https://www.hubspot.com/agencies?page=58 https://www.hubspot.com/agencies?page=59 https://www.hubspot.com/agencies?page=60 https://www.hubspot.com/agencies?page=61 https://www.hubspot.com/agencies?page=62 https://www.hubspot.com/agencies?page=63 https://www.hubspot.com/agencies?page=64 https://www.hubspot.com/agencies?page=65 https://www.hubspot.com/agencies?page=66 https://www.hubspot.com/agencies?page=67 https://www.hubspot.com/agencies?page=68 https://www.hubspot.com/agencies?page=69 https://www.hubspot.com/agencies?page=70 https://www.hubspot.com/agencies?page=71 https://www.hubspot.com/agencies?page=72 https://www.hubspot.com/agencies?page=73 https://www.hubspot.com/agencies?page=74 https://www.hubspot.com/agencies?page=75 https://www.hubspot.com/agencies?page=76 https://www.hubspot.com/agencies?page=77 https://www.hubspot.com/agencies?page=78 https://www.hubspot.com/agencies?page=79 https://www.hubspot.com/agencies?page=80 https://www.hubspot.com/agencies?page=81 https://www.hubspot.com/agencies?page=82 https://www.hubspot.com/agencies?page=83 https://www.hubspot.com/agencies?page=84 https://www.hubspot.com/agencies?page=85 https://www.hubspot.com/agencies?page=86 https://www.hubspot.com/agencies?page=87 https://www.hubspot.com/agencies?page=88 https://www.hubspot.com/agencies?page=89 https://www.hubspot.com/agencies?page=90 https://www.hubspot.com/agencies?page=91 https://www.hubspot.com/agencies?page=92 https://www.hubspot.com/agencies?page=93 https://www.hubspot.com/agencies?page=94 https://www.hubspot.com/agencies?page=95 https://www.hubspot.com/agencies?page=96 https://www.hubspot.com/agencies?page=97 https://www.hubspot.com/agencies?page=98 https://www.hubspot.com/agencies?page=99 https://www.hubspot.com/agencies?page=100 https://www.hubspot.com/agencies?page=101 https://www.hubspot.com/agencies?page=102 https://www.hubspot.com/agencies?page=103 https://www.hubspot.com/agencies?page=104 https://www.hubspot.com/agencies?page=105 https://www.hubspot.com/agencies?page=106 https://www.hubspot.com/agencies?page=107 https://www.hubspot.com/agencies?page=108 https://www.hubspot.com/agencies?page=109 https://www.hubspot.com/agencies?page=110 https://www.hubspot.com/agencies?page=111 https://www.hubspot.com/agencies?page=112 https://www.hubspot.com/agencies?page=113 https://www.hubspot.com/agencies?page=114 https://www.hubspot.com/agencies?page=115 https://www.hubspot.com/agencies?page=116 https://www.hubspot.com/agencies?page=117 https://www.hubspot.com/agencies?page=118 https://www.hubspot.com/agencies?page=119 https://www.hubspot.com/agencies?page=120 https://www.hubspot.com/agencies?page=121 https://www.hubspot.com/agencies?page=122 https://www.hubspot.com/agencies?page=123 https://www.hubspot.com/agencies?page=124 https://www.hubspot.com/agencies?page=125 https://www.hubspot.com/agencies?page=126 https://www.hubspot.com/agencies?page=127 https://www.hubspot.com/agencies?page=128 https://www.hubspot.com/agencies?page=129 https://www.hubspot.com/agencies?page=130 https://www.hubspot.com/agencies?page=131 https://www.hubspot.com/agencies?page=132 https://www.hubspot.com/agencies?page=133 https://www.hubspot.com/agencies?page=134 https://www.hubspot.com/agencies?page=135 https://www.hubspot.com/agencies?page=136
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/n23614_88bbbfcfe98d7812e65893e1ba922c7deses/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/n23614_88bbbfcfe98d7812e65893e1ba922c7deses/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/n23614_88bbbfcfe98d7812e65893e1ba922c7deses/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/n23614_88bbbfcfe98d7812e65893e1ba922c7deses/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/n23614_88bbbfcfe98d7812e65893e1ba922c7deses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end
