MySQL - Execute a query

Use the MySQL - Execute a query action A tool for building the processes, logic, and direction within workflows. to run queries in a database you specify. A query can be a request for data or for action.

For example, you want to generate a directory of your customers' mobile phone numbers. To achieve this, you need to retrieve the phone numbers from your company database. By using the MySQL - Execute a query, you can retrieve these data, store them in variables, and then insert in a Generate document action.

Before you start 

Configure the MySQL - Execute a query action

In the Designer page: 

  1. Click the MySQL action group in the action toolbox.

    or

    Find actions by browsing action groups or by typing an action name or function in the Search field at the top of the action toolbox.

  2. Drag the MySQL - Execute a query action to the point in the workflow when you want to run a query.
  3. Click the MySQL - Execute a query action.
  4. Select a Connection.

  5. Caution: Make sure to first configure your database's firewall to allow your workflow to connect to your database. For more information on source IP addresses you can use, see Connectors.

  1. In SQL script, type the statement to run a query on your database. For example: SELECT * FROM [Customers]
  2. For more guidance on SQL keywords and syntax, see SQL Keywords Reference.

  3. In Column to retrieve, type the database column that contains the values you want to retrieve. For example, "Email address".

For more information on the fields and buttons, see MySQL - Execute a query fields, and settings.

Maintain path integrity

Caution: If a file/folder that's used in a workflow is moved, renamed, or deleted, any workflows that use that file/folder will not start or will fail. Make sure you keep the paths in your workflow configurations up to date.