DexproMasterDataUploadTask

DexproMasterDataUploadTask = object & { sourceTableName: TableName; clear: true; } | { sourceTableName: TableNameUpdatable; clear?: false; }

Type Declaration

selectStatement?

optional selectStatement: string

Select statement that overrides the default "SELECT * FROM sourceTableName".

Default

undefined

skipErrors?

optional skipErrors: boolean

Whether to skip errors during upload, only applies when clearing the table.

Default

false

batchSize?

optional batchSize: number

Batch size for uploading rows to Dexpro, only applies when clearing the table.

Default

500 from addRowsToMasterDataTable.

targetTableName?

optional targetTableName: string

Target table name in Dexpro, has to have a mapping in dexproTargetTableMapping, if not provided the target table will be mapped from the dexproSourceToTargetTableMapping using the sourceTableName.

Default

undefined

transformRow()?

optional transformRow: (row) => DexproMasterDataRow

Optional transformer applied to every row before it is sent to Dexpro. Runs after the internal externalid defaulting and is applied in both the clear-and-fill and incremental update paths. Used for normalizing numeric values so Dexpro receives them in the correct format (dot as decimal separator).

Parameters

row

DexproMasterDataRow

Returns

DexproMasterDataRow

Default

undefined