website logo
πŸ”­Overview
πŸ’ΌPlatform Actions
πŸ’œIntegrations
🧰Custom Actions
πŸ› οΈDeveloper's Guide
Navigate through spaces
⌘K
πŸ“•Call API
πŸ“•Generate Document
πŸ“•Call Subprocess
πŸ“•Decisional
βš“Decisional Further Reading
πŸ“•Join
πŸ“•Delay
πŸ“•For Each
πŸ“•Get File Data
πŸ“•Map Process Data
βœ‰οΈSend Email
πŸ“¬Inbound email
πŸ“Database
πŸ“Documents
πŸ“DateTime
πŸ“FTP/sFTP
πŸ“Json
πŸ“XPath
πŸ“Lists
πŸ“Numerical
πŸ“Strings
πŸ“Converters
πŸ“Excel
πŸ“Scripting
πŸ“Utilitary
πŸ“Pdf
πŸ“Beta
Docs powered byΒ archbeeΒ 

Execute Query

3min

ο»Ώ

Query vs Commands: There's a basic difference between them - commands modify the data, and queries retrieve the data.

Use this action to execute an SQL query in Microsoft SQL.

Document image
ο»Ώ

First of all, you'll have to enter credentials for the Execute Query action. You can find out how to do that here.

ο»Ώ

How to configure the Execute Query action?

Go to the Process Designers section and open a new or an existing process. Actions configuration can be performed once they are dragged and dropped on canvas.

Document image
ο»Ώ

Step 1:Β Drag the Execute Query action from Toolbar and drop it on canvas; click on the action to open the Properties Panel.

Step 2:Β You can edit the Action Name.

Step 3: Select a credential (see here how to create one)ο»Ώ

Step 4: Click on Execute Query (not configured) card to go to the configurations steps.

Step 5: Type your SQL query in the editor.

Note: you can always add process variables to your query. Press INSERT/Ctrl+I (Windows) or Cmd+I (Mac).

Step 6: Add the output variable. Note: it has to be defined as a list<objects>.

In the output variable, you will see the retrieved data/results based on the query.

ο»Ώ

Document image
ο»Ώ

Step 7: Save, Validate and Run the process.

Step 8: Click Check Instance to view the results.

Based on our query, a list with data was retrieved in the output variable:

Document image
ο»Ώ

ο»Ώ

Updated 10 Apr 2023
Did this page help you?
Yes
No
PREVIOUS
SQL Server
NEXT
Execute command
Docs powered byΒ archbeeΒ