MCX Data provider access

This activity allows users to execute an SQL query against a Data Provider defined in MCX to send data to and retrieve data from MCX.

Note: MCX version 1.1 or higher is required to use this activity.

Table 1. MCX Data provider access action - Inputs
Parameters	Description
DataProvider	Select the name of a data provider as defined in MCX.
SQLQuery	Enter the query in Transact-SQL that will be run against the selected Data Provider. The SQL will be automatically validated as the query is entered. If the query syntax is parsed as invalid, it will be marked in red, and a tooltip will display the parsing error. Note: The validation is only parsed against a valid Transact-SQL format; it cannot determine if table names or attribute values are correct in MCX.
Timeout	Enter the timeout period in seconds for the query. The default value is 30.

Table 2. MCX Data provider access action - Outputs
Parameters	Description
Success	Indicates whether the activity was completed successfully (value = True) or not (value = False).
StatusCode	Returns the HTTP response code from MCX for the query.
Body	Returns the HTTP response body from MCX for the query response.