Assign SQL Result to Parameter

[dgudkov]

@beerye3

However, I would like to perform different actions based upon whether a value is found or not.

You can use conditional branching with derived tables to have two branches of logic depending on a value is found or not. See the tutorial article on conditional branching here: EasyMorph | Conditional workflows

@beerye3

If it’s not found, then I would need an action that would insert a row into the same table, and then assign the key for the new row to the parameter.

The "Export to database" action can insert a row into the table. You can use it in the workflow branch that should be executed when no value was found.

Note that besides parameters, you can use first column values to define action properties. See Announcement: Using first column value in action properties

@beerye3

I suppose I could run the custom SQL action first, then perform the lookup?

I don't see why you would need custom SQL here. You can do all of that with EasyMorph actions.