Upsert operation: Mapping field ID is showing invalid type

  • 44Views
  • Last Post 20 December 2022
Michael Reilly posted this 19 December 2022

We want to use Upsert operation but while doing mapping, we faced an error in Mapping like Invalid Type for an ID field. 

In Mapping window, Under Target column, it showed a required field as ID but when we tried to map it in Source column with field CaseSafeID or ID, it displayed as invalid type. 

Please let us know how to map that field. So, we can update and insert the records in target instance.

Attached Files

Serhii Muzyka posted this 20 December 2022

Hi Michael,


Thank you for contacting Skyvia Support.


For this case, we recommend using Target Lookup mapping.

Please try this example to map your fields:

Note: When using lookup mapping for ID or primary key columns in UPSERT, do not forget to select the Set null when no match found checkbox in Lookup Options. Otherwise, lookup will produce errors if no such record is found, and there would be failed records instead of inserted new ones.

See more about performing UPSERT operation here:

Should you have other questions, don't hesitate to reach out.


Best regards,