How to fetch specific field values from the output of Lookup Record(s) action through Scripts?

[Sujitha5]

Hi 

I have created a custom action using the Flow Designer on my instance. I have used the Look Up Record(s) action to retrieve the list of records from the conditions that i have given. On next step i need those records from the 1st step to be ingested into 2nd step which is a Script Step.

For. eg I have 3 records as output from the Look up Records action and iterating the 3 records with a loop condition. Here I cannot fetch the specific fields from the output of the 1st record. The output records has data with integer, string and duration data type. u_corporate_account is the field that is present in the output.

(function execute(inputs, outputs) {
var inputArray = inputs.lookupRecords;                                         -------> Ingesting input records from the Lookup action
var corpName= inputs.currentAlertCorpName;
var resultant = [];
outputs.debugstr="go-";
for (var value in inputArray){
var corporate_account = value.u_corporate_account;                 
outputs.debugstr+="corp_account is "+corporate_account+" \n";                   -------> here received "Undefined" as output
if(corpName.startsWith(corporate_account)){
resultant.push(inputArray[value]);
}
}
})(inputs, outputs);

This is a piece of code that i used to debug. Can anyone help me how to fetch fields from the output records of the Look up Records step through the script.

[Ankur Bawiskar]

this one

How to loop through Flow Designer step result list in a script

Regards
Ankur

[Ankur Bawiskar]

Hi,

I was able to achieve as per docs

For your custom Action your input variable should be of Type

Records.<Your Table Name>

Regards
Ankur

[Sujitha5]

I was able to get the field value. Just now tried using this script

(function execute(inputs, outputs) {
// ... code ...

var inputArray = inputs.lookupRecords;
var corpName= inputs.currentAlertCorpName;
var resultant = [];

outputs.debugstr="";

while(inputArray.next()){
//for (var value in inputArray){
var corporate_account = inputArray.u_corporate_account;

outputs.debugstr+="corp account is"+corporate_account";

}
})(inputs, outputs);

Output:

corp account is XYZ

After the changing the iteration method i was able to achieve this

Thanks for your help Ankur.

[Ankur Bawiskar]

@Sujitha 

Please mark my response as correct and close the thread.

[Ankur Bawiskar]

Hi,

there is an example on docs for the same

Create a custom action to generate an array of objects from a list of records

Regards
Ankur