Any JSON response shape
A JSONPath picks your records, so envelopes and nesting are fine.
HTTP API
Polytomic connects any JSON HTTP API to your data warehouse, databases, and SaaS tools for ETL and reverse ETL. Point it at an endpoint, pick the records with a JSONPath, and sync the results into your data warehouse and other systems, without writing code.
Four pagination styles
Next page URL, cursor token, page number, or offset and limit.
Dynamic parameters
Use expressions in headers and query parameters, like a rolling date window.
Example workflows
Pull data from your own internal APIs into a data warehouse
What you can sync
The HTTP API connector is supported as a source. Read JSON from any endpoint and land it in your data warehouse, databases, or SaaS tools.
From HTTP API
Any JSON response, with records selected by JSONPath
GET and POST requests, with an optional JSON body
Next page URL, cursor, page number, or offset pagination
Basic, bearer, API key headers, or OAuth client credentials
Nested objects exposed as selectable fields
To your destinations
Data warehouses including Snowflake, BigQuery, and Databricks
Databases including PostgreSQL and MySQL
SaaS tools including Salesforce, HubSpot, and Intercom
Cloud storage including Amazon S3 and Google Cloud Storage
How it works
Configure a base URL, authentication, and any headers once on the connection. Each model then adds a path, a method, and a JSONPath identifying where the records live in the response. Polytomic samples the response, infers a schema, and the endpoint becomes a table you can sync anywhere.
This is the escape hatch for anything without a dedicated connector. It is also how a lot of connectors start life: prototype against the API here, and if it becomes something you depend on, ask us to build it properly.
- Configure a base URL, headers, and authentication on the connection
- Add a path and method per model, with an optional JSON body
- Select records with a JSONPath, wherever they sit in the response
- Choose one of four pagination styles
- Use expressions for dynamic dates in headers or query parameters
- Monitor sync health, record volume, and failures from one interface
How to set up
Configure the base URL, any headers or query parameters that apply to every request, and authentication. Options are none, HTTP basic, an arbitrary header such as an authorization bearer token or API key, OAuth client credentials, or a key passed as a query parameter.
How to get connected
- 1In Polytomic, navigate to Connections, then Add Connection, then HTTP API
- 2Enter the base URL and any global headers or query parameters
- 3Choose an authentication method and enter its credentials
- 4Test the connection
- 5Create a model with a path, method, and record JSONPath
- 6Configure pagination and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with HTTP API in minutes
No credit card required. Free trial available.