Delete records

Setting up

To create records you need three things: the baseId, tableId, and an authenticated instance of Flairtable (see sign in tutorial). The tableId is very easy to find: it's just the name of the tab in your Airtable base.

The baseId is a bit trickier. You need to go to the Airtable API docs and click on the base you wish to use. The baseId is something that's immediately shown.

Lastly you will need to create a column called User in the table you want to add records to. This is to make sure that a user can only create/edit/delete rows that he/she made.

The User column should link to the Users table you created following the setting up authentication guide.

It should look something like this:

Airtable love

The Delete records call is 1:1 translated to Flairtable. If you prefer their docs (they're really good): you can just follow along there.

Remember to use the Flairtable SDK, base URL and API key though!

Usage

To delete records, use the destroy method.

The first parameter to destroy is an array of up to 10 record IDs to delete.

Code samples

Copy
const authenticatedFlairtable = await Flairtable({apiKey: 'YOUR_API_KEY',})
        .signIn('YOUR_BASE_ID', 'EMAIL', 'PASSWORD', 'session');
const base = authenticatedFlairtable.base('YOUR_BASE_ID');
base('YOUR_TABLE_ID').destroy(['recsRNN3DNz8f4xSX'], function(err, deletedRecords) {
  if (err) {
    console.error(err);
    return;
  }
  console.log('Deleted', deletedRecords.length, 'records');
});

You can also omit the callback parameter. This will result in a 'thenable' promise.

Copy
const base = authenticatedFlairtable.base('YOUR_BASE_ID');
base('YOUR_TABLE_ID')
.destroy(['recsRNN3DNz8f4xSX'])
.then(function(err, deletedRecords) {
  if (err) {
    console.error(err);
    return;
  }
  console.log('Deleted', deletedRecords.length, 'records');
});

Setting up

To create records you need three things: the baseId, tableId, and a user auth token (see sign in tutorial). The tableId is very easy to find: it's just the name of the tab in your Airtable base.

The baseId is a bit trickier. You need to go to the Airtable API docs and click on the base you wish to use. The baseId is something that's immediately shown.

Lastly you will need to create a column called User in the table you want to add records to. This is to make sure that a user can only create/edit/delete rows that he/she made.

The User column should link to the Users table you created following the setting up authentication guide.

It should look something like this:

After getting the user auth token you need to set it on the x-user-authorization header and prefix it with Bearer like so: x-user-authorization = Bearer [USER_BEARER_TOKEN]

Airtable love

The Delete records call is 1:1 translated to Flairtable. If you prefer their docs (they're really good): you can just follow along there.

Remember to use the base URL, API key, and x-user-authorization header!

Usage

To delete records, issue a DELETE request to the api/v1/{baseId}/{tableId} endpoint.

Your request should include a URL-encoded array of up to 10 record IDs to delete.

Code samples

Copy
curl -v -X POST https://flairtable.com/api/v1/{YOUR_BASE_ID}/{YOUR_TABLE_ID} \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "x-user-authorization: Bearer USER_AUTHORIZATION_KEY"
  -G \
  --data-urlencode 'records[]=recsRNN3DNz8f4xSX''

Example response:

Copy
{
    "records": [
        {
            "id": "recsRNN3DNz8f4xSX",
            "deleted": true
        }
    ]
}