Skip to main content

functions

Creates, updates, deletes, gets or lists a functions resource.

Overview

Namefunctions
TypeResource
Idazure.app_service.functions

Fields

The following fields are returned by SELECT queries:

Function information returned.

NameDatatypeDescription
idstringResource Id.
namestringResource Name.
kindstringKind of resource.
propertiesobjectFunctionEnvelope resource specific properties
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, name, functionName, subscriptionIdDescription for Get function information by its ID for web site, or a deployment slot.
listselectresourceGroupName, name, subscriptionIdDescription for List the functions for a web site, or a deployment slot.
createinsertresourceGroupName, name, functionName, subscriptionIdDescription for Create function for web site, or a deployment slot.
deletedeleteresourceGroupName, name, functionName, subscriptionIdDescription for Delete a function for web site, or a deployment slot.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
functionNamestringFunction name.
namestringSite name.
resourceGroupNamestringName of the resource group to which the resource belongs.
subscriptionIdstringYour Azure subscription ID. This is a GUID-formatted string (e.g. 00000000-0000-0000-0000-000000000000).

SELECT examples

Description for Get function information by its ID for web site, or a deployment slot.

SELECT
id,
name,
kind,
properties,
type
FROM azure.app_service.functions
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND name = '{{ name }}' -- required
AND functionName = '{{ functionName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Description for Create function for web site, or a deployment slot.

INSERT INTO azure.app_service.functions (
data__kind,
data__properties,
resourceGroupName,
name,
functionName,
subscriptionId
)
SELECT
'{{ kind }}',
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ name }}',
'{{ functionName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
kind,
properties,
type
;

DELETE examples

Description for Delete a function for web site, or a deployment slot.

DELETE FROM azure.app_service.functions
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND functionName = '{{ functionName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;