Azure function (VS2017) SQL table binding

Question

I'm trying to bind data from AF to Azure SQL. It's easy to do in Azure Portal adding the binding params in function.json file

 {
  "type": "apiHubTable",
  "name": "outputTable",
  "dataSetName": "default",
  "tableName": "SpeechToText",
  "connection": "sql_SQL",
  "direction": "out"
}

But I cant do this in VS2017 preview( Binding to Azure SQL is unavailable)

enter image description here

Mikhail Shilkov · Accepted Answer · 2017-07-08 09:19:37Z

2

You need to reference Microsoft.Azure.WebJobs.Extensions.ApiHub NuGet package

Install-Package Microsoft.Azure.WebJobs.Extensions.ApiHub -Version 1.0.0-beta3 -Pre

and then use ApiHubTable attribute for your binding

[ApiHubTable("sql_SQL", DataSetName = "default", TableName = "SpeechToText")]

answered Jul 8, 2017 at 9:19

Mikhail Shilkov

35.3k4 gold badges78 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

bc3tech Over a year ago

And what is the type for the parameter, then?

Mikhail Shilkov Over a year ago

@bc3tech I assume ITable<MyRow>, see example in the docs

bc3tech Over a year ago

actually looks like IAsyncCollector<T>, because trying to use ITable in the portal is problematic due to reference library and namespace ambiguities

Jonathan B. Over a year ago

@Mikhail Where does one find the documentation for the ApiHubTableAttribute class? Is this open source? I only find an example of its usage from a GitHub search: github.com/PacktPublishing/…

Collectives™ on Stack Overflow

Azure function (VS2017) SQL table binding

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related