ModelFiles
Retrieves import and export files for a model. Export files have fewer metadata properties than import files.
Table-Specific Information
Select
The server uses the Anaplan API to process WHERE clause conditions that are built with the following columns and operators:
- ModelId supports the '=' comparison operator.
- WorkspaceId supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [ModelFiles] WHERE [ModelId] = '123' AND [WorkspaceId] = '456'
The server processes other filters client-side within the server.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the file. | |
| ModelId [KEY] | String |
Models.Id | The ID of the model. |
| WorkspaceId | String |
Workspaces.Id | The ID of the workspace. |
| Name | String | The name of the file. | |
| ChunkCount | Int | The number of chunks in the file. | |
| Format | String | The format of the file. | |
| Encoding | String | The character encoding of the file. | |
| Delimiter | String | The delimiter character for quoting fields. | |
| Separator | String | The separator character between fields. | |
| HeaderRow | Int | The row number containing column names. | |
| FirstDataRow | Int | The first row after the header row. |