Mapping the RowNo Column for UPDATE/UPSERT Operations in Google Sheets
When implementing UPDATE/UPSERT operations in Google Sheets, you may need to set up mapping for the RowNo mandatory field.
RowNo is a unique auto-generated row number in the Sheet. It is essential for performing UPSERT/UPDATE operations, as it determines whether the required row for updating exists or not, ensuring the update operation is carried out correctly.
To map the RowNo column, please use Target Lookup Mapping. You can find an example below:
In this case, it is assumed that the Lookup Key Columns Name and Sku contain unique data. Therefore, in the target, we look for a record (RowNo from Sheet1) where the source Sku matches the target Name. If a record is found:
- With the UPDATE operation, we will update the found record using its RowNo value. If not found, an error will occur stating that the record was not found.
- With the UPSERT operation, we will update the found record using its RowNo value. If it is not found, the option “Set null when no match found” will be triggered (if selected), and a new record will be created in the target with an automatically generated RowNо.
NOTE: Please ensure that the fields used as Lookup Key Columns (Sku and Name) are also mapped to each other through Column Mapping.
For more information on the topic, check the following articles:
Related Articles
A Quick Guide to Importing and Updating Audience Members in Mailchimp
If your integration involves importing data into Mailchimp Audiences, this information might be helpful. To start, let’s take a quick look at how the UPSERT operation works: If the Id is specified, the integration attempts an Update operation even if ...
Mapping Multi-Select Fields
When working with Import, Synchronization, or Data Flow integrations and needing to map multi-select fields with different values between the source and target, you can use Expression Mapping. Expression mapping allows using simple and complex ...
BigCommerce: "The value of the column Categories has incorrect JSON format" error
When working with the Categories field in the Product object within the BigCommerce API, it's important to understand how to format and import data correctly to ensure a successful import. In the BigCommerce API, the Categories field in the Product ...
Understanding Records in Skyvia Data Integration
1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process—Import, Replication, Export, Synchronization, etc —handles individual records. Records also serve ...
Salesforce Connect: Can't Sync the Schema Metadata for Your External System – Check That the Schema Metadata Is Valid. Error Code: Null
This error occurs because the object used in your endpoint does not have a primary key column. Salesforce requires a primary key for external objects, which is why you encounter an error when validating and syncing your External Data Source in ...