Skip to main content

Airtable Source

airtable-icon.png

The Airtable API integration ingests audit logs periodically from the Airtable app platform into the Sumo Logic environment for storing and analyzing data.

note

This source is available in the Fed deployment.

Data collected

Polling IntervalData
24 hoursAudit Logs

Setup

Vendor configuration

note

Make sure you have an Airtable admin account and Enterprise billing plan to collect audit logs from the Airtable application.

Airtable's API uses token-based authentication, it allows you to authenticate API requests by inputting your access tokens into the HTTP authorization bearer token header. You need to create a Personal Access token that will be used to authenticate API requests.

Complete the following steps to create service account credentials:

  1. Go to the Airtable application and navigate to Create Token.
  2. Click the Create new token button to create a new personal access token.
  3. Give your token a unique name. This name will be visible in the record revision history.
  4. Choose the scope enterprise.auditLogs:read to grant your token. This controls what API endpoints the token will be able to use.
  5. Click add a base to grant the token access to a base or workspace.
  6. You can grant access to any number and combination of bases and workspaces associated with your account. Ensure that the token can only read and write data within the bases and workspaces that have been assigned to it.

Source configuration

In this configuration, you will set up an Airtable source account with your Enterprise account and configure it to be authorized and authenticated to use audit logs from Airtable API.

To configure an Airtable Source:

  1. In Sumo Logic, select Manage Data > Collection > Collection.
  2. On the Collection page, click Add Source next to a Hosted Collector.
  3. Search for and select Airtable.
  4. Enter a Name for the Source. The description is optional.
  5. (Optional) For Source Category, enter any string to tag the output collected from the Source. Category metadata is stored in a searchable field called _sourceCategory.
  6. Forward to SIEM. Check the checkbox to forward your data to Cloud SIEM
  7. (Optional) Fields. Click the +Add Field link to define the fields you want to associate. Each field needs a name (key) and value.
    • green check circle.png A green circle with a checkmark is shown when the field exists in the Fields table schema.
    • orange exclamation point.png An orange triangle with an exclamation point is shown when the field doesn't exist in the Fields table schema. In this case, an option to automatically add the nonexistent fields to the Fields table schema is provided. If a field is sent to Sumo that does not exist in the Fields schema it is ignored, known as dropped.
  8. In Account ID, enter an account ID that will be a unique identifier for your enterprise account.
  9. In Personal Access Token, enter the access token that you have generated in the authentication section.
  10. When you are finished configuring the Source, click Save.

JSON schema

Sources can be configured using UTF-8 encoded JSON files with the Collector Management API. See how to use JSON to configure Sources for details. 

ParameterTypeValueRequiredDescription
schemaRefJSON Object{"type":"Airtable"}YesDefine the specific schema type.
sourceTypeString"Universal"YesType of source.
configJSON ObjectConfiguration objectYesSource type specific values.

Configuration Object

ParameterTypeRequiredDefaultDescriptionExample
nameStringYesnullType a desired name of the source. The name must be unique per Collector. This value is assigned to the metadata field _source."mySource"
descriptionStringNonullType a description of the source."Testing source"
categoryStringNonullType a category of the source. This value is assigned to the metadata field _sourceCategory. See best practices for details."mySource/test"
fieldsJSON ObjectNonullJSON map of key-value fields (metadata) to apply to the Collector or Source. Use the boolean field _siemForward to enable forwarding to SIEM.{"_siemForward": false, "fieldA": "valueA"}
accountIdStringYesnullAccount ID is a unique identifier for your Enterprise Account.
personalAccessTokensStringYesnullUsed to authenticate API requests.

JSON example

{
"api.version": "v1",
"source": {
"config": {
"name": "airtable",
"accountId": "accountid",
"personalAccessToken": "*********",
"fields": {
"_siemForward": true
}
},
"schemaRef": {
"type": "Airtable"
},
"sourceType": "Universal"
}
}

Download example

Terraform example

resource "sumologic_cloud_to_cloud_source" "airtable_source" {
collector_id = sumologic_collector.collector.id
schema_ref = {
type = "Airtable"
}
config = jsonencode({
"name": "airtable",
"accountId": "accountid",
"personalAccessToken": "*********",
"fields": {
"_siemForward": true
}
})
}
resource "sumologic_collector" "collector" {
name = "my-collector"
description = "Just testing this"
}

Download example

FAQ

info

Click here for more information about Cloud-to-Cloud sources.

Limitations

  • We are using Personal Access Token authentication in the integration, which is currently in public beta version. For more information, refer to the Airtable Notification.
  • Size of the single audit log will be less than 64 KB.
  • Data URLs will expire after 7 days. If URLs are not processed within 7 days, the integration will create a new request which may cause data duplication.
Status
Legal
Privacy Statement
Terms of Use

Copyright © 2024 by Sumo Logic, Inc.