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:
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 ...