PipeKeelBeta

APIs

Any REST API into BigQuery or Google Sheets

PipeKeel reads any REST API — GET or POST, JSON, JSON Lines, XML or CSV, with page, offset, cursor or next-link pagination and API key, bearer, basic or OAuth 2.0 client-credentials authentication — into BigQuery, Google Sheets, databases or PipeKeel storage, and can send rows back to APIs with POST, PUT, PATCH or DELETE.

Start free See pricing

How it works

  1. Connect the API

    Base URL and authentication; default headers if the API needs them.

  2. Describe the request

    Endpoint, method, parameters, body, response format and pagination.

  3. Shape the data

    Flatten JSON, parse XML, rename and type columns.

  4. Load and schedule

    Into BigQuery, Sheets or a database, on a schedule, with alerts.

What you get

  • JSON, JSON Lines, XML and CSV, detected automatically
  • Page, offset, cursor and next-link pagination
  • OAuth 2.0 client credentials, API keys, bearer and basic auth
  • Rate limits and retries handled (Retry-After)
  • Send rows to APIs: one request per row or in batches

Questions

Can PipeKeel read XML APIs?

Yes — XML responses become rows automatically (or by a records path), and the Parse XML block pulls values out of XML columns.

Start with the Team plan, free for 14 days

Then keep a free plan, or choose a paid one. No credit card.

Start free All connectors