How to create LogicApp SQL Server Connector's API Connection using DotNet SDK

Question

Here is the steps to connect to a SQL Server or Azure SQL database from Azure Logic apps using the Azure portal.

https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure

But, I have to create SQL Server Connector's API Connection using the DotNet SDK.

Can you clarify. By .Net SDK, you mean with just c# or such and not a Logic App? — Johns-305, Jul 03 '18 at 10:48
SQL Server Connector Reference: https://learn.microsoft.com/en-us/connectors/sql/ — HiteshKumar Vaghasiya, Jul 03 '18 at 11:24

score 0 · Accepted Answer · answered Jul 04 '18 at 07:36

0

Currently, I can't find the creating logicApp connector API connection function from Azure SDK document.

If use the Rest API is possible, we could use the following rest API to do that.

put https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourcegroup}/providers/Microsoft.Web/connections/sql?api-version=2016-06-01

I also test it on my side with postman with following body.

{"properties":{"api":{"id":"/subscriptions/{subscriptionid}/providers/Microsoft.Web/locations/eastus/managedApis/sql"},"parameterValues":{"server":"{yourserverName}.database.windows.net","database":"{databaseName}","username":"{username}","password":"{password}"},"displayName":"{name}"},"location":"{location}"}

How to get the authorization token, please refer to another SO thread.

answered Jul 04 '18 at 07:36

Tom Sun - MSFT

24,161
3
30
47

This is worked. Do you know how to pass table name in request json? Thanks – HiteshKumar Vaghasiya Jul 04 '18 at 09:41
Also can you please share the link from where you got this reference. Thanks – HiteshKumar Vaghasiya Jul 04 '18 at 09:46
I don't find it in azure document. But I capture the Rest API from Azure portal while I am creating the connector. – Tom Sun - MSFT Jul 04 '18 at 09:52
We also could get the related information from ARM template https://github.com/Azure/azure-quickstart-templates/blob/master/101-logic-app-sql-proc/azuredeploy.json#L58 – Tom Sun - MSFT Jul 04 '18 at 09:59

How to create LogicApp SQL Server Connector's API Connection using DotNet SDK

1 Answers1