Using the Azure Functions Source

The Azure Functions Source component is used to execute Azure Functions and retrieve the response from the functions.

General page

The General page of the Azure functions Source Component allows you to specify the general settings of the component.

SSIS Azure Functions Source Component Editor - General

Connection Manager

The Azure Functions Source Component requires a connection in order to connect the specific Azure Functions. The Connection Manager drop-down will show a list of all connection managers that are available to your current SSIS packages.

URL

The URL specifies the route of the function, and it is usually in the below format:

http://<APP_NAME>.azurewebsites.net/api/<FUNCTION_NAME>

Authorization level

Authorization level controls whether the function requires an API key and which key to use. You can choose from the below three types depending on how it has been specified in the Azure portal for the function.

  • Function - Default value. Uses a function key, found in the 'keys' management panel on the portal.
  • Admin - Uses your master key, found in the 'keys' management panel on the portal.
  • Anonymous - No API key is required.
Authorization Code

The code of the function generated from the Azure portal is to be specified here which goes in the request header.

Method

An array of the HTTP methods to which the function responds. If not specified in the Azure portal, the function responds to all HTTP methods. You can choose from the below:

  • DELETE
  • GET
  • HEAD
  • OPTIONS
  • PATCH
  • POST
  • PUT
  • TRACE
Body

Specify the values to be in the body of the request. You can choose the Editor pane to accept the below.

  • HTML
  • JSON
  • Plain Text
  • SQL
  • XML
Query String

The Query String values can be specified here. You can click on the “+” button to add the Query String Name and the Query String Value.

Headers

Specify any header values to go with the request. You can click on the “+” button to add the Header Name and the Header Value

Preview Button

The preview button launch the Preview dialog which will send the first request based on the current settings of the component, and show a preview of the response. You can execute the function with the button “Execute Function” and get the response in the second window.

SSIS Azure Functions Source Component - Previews

Expression fx Icon

Click the blue fx icon to launch SSIS Expression Editor to enable dynamic update of the property at run time.

Generate Documentation Icon
Click the Generate Documentation icon to generate a Word document which describes the component's metadata including relevant mapping, and so on.

Columns

The Columns page of the Azure Functions Source Component shows you the available columns based on the settings in the Document Designer page.

SSIS Azure Functions Source Component Editor - Columns

In the Grid, there are two columns that determines the output from the component.

  • Output Field - The Output fields that are available from the Source component.
  • Data Type - The datatype details of the output field. You click on the field to toggle it between nvarchar, ntext or image etc depending on how you need the output.
Add Response Header Column

This button can be used to ads a response header column that will be received in the responses.

SSIS Azure Functions Source Component - Add Custom Header Column

Hide Unselected Fields
When the Hide Unselected Fields checkbox is checked unselected output columns will be hidden.
Hide Selected Fields
When the Hide Selected Fields checkbox is checked used selected columns will be hidden.