Azure Pricing Spreadsheet

Azure Pricing Spreadsheet – Azure Functions External Tables Links (draft version)
2017-4-12 3 minutes to read Collaborators Alex Karcher OpenLocalizationService
This article shows how to manipulate tabular data from SaaS providers (for example, Sharepoint and Dynamics) within the function with built-in links. Azure Functions supports inbound and outbound links for external tables.
This is the reference information for developers of Azure Functions. If you are familiar with Azure Functions, start with the following resources:
Creating your first Azure feature
Azure Functions Developer Reference
Reference for C #, F #, or Node Developers
Azure Functions and Bindings Basics Functions
API Connections
Table bindings leverage external API connections to authenticate with third-party SaaS providers.
When assigning a link, you can either create a new API connection or use an existing API connection within the same resource group

Conexiones de API compatibles (tablas)

Dynamics 365 for Operationsxx
Dynamics 365xx
Dynamics NAVxx
Google Sheetsxx
Dynamics 365 for Financialsxx
Oracle Databasexx
Common Data Servicexx
SQL Serverxx

API connection creation: step-by-step

Creating a function> custom function Creating a custom function
Experimental Scenario> ExternalTable-CSharp template> Creating a new External Table connection Choosing a template d table entry
Choosing the SaaS Provider> Choosing / Creating a Connection Configuring the SaaS Connection
Selecting the API connection> Creating the function Creating the table function
Integrate Selection> External Table
Configure the connection to use the target table. This configuration will largely depend on SaaS providers. They are listed below in Configuring the Data Source Configure Table
In this example, it connects to a table named “Contact” with columns Id, LastName, and FirstName. The code shows the contact entities in the table and records the first and last names.
Related Links

“bindings”: [
“type”: “manualTrigger”,
“direction”: “in”,
“name”: “input”
“type”: “apiHubTable”,
“direction”: “in”,
“name”: “table”,
“connection”: “ConnectionAppSettingsKey”,
“dataSetName”: “default”,
“tableName”: “Contact”,
“entityId”: “”,
“disabled”: false

ConnectionAppSettingsKey identifies the application configuration that stores the API connection string. Application settings are automatically created when an API connection is added to the built-in user interface.
A tabular connector provides data sets, and each dataset contains tables. The name of the default data set is “default”. The titles of a dataset and a table in several SaaS providers are listed below:

SharePointSitioLista de SharePoint
SQLBase de datosTabla
Hoja de cálculo de GoogleHoja de cálculoHoja de cálculo
ExcelArchivo de ExcelHoja


#r “Microsoft.Azure.ApiHub.Sdk”
#r “Newtonsoft.Json”

using System;
using Microsoft.Azure.ApiHub;

//Variable name must match column type
//Variable type is dynamically bound to the incoming data
public class Contact
public string Id { get; set; }
public string LastName { get; set; }
public string FirstName { get; set; }

public static async Task Run(string input, ITable<Contact> table, TraceWriter log)
//Iterate over every value in the source table
ContinuationToken continuationToken = null;
//retreive table values
var contactsSegment = await table.ListEntitiesAsync(
continuationToken: continuationToken);

foreach (var contact in contactsSegment.Items)
log.Info(string.Format(“{0} {1}”, contact.FirstName, contact.LastName));

continuationToken = contactsSegment.ContinuationToken;
while (continuationToken != null);

Google Spreadsheets

In Google Docs, create a spreadsheet with a spreadsheet called Contact. The connector can not use the display name of the worksheet. The internal name (in bold) has to be used as dataSetName, for example: Add the column names Id, LastName, FirstName to the first row, and then complete the data in the rows Below.

DataSetName is the “default”.
Next steps
For more information on other links and triggers for Azure Functions, see References for Azure Functions Triggers and Links