Populate parameter from table columns

Support
1

Scenario: I have a number 3 static text, multiline parameters - {AccountIds}, {SupporterIds}, {ContactIds}.

image
image303×292 14.6 KB

I pass each one in to various 'Import from Salesforce' actions that exist at various points in my workflow, in order to fetch limited pots of data from parameterized Salesforce objects

Example:

image
image454×455 13.5 KB

Filter: :backhand_index_pointing_down:t4:

image
image669×147 9.71 KB

(ContactPointAddress, Account, Supporter_Consent__c etc)

In order to populate each field, I need to manually copy & paste the concatenated Ids from one table.

image
image750×169 35.4 KB

The Ids are not immediately available at the start of the workflow, so once they HAVE been generated in the workflow, I manually copy & paste the values into each parameter - each time.

The problem: I (or the person running the workflow) must remember to manually refresh the Ids each time – otherwise the auto-fetched Salesforce data doesn’t match the current data set.

I'm currently making do with a To-do to remind or the user.

image
image393×264 36.2 KB

Can anyone suggest or recommend how I can automate this last step by, perhaps, auto-populating the parameters as soon as the data becomes available in my workflow?

Something tells me that the answer lies in either JSON (or XML), which I am only vaguely familiar with beyond interrogating API endpoints.

Thank you

2

Hi Nike,

No need to do it manually. EasyMorph has a mechanism called iterations which is basically loops. You need to create another module wiht these 3 parameters and move import from Salesforce into that module. Then use the "Iterate" action to call that module for a list of values. The action will assign the parameters of the called module with values from columns.

Iterations require a bit of learning, so I suggest taking a closer look at our tutorial articles on modules and iterations: