Skip to main content

Upsert records

POST 
/v1/customerdatatable/:tableName

Insert or update records in one of 20 available customer data tables. Supports flexible field mapping for custom business data.

Upsert Key: source_record_id + source_system

full_load Behavior:

  • false (default): Incremental upsert - updates existing records, inserts new ones
  • true: Full replacement - deletes all existing records in the table, then inserts new data

Table Selection: Use tableName path parameter to specify which table (customer_data_table_1 to customer_data_table_20)

Required Fields: none enforced at the API layer. source_record_id and source_system are strongly recommended — together they form the natural upsert key; omitting them means every POST inserts a new row instead of updating.

Field Mapping: Populate text_field_1-30, number_field_1-10, and date_field_1-10 based on your data model

Request​

Responses​

Insert/update result