HubSpot
Read HubSpot CRM contacts, companies, deals and tickets.
Connect it in the console under Integrations > Connectors. See Connectors for how connectors work and who can use them.
Create a read-only credential
Section titled “Create a read-only credential”In HubSpot, create a private app (Settings > Integrations > Private Apps) with the read scopes you need, for example crm.objects.contacts.read, crm.objects.companies.read, crm.objects.deals.read and tickets. Copy its access token.
Settings
Section titled “Settings”| Setting | Notes | |
|---|---|---|
| Private app access token | Required | Stored encrypted and never shown again. |
Tables
Section titled “Tables”| Table | Filters | Returns |
|---|---|---|
contacts | properties, after | CRM contacts (pick properties with a comma-separated list). |
companies | properties, after | CRM companies (pick properties with a comma-separated list). |
deals | properties, after | CRM deals (pick properties with a comma-separated list). |
tickets | properties, after | CRM tickets (pick properties with a comma-separated list). |
Query from the API
Section titled “Query from the API”curl -s -X POST "https://api.vaif.studio/database/connector/$VAIF_PROJECT_ID/query" \ -H "Authorization: Bearer $VAIF_TOKEN" -H "Content-Type: application/json" \ -d '{"wrapperId":"hubspot_fdw","table":"deals","filters":{"properties":"dealname,amount,dealstage,closedate"},"limit":50}'$VAIF_TOKEN is a console access token. See Connectors for the routes.
How it stays read-only
Section titled “How it stays read-only”Give the private app read scopes only. Without properties, each record comes back with a default set of properties; name the ones you want with their internal names, separated by commas.