Integration · APIs

Send CSV data to a REST API

An HTTP destination sends the output of a job to an endpoint, with the authentication it expects and a retry policy that does not repeat an action twice.

CSV, query result or mapped file → REST API (HTTP destination)

What you need

Modules. Transfer for the destination and Flow for the schedule, and Database if the data comes from a query.

Edition. DataBridge Server for unattended schedules. Desktop delivers to HTTP endpoints too.

Pricing and what each edition includes.

Limits, stated plainly
  • A push is one request per delivery, with the whole payload in one body.
  • A POST, PUT or PATCH that times out or drops after it was sent is not retried automatically, because the far end may already have acted. Other failures retry as the retry count says.
  • DataBridge sends what the API accepts; it does not know any one API's schema. You shape the payload with the mapping.
Steps

How it works.

Each step names the feature as it appears in the product.

  1. Step 1

    HTTP destination

    Enter the URL, the method (POST creates, PUT replaces, PATCH merges) and the content type. Add extra headers as a JSON object.

  2. Step 2

    Authentication

    None, Basic, API key or OAuth2. Credentials are stored encrypted and never shown again.

  3. Step 3

    Output format

    Push results sends JSON, JSON Lines, CSV or TSV. The content type must match the format.

  4. Step 4

    Scheduled job

    Chain the query or import, the mapping and the push, and run it on a schedule or from a webhook.

  5. Step 5

    Per row calls

    A pipeline's For each step can run an HTTP request step once per row of an earlier step's output, up to 10,000 iterations.

Questions

Common questions.

Does it protect against duplicate deliveries?

Every HTTP delivery carries an Idempotency-Key header that stays the same on each retry, so an endpoint that honors it can discard repeats.

Can it use OAuth2?

Yes. An HTTP destination can authenticate with OAuth2 using a token URL, client ID and client secret.

Keep reading

Related use cases and integrations.

QuickBooks, Sage 100, NetSuite, Salesforce, HubSpot, Dynamics 365, Shopify and Amazon are trademarks of their respective owners. Names are used only to say which system a connection, layout or file is for. ExtensibilityCo is not affiliated with or endorsed by any of them.

Next step

Try the parts that are free today.

The free browser edition needs no sign-in and never uploads your files.