--- title: "eDiscovery APIs In Airtable" slug: "ediscovery-apis-in-airtable" updated: 2025-10-06T22:08:13Z published: 2025-10-06T22:08:13Z --- > ## Documentation Index > Fetch the complete documentation index at: https://support.airtable.com/llms.txt > Use this file to discover all available pages before exploring further. # eDiscovery APIs in Airtable | [**Plan availability**](https://airtable.com/pricing) | Enterprise Scale | | --- | --- | | [**Permissions**](/docs/permissions-overview) | Admins | | **Platform(s)** | Web/Browser, Mac app, and Windows app | | **Related reading** | - [API Authentication](https://airtable.com/developers/web/api/authentication?_gl=1*tgoxc7*_ga*MTQ1NTIxMTYxMS4xNjc2MzIxMTYx*_ga_VJY8J9RFZM*MTY5ODM1NjgxMC42NC4xLjE2OTgzNTY4NjIuOC4wLjA.) - [Guide to creating a personal access token](https://airtable.com/developers/web/guides/personal-access-tokens) - [List all eDiscovery Exports](https://airtable.com/developers/web/api/list-ediscovery-export) - [Create a new eDiscovery Export](https://airtable.com/developers/web/api/create-ediscovery-export) - [Get eDiscovery Export](https://airtable.com/developers/web/api/get-ediscovery-export) | Airtable provides a set of eDiscovery APIs to customers on our Enterprise Scale plan to export base data from Airtable. Customers can use these exports to review base content or preserve base data in third-party systems for compliance reviews and other security purposes. ## eDiscovery Overview There may be scenarios where you need to export the data stored within Airtable as part of a legal review hold or other compliance-related scenario. We provide a set of APIs that allow you to export the data stored in bases in formats that meet your team’s needs (CSV and JSON). We also provide metadata about base usage to better inform your team’s assessment of base data. ## Getting an eDiscovery Export > [!CAUTION] > NOTE > > To use eDiscovery APIs in Airtable, you must be an admin in your organization and [provision a PAT](https://airtable.com/developers/web/guides/personal-access-tokens) with the required permissions. The eDiscovery API allows you to asynchronously request an export and then check the status of your export request. 1. Before starting the export process, you’ll want to locate the base ID you are trying to export (formatted as appxxxxxxxx). There are multiple ways to locate your preferred base ID: **The “Bases” page in admin panel** 1. Open your [admin panel](https://airtable.com/admin). 2. Click **Bases**. 3. Search for your preferred base under the “Base name” column. 4. Base IDs are visible immediately below your base’s name. **The “Reports” page in admin panel (Via an audit log)** 1. Visit your [admin panel](https://airtable.com/admin). 2. Click **Reports**. 3. Enter your preferred date and select any necessary filters under the "Audit log" section. 4. Click **Download report**or **Generate new report**. **From an individual user detail page in admin panel** 1. Visit your [admin panel](https://airtable.com/admin). 2. Click **Users**. 3. Click on your preferred user’s name. 4. Click **Bases**. 2. After locating your base ID, `POST` a request to the Create eDiscovery API endpoint. [Detailed documentation is available here](https://airtable.com/developers/web/api/create-ediscovery-export). Some important notes for this step: - Currently, bases can only be exported one at a time. - You can request that an email be sent to you once the request is submitted, which proactively notifies you when the export request is complete and provides a download link. - The default export format is a JSON object, but CSV is also available. - 10 minutes is the maximum time we allow an export request to run. - If your request succeeds, you will receive a response with an `enterpriseTaskId`. You will use this value to check the status of your export request. 3. You can then review your eDiscovery export status by making a `GET` request to the eDiscovery API endpoint. [Detailed documentation is available here](https://airtable.com/developers/web/api/get-ediscovery-export). Your export will be in one of the following states: > [!CAUTION] > Note > > Suppose you do not specify the `enterpriseTaskId `when checking the export status. In that case, you will receive a list of all in-progress and past export requests and their status. The endpoint will return all exports created by all admins across the organization. - **Pending** – the export task is queued but has not started. - **Processing** - the export task is in process. - **Error** - the export task failed and hit an unexpected error. In this circumstance, you should retry or submit a support request. - **Done** – the export is complete, and the request should contain links to the export files. ## Export format breakdown The eDiscovery APIs contain an export of the data stored within your base—including all raw data stored within a base’s tables and all active record comments within your base. The following values are not included in exports: - Calculated column values (like rollups or formulas) - Interface layout information - Automation configuration details - Extension usage and details > [!CAUTION] > Note > > Exports do not contain record revision history or information about deleted records. If you want to monitor a change log of all Airtable data and store it in a 3p system, [check out our Data Loss Prevention offerings](/v1/docs/airtable-and-data-loss-prevention). The default behavior of the eDiscovery API is to provide an export in a single JSON file. The JSON file contains each record's raw details, metadata, and comments. JSON export details: | Field name | Description | | --- | --- | | **tablesById** | Contains a map of tables in the base with details including its name, time created, and the relevant fields within the table. | | **recordsById** | Contains a map of records by recordID with each record including the list of corresponding [field values](https://airtable.com/developers/web/api/field-model). | | **recordCommentsById** | Contains comment details for each specific record. | | **recordsMetadataById** | Contains list of metadata for each record in the table: - Record created time - The ID of the user who created the record - Individual field breakdown of the following: - Time the field was last modified - The user who last modified the field | Another option for customers is to export base data as a CSV. The eDiscovery API returns a URL into a .zip file containing the relevant CSV structure for a base. CSV export details: Two CSVs are generated per base table. The first CSV contains the table export, while the second contains all the comments made on records within that table. The CSV table export contains all non-calculated fields for the records in a table. Additionally, to provide more metadata about the table, the CSV has the following additional information: - The record creation and last modified times. - The userID of the user who created and last modified the record. Known limitations: - Calculated columns do not have values in the export, but the column are present in the export. - This includes formulas, rollups, and lookup fields. ![](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/unnamed(3).png)