Import From Data Table
Create a new file manager file by exporting data from a data table. The resulting file will be a CSV file placed in the specified file manager directory. Returns an async result that can be polled for the export outcome.
Requires both API_DATA_TABLES_READ and API_FILE_MANAGER_WRITE permissions.
Permissions
api.file-manager.write
Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Body
The ID of the Data Table to export data from.
The engagement that the Data Table belongs to.
The name for the exported CSV file without extension.
1The list of field names (columns) to include in the export.
11The ID of the File Manager directory to place the exported file in. If null, the file is placed in the engagement's root directory.
An optional filter to apply to the data before exporting.
- Option 1
- Option 2
- Option 3
- Option 4
- Option 5
- Option 6
- Option 7
- Option 8
- Option 9
- Option 10
- Option 11
- Option 12
- Option 13
- Option 14
- Option 15
- Option 16
- Option 17
- Option 18
- Option 19
- Option 20
An optional sort order to apply to the exported rows.
The maximum number of rows to export.
x >= 1The configuration to use when generating the CSV file.
The configuration to use when formatting list values within cells in the CSV file.
Response
Created
The unique object identifier.
Indicates the data integrity version to ensure data consistency.
The date that the object was originally created.
The date that the object was last updated or modified.
Details about the user who created the object.
Details about the user who last modified or updated the object.
Indicates the type of job being run.
ANALYSIS_RUN, ANALYSIS_SOURCE_INGESTION, ADMIN_REPORT, DATA_TABLE_EXPORT, ANALYSIS_ROLL_FORWARD, GDPDU_UNPACK_JOB, ACCOUNT_GROUPING_EXPORT, ACCOUNT_MAPPING_EXPORT, DATA_TRANSFORMATION_JOB, CONNECTION_TEST, CONNECTION_TABLES, DATA_TABLE Indicates the current state of the job.
IN_PROGRESS, COMPLETE, ERROR Identifies the entity used in the job.
Identifies the entity type used in the job.
ORGANIZATION, ENGAGEMENT, ANALYSIS, ANALYSIS_RESULT, ANALYSIS_SOURCE, FILE_RESULT, GDPDU_UNPACK_JOB, ACCOUNT_GROUPING, ENGAGEMENT_ACCOUNT_GROUPING, FILE_MANAGER_FILE, CONNECTION_TEST_RESULT, CONNECTION_TABLES_RESULT, DATA_TABLE The reason why the async job failed.

