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 command

4min

ο»Ώ

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

Use this action to execute a SQL command in Microsoft SQL.

ο»Ώ

Document image
ο»Ώ

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

ο»Ώ

Document image
ο»Ώ

How to configure the Execute Command 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.

Step 1:Β Drag the Execute Command 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 for the database server (see here how to create one)ο»Ώ

Step 4: Click on Execute Command (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 single-value object/integer.

In the output variable, you will see the number of rows affected by the executed command.

Document image
ο»Ώ

Add the output variable:

Document image
ο»Ώ

Step 7: Save, Validate and Run the process.

Step 8: Click Check Instance to view the results.

Based on our command, 2 rows were affected:

ο»Ώ

Document image
ο»Ώ

ο»Ώ

Updated 19 May 2023
Did this page help you?
Yes
No
PREVIOUS
Execute Query
NEXT
Documents
Docs powered byΒ archbeeΒ