Loop Mapping Data Actions

Modified on Mon, 5 Jun, 2023 at 10:24 PM


Available in: Axsy Mobile for Salesforce, Axsy Field Service, Axsy Public Sector, Axsy Retail Execution


When creating a Mapping configuration for a Loop Element, you have three options for the Data Action. These are Upsert, Update and Create



Create

Select Create to make new Related List records. 



NOTE: The Create action will never alter existing Related List records



Update

Select Update to update existing Related List records only. 



NOTE: Update will not create any new records, even if the Loop iterates for more times than there are existing records.



Upsert

Select Upsert if the number of Loop iterations you expect to run will be greater than the number of existing Related List records.


  • If the number of loop iterations is less than or equal to the number of existing Related List records, then Upsert will behave in the same way as Update and no additional records will be created.
  • If the number of loop iterations is more than the number of existing Related List records, Upsert will create new records for the surplus iterations.


Example: If you set a Loop Element to iterate 8 times for WorkOrderLineItem, but there are only 5 WorkOrderLineItems in Salesforce, the first five loops will update the existing records and then create new records for the remaining 3.


 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article