Overview:
When updating the Product document field for certain documents using Vault Loader, users get the error: Object field value(s) do not resolve to a valid active [product__v.name__v].
id | product__v.name__v |
1111 | Product 1 |
2222 | Product 2 |
Root Cause:
This error indicates that the product__v.name__v is not a valid column name. This is because the Product field is a multi-value field, and users can only add relationships through multi-value relationship fields using ID values or through a lookup based on a unique field.
Solution:
Users can follow the steps below:
- Open the CSV file and change the column name from product__v.name__v to product__v.
- Populate the product id in the product__v column.
id product__v 1111 00P000000000O03,00P000000000A02 2222 00P000000000O03 - Upload the CSV file using Loader by selecting Documents for Object Type, Update for Action Type, and ID for Key Field.
Related Documentation:
- Vault Help Documentation: Vault Help