Export Airtable (via API)

Make sure you have connected Airtable as a datasource


1. Go to CSV Getter Home

2. Click on Developers

3. Click on Create New CSV Getter Key

4. Click on Generate

5. Copy your API key

6. Construct your API request


API Endpoint: https://api.csvgetter.com/urls/create

HTTP Method: POST

Request Headers

  • Authorization: Bearer token for authentication ('Bearer <your_csv_getter_api_key>').

    • Type: String (Required)

  • Content-Type: The content type of the request body.

    • Type: String (Required)

    • Value: application/json

Request Body

The request body should be a JSON object containing the following parameters:

  • base (String): Identifier for the base..

    • Type: String (Required)

  • table (String): Identifier for the table.

    • Type: String (Required)

  • view (String): Identifier for the view.

    • Type: String (Optional)

These IDs can be found in your Airtable URL when your table is open:

Identifying the correct IDs

Example Request

bash
curl --location --request POST 'https://api.csvgetter.com/urls/create' \
--header 'Authorization: Bearer <your_csv_getter_key>' \
--header 'Content-Type: application/json' \
--data-raw '{
    "base": "app13WtrDjOcPZBkD",
    "table": "tblMSaWQG5tTlrMef",
    "view": "viwuKZsGqzfAHbjpv"
}'

Response

Response Body

The response is a JSON object containing a URL. The URL points to the newly created resource.

  • URL (String): URL of the created resource.

    • Type: String

Example Response

json
{
    "URL": "https://api.csvgetter.com/622448b8ae594ddd8c56"
}

Request Example in Postman

Response Example in Postman

Export URLs created with API are symbolised by the flask symbol on the export screen

Last updated

Was this helpful?