• Upsert operation: Mapping field ID is showing invalid type

Upsert operation: Mapping field ID is showing invalid type

  • 44Views
  • Last Post 20 December 2022
0
votes
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.

upsert

Attached Files

0
votes
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: https://docs.skyvia.com/data-integration/import/performing-upsert-operation.html

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

 

Best regards,

Serhii

New Ticket
Categories
Popular Tags
Close