Auto-map JDBC activity output variables

The ServiceNow activity designer allows you to map parameter values in a JDBC test payload to variables in the Outputs tab automatically.

Before you begin

Role required: admin

Procedure

  1. In the JDBC provider template form, select the Inputs tab.
  2. Click Test Activity to test the input parameters.
    If you added actual values for the parameters and fields, the system runs those values against the specified target and returns the resulting payload. If you mapped input variables to fields and parameters, the system displays a dialog box for assigning test values to those variables.
  3. Provide test values, if requested, and click OK to display the payload.
    The entire payload appears in the Raw Output tab of the Response form.
    Auto-mapping controls
  4. Select one of these auto-mapping options.
    • Auto-Map to Local: Directly maps values to a local variable for use within the activity.
    • Auto-Map to Output: Directly maps values to the output variable to pass to other activities in the workflow. Auto-mapping to an output variable creates an array of objects, each of which contains the column names from the query result.