In a lot of cases in my flow scripts I have to query the database which returns a result array.
Then I have to map values from the result array into Record References. This requires me for each column in the result set to have to insert a String into the map step, -> over so its underneath the result array, then drag the map line over to the Record Reference’s associated field.
Is there some way I could auto-populate a record reference that maps exactly to the set of database columns? That way I won’t have to keep typing in and -> under the set of strings in the result set/array.
Does this make sense? Is there some better way to take rows from a DB and map them into Record Reference structures? The column names don’t match the names in the Record Reference (XSD schema), which is what usually forces the MAP steps.
Thanks for any ideas,