Open MannyAdumbire opened 2 years ago
ps - I initially tried to find matches using "SalesforceQuery.find_record" and only switched to"SalesforceQuery.random_record" after that didn't work
There is a new, beta, feature for Snowfakery for doing upserts. I will try to get it into this week's CumulusCI release so you can try it.
The new feature sounds exciting!
I just tried( and failed with error) to use upsert feature in cci mapping step- https://cumulusci.readthedocs.io/en/latest/data.html?highlight=snowfakery#upsert
Honestly, I'm amazed it actually almost works just using Snowfakery! The well-written documentation has helped me out a ton too.
I'm always happy to beta test ;)
I'm trying to seed Salesforce org using values from Spreadsheet, and seem close to having it work, but getting some errors.
The recipe should use SalesforceQuery to prematch any Contacts with the same email addresses as one in CSV Dataset. If no match was found, a new Contact record should be created.
This recipe works when a Contact matching the email address already exists in the Salesforce org. However, the same recipe throws an error if no match was found.
How can I conditionally upsert pre-existing matched record in recipe, or create a new one if no matches were found?
Really appreciate any help!
CSV Dataset
Recipe