Import Set API with Robust Transform map - response is always "Invalid table" error - Support and Troubleshooting

Import Set API with Robust Transform map - response is always "Invalid table" error Issue Import Set Table : u_importset_table

EndPoint : POST /now/import/{stagingTableName}

Response: { "import_set": "ISET00000000", "staging_table": "u_importset_table", "result": [ { "transform_map": "", "status": "error", "error_message": "Invalid table " } ] }

Robust Transform map is used.

Records are getting created updated correctly but with the error response.

Cause POST /now/import/{stagingTableName} Inserts incoming data into a specified staging table and triggers transformation based on predefined transform maps in the import set table.

Resolution insertMultiple needs to be used for Robust Transform Map

POST /now/import/{stagingTableName}/insertMultiple

Inserts multiple records into a specified staging table and triggers transformation based on predefined transform maps or Robust Transform Engine (RTE) configurations in a single request. Transformation is asynchronous by default. To set synchronous transformation, create a new record in the Rest Insert Multiples [sys_rest_insert_multiple] table, select the source table, and set the transformation to synchronous.