---
slug: api-connector
title: Configuring APIs
section: Premium Features
description: Connect to a custom API endpoint, set parameters or upload a config JSON, then fetch data into OrcaSheets.
listed: true
navOrder: 3
---
**API Connector lets you pull data from custom API endpoints into OrcaSheets. Enter the endpoint and configure the request, or upload a config JSON, set parameters, and click Fetch data.**

![Configuring an API connector and fetching data in OrcaSheets](/images/docs/connector_config.gif)

## Think of it like wiring a live feed

> Your SaaS tools and internal services already expose data over HTTP. Instead of exporting CSVs every time you need a fresh pull, the **API Connector** points OrcaSheets at the endpoint, stores the request settings, and loads the response into your project so you can analyse it locally.

## What is the API Connector?

The API Connector is a premium Connector for custom API connections. You use it to pull from SaaS tools and internal services without building a one-off export pipeline.

You can:

1. **Enter** your API endpoint and set the request configuration.
2. **Or upload** a config JSON that already defines the connection.
3. **Set** all parameters the API expects.
4. **Click** **Fetch data** to load the response into your project.

## Why use it?

Teams often need ad-hoc or recurring pulls from services that do not have a dedicated OrcaSheets connector yet.

For example:

- Pull usage or billing data from a SaaS admin API.
- Load records from an internal REST service your team already runs.
- Reuse a shared config JSON so the same API setup works across projects.

## How to configure an API

1. **Open** your project in OrcaSheets.
2. **Click** the **Connectors** icon in the left panel.
3. **Select** **API** from the connector list.
4. **Enter** the API endpoint, **or upload** a config JSON.
5. **Set** headers, auth, query parameters, and any other required fields.
6. **Click** **Fetch data**.

OrcaSheets sends the configured request and loads the returned data into your project. You can chart, filter, pivot, or ask questions in AI Chat like any other dataset.

## Notes

- API Connector is a **premium feature** and requires an upgraded account.
- Keep auth tokens and secrets in the connector config; do not paste them into shared project notes.
- Name each connection clearly if you connect multiple APIs to the same project.
- For databases, warehouses, and Google Sheets, see [Connectors](/docs/connectors) and [Google Sheets Connector](/docs/google-sheets-connector).

## Related pages

- [Connectors](/docs/connectors)
- [Google Sheets Connector](/docs/google-sheets-connector)
- [Importing Data](/docs/data-import)
- [Connection Problems](/docs/connection-problems)
- [Recipes](/docs/recipes)