Update a sync
imports_put_syncs(id, sync_id, source, destination, advanced_options = NULL)
| id | integer required. The ID of the import to fetch. |
|---|---|
| sync_id | integer required. The ID of the sync to fetch. |
| source | list required. A list containing the following elements:
|
| destination | list required. A list containing the following elements:
|
| advanced_options | list optional. A list containing the following elements:
|
A list containing the following elements:
integer,
list, A list containing the following elements:
id integer, The ID of the table or file, if available.
path string, The path of the dataset to sync from; for a database source, schema.tablename. If you are doing a Google Sheet export, this can be blank. This is a legacy parameter, it is recommended you use one of the following: databaseTable, file, googleWorksheet, salesforce
databaseTable list . A list containing the following elements:
schema string, The database schema name.
table string, The database table name.
useWithoutSchema boolean, This attribute is no longer available; defaults to false but cannot be used.
file list . A list containing the following elements:
id integer, The file id.
googleWorksheet list . A list containing the following elements:
spreadsheet string, The spreadsheet document name.
spreadsheetId string, The spreadsheet document id.
worksheet string, The worksheet tab name.
worksheetId integer, The worksheet tab id.
salesforce list . A list containing the following elements:
objectName string, The Salesforce object name.
list, A list containing the following elements:
path string, The schema.tablename to sync to. If you are doing a Google Sheet export, this is the spreadsheet and sheet name separated by a period. i.e. if you have a spreadsheet named "MySpreadsheet" and a sheet called "Sheet1" this field would be "MySpreadsheet.Sheet1". This is a legacy parameter, it is recommended you use one of the following: databaseTable, googleWorksheet
databaseTable list . A list containing the following elements:
schema string, The database schema name.
table string, The database table name.
useWithoutSchema boolean, This attribute is no longer available; defaults to false but cannot be used.
googleWorksheet list . A list containing the following elements:
spreadsheet string, The spreadsheet document name.
spreadsheetId string, The spreadsheet document id.
worksheet string, The worksheet tab name.
worksheetId integer, The worksheet tab id.
list, A list containing the following elements:
maxErrors integer,
existingTableRows string,
diststyle string,
distkey string,
sortkey1 string,
sortkey2 string,
columnDelimiter string,
columnOverrides object, Hash used for overriding auto-detected names and types, with keys being the index of the column being overridden.
escaped boolean, If true, escape quotes with a backslash; otherwise, escape quotes by double-quoting. Defaults to false.
identityColumn string,
rowChunkSize integer,
wipeDestinationTable boolean,
truncateLongLines boolean,
invalidCharReplacement string,
verifyTableRowCounts boolean,
partitionColumnName string, This parameter is deprecated
partitionSchemaName string, This parameter is deprecated
partitionTableName string, This parameter is deprecated
partitionTablePartitionColumnMinName string, This parameter is deprecated
partitionTablePartitionColumnMaxName string, This parameter is deprecated
lastModifiedColumn string,
mysqlCatalogMatchesSchema boolean, This attribute is no longer available; defaults to true but cannot be used.
chunkingMethod string, The method used to break the data into smaller chunks for transfer. The value can be set to sorted_by_identity_columns or if not set the chunking method will be chosen automatically.
firstRowIsHeader boolean,
exportAction string, The kind of export action you want to have the export execute. Set to "newsprsht" if you want a new worksheet inside a new spreadsheet. Set to "newwksht" if you want a new worksheet inside an existing spreadsheet. Set to "updatewksht" if you want to overwrite an existing worksheet inside an existing spreadsheet. Set to "appendwksht" if you want to append to the end of an existing worksheet inside an existing spreadsheet. Default is set to "newsprsht"
sqlQuery string, If you are doing a Google Sheet export, this is your SQL query.
contactLists string,
soqlQuery string,
includeDeletedRecords boolean,