invoke_connector_operation
Invoke a dynamic operation on an API connection to retrieve resources (tables, queues, folders) or schemas for populating workflow action parameters.
Instructions
Invoke a dynamic operation on an API connection to fetch connection-specific data like dropdown values, schemas, or metadata. This is the equivalent of what the Logic Apps designer does when you click on a dropdown or text field - it calls the connector to populate the options.
WHEN TO USE THIS TOOL:
After getting connector swagger with get_connector_swagger, you see operations with 'x-ms-dynamic-values' or 'x-ms-dynamic-schema'
You need to list available tables, queues, folders, or other resources from a connection
You need to get the schema/columns for a specific table or entity
You're authoring a workflow and need to know valid values for action parameters
WORKFLOW FOR AUTHORING WITH CONNECTORS:
Use get_connector_swagger to discover operations and see x-ms-dynamic-values annotations
Use get_connections to find existing connections in the resource group
Use invoke_connector_operation to call the dynamic operation (e.g., GetTables, GetQueues)
Use the returned values to populate your workflow action parameters
COMMON EXAMPLES:
SQL: operationId='GetTables' returns list of tables, operationId='GetTable' with table parameter returns column schema
Service Bus: operationId='GetQueues' returns available queues
SharePoint: operationId='GetDataSets' returns sites, then GetTables for lists
Blob Storage: operationId='GetDataSets' returns containers
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| subscriptionId | Yes | Azure subscription ID | |
| resourceGroupName | Yes | Resource group containing the API connection | |
| connectionName | Yes | Name of the API connection (e.g., 'sql-1', 'servicebus', 'azureblob') | |
| operationId | Yes | The operationId from the connector swagger to invoke (e.g., 'GetTables', 'GetQueues', 'GetDataSets') | |
| parameters | No | Parameters required by the operation. Check the swagger for required parameters. For example, GetTable requires {table: 'tableName'} |