SyncCSV
Synchronizes raw CSV data into a designated Sync API table in Airtable, allowing bulk data import through a specified file path, input stream, or Base64-encoded content.
Note: This procedure is only supported when AuthScheme is set to PersonalAccessToken.
You can obtain the SyncId during the setup process when creating a new Sync API table, or from the settings of an existing synced table.
Sample:
EXECUTE SyncCSV SyncTable='tblPZyUrow0RLLpm2', SyncId='JToTgCMw', FileData='Y29sMSxjb2wyLGNvbDMsY29sNSxjb2w0DQp2MSx2Mix2Myxhc2QsdGVzdA=='
EXECUTE SyncCSV SyncTable='tblPZyUrow0RLLpm2', SyncId='JToTgCMw', LocalFile='/temp/sample.csv'
Input
| Name | Type | Required | Accepts Input Streams | Description |
| SyncTable | String | True | False | The name or unique identifier of the Sync API table where the CSV data will be imported. |
| SyncId | String | True | False | The unique Sync API identifier for the target table, which can be obtained during the setup process when creating a new Sync API table or from the synced table’s settings. |
| LocalPath | String | False | False | The complete file path to the local CSV file containing the data to be synced. |
| InputStream | Binary | False | True | An input stream instance used to read CSV data for syncing, applied only if a local file path is not provided. |
| FileData | String | False | False | A Base64-encoded string containing the CSV data, used when neither a local file path nor an input stream is specified. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether the CSV sync operation completed successfully. |
| Details | String | Provides additional details about the sync process, such as processing statistics, warnings, or error messages. |