{ "definition": { "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#", "actions": { "Get_rows_(V2)": { "inputs": { "host": { "connection": { "name": "@parameters('$connections')['sql_2']['connectionId']" } }, "method": "get", "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('default'))},@{encodeURIComponent(encodeURIComponent('default'))}/tables/@{encodeURIComponent(encodeURIComponent(body('Parse_JSON')?['tablename']))}/items" }, "runAfter": { "Parse_JSON": [ "Succeeded" ] }, "type": "ApiConnection" }, "Parse_JSON": { "inputs": { "content": "@triggerBody()", "schema": { "properties": { "tablename": { "type": "string" } }, "type": "object" } }, "runAfter": {}, "type": "ParseJson" } }, "contentVersion": "1.0.0.0", "outputs": {}, "parameters": { "$connections": { "defaultValue": {}, "type": "Object" } }, "triggers": { "manual": { "inputs": { "schema": { "properties": { "tablename": { "type": "string" } }, "type": "object" } }, "kind": "Http", "type": "Request" } } }, "parameters": { "$connections": { "value": { "sql_2": { "connectionId": "yourconnection", "connectionName": "sql-3", "id": "yourid" } } } } }