+1How do you read a single record from a SQL table based on its primary key and store it in an object variable in a workflow.
I can get a collection of 1, but cannot extract the record into an object of the same type as the table.
It only allows me to extract it to a workflow variable.
I would like the same functionality as for SharePoint: ie ‘Retrieve an item’
Best answer by Garrett
Hi
Example (Using Azure SQL for database)
+16Hi
I can see where you are coming from. SP Retrieve an Item (single, zero or one) is easier to work with than SP Query a List (multiple, zero or many).
Like most object types, you need to use a Loop for Each to retrieve values from a collection (even if your collection has only 1 items)
Inside the Loop, you can assign each column value to a workflow variable.
+16Hi
Example (Using Azure SQL for database)
+13Garrett has a nice example of using the loop functionality, which is what I use.
There are some other actions like the sharepoint online - query a list action which support a ‘first item’ option in the output variable.
I’ve raised an idea request last year to add the ‘First item’ support in the output for SQL actions.
If you could upvote the idea that would be greatly appreciated.
Add First Item to SQL On-premises actions and object | Nintex Ideas
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.