This quick start guide illustrates an end-to-end example of setting up a Polytomic sync.
This guide makes use of cURL, a command line program for making HTTP requests. MacOS and many Linux distributions have cURL pre-installed, and it is also available for download on Windows and many other operating systems. This guide also demonstrates using Polytomic’s native clients.
Generate an API key in the your user settings panel. For more information, see the authentication section.
Set the API token as an environment variable:
Replace YOUR-API-TOKEN with the token you just generate in the step above.
Make a request to the identity endpoint:
The following request will create a Hubspot connection. The configuration for each type of connection can be found at the connection configuration docs page.
Since Hubspot connections uses OAuth to authenticate, we’ll need to follow the link returned in the auth_url parameter in the response
By default, the API expects the auth_url to be open in a new browser window. If you’d like to modify the redirect behavior, there is an optional redirect_url parameter that can be added to the request body.
The PostgreSQL server must be network-accessible from Polytomic.
Source objects may not be immediately readable after creating a connection; Polytomic may take a few moments to cache source schemas after creating a connections.
This will create a bulk sync of all Hubspot objects into Postgres: