Skip to main content

free_services

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

Overview

Namefree_services
TypeResource
Idazure.billing_benefits.free_services

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
billingAccountResourceIdstringBilling account resource id where the free services metadata is present.
billingProfileResourceIdstringBilling profile resource id where the free services are scoped to.
customerResourceIdstringCustomer resource id where the free services are scoped to.
endAtstring (date-time)Expiration date and time of the free services.
etagstringThe etag field is not required. If it is provided in the response body, it must also be provided as a header per the normal etag convention. Entity tags are used for comparing two or more entities from the same requested resource. HTTP/1.1 uses entity tags in the etag (section 14.19), If-Match (section 14.24), If-None-Match (section 14.26), and If-Range (section 14.27) header fields.
identityobjectManaged service identity (system assigned and/or user assigned identities).
kindstringMetadata used by portal/tooling/etc to render different UX experiences for resources of the same type. E.g. ApiApps are a kind of Microsoft.Web/sites type. If supported, the resource provider must validate and persist this value.
locationstringThe geo-location where the resource lives. Required.
managedBystringThe fully qualified resource ID of the resource that manages this resource. Indicates if this resource is managed by another Azure resource. If this is present, complete mode deployment will not delete the resource if it is removed from the template since it is managed by another resource.
planobjectPlan for the resource.
productCodestringThis is the catalog UPN for the product.
provisioningStatestringProvisioning state of Free Services as assigned by RPaaS. This indicates the last operation's status. For all practical purposes, this can be ignored. For current status of Free Services resource, refer to FreeServicesStatus.
skuobjectThe resource model definition representing SKU.
startAtstring (date-time)Date and time when the free services become active.
statusstringCurrent status of the free services. Known values are: "Unknown", "Pending", "Active", "Canceled", and "Completed". (Unknown, Pending, Active, Canceled, Completed)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
systemIdstringThis is the globally unique identifier of the free services which will not change for its lifetime.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, free_service_name, subscription_idThis operation retrieves properties for free services.
list_by_resource_groupselectresource_group_name, subscription_idThis operation lists the free services that are available under the specified resource group.
list_by_subscriptionselectsubscription_idThis operation lists free services that are available under the specified subscription.
createinsertresource_group_name, free_service_name, subscription_id, locationThis operation creates or updates free services in Azure.
updateupdateresource_group_name, free_service_name, subscription_idThis operation updates free services in Azure.
deletedeleteresource_group_name, free_service_name, subscription_idThis operation deletes free services from the subscription. Only free services that are in an expired or cancelled states can be deleted.

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
free_service_namestringName of the free service. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

This operation retrieves properties for free services.

SELECT
id,
name,
billingAccountResourceId,
billingProfileResourceId,
customerResourceId,
endAt,
etag,
identity,
kind,
location,
managedBy,
plan,
productCode,
provisioningState,
sku,
startAt,
status,
systemData,
systemId,
tags,
type
FROM azure.billing_benefits.free_services
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND free_service_name = '{{ free_service_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

This operation creates or updates free services in Azure.

INSERT INTO azure.billing_benefits.free_services (
tags,
location,
properties,
managedBy,
kind,
identity,
sku,
plan,
resource_group_name,
free_service_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ managedBy }}',
'{{ kind }}',
'{{ identity }}',
'{{ sku }}',
'{{ plan }}',
'{{ resource_group_name }}',
'{{ free_service_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
identity,
kind,
location,
managedBy,
plan,
properties,
sku,
systemData,
tags,
type
;

UPDATE examples

This operation updates free services in Azure.

UPDATE azure.billing_benefits.free_services
SET
properties = '{{ properties }}',
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND free_service_name = '{{ free_service_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
identity,
kind,
location,
managedBy,
plan,
properties,
sku,
systemData,
tags,
type;

DELETE examples

This operation deletes free services from the subscription. Only free services that are in an expired or cancelled states can be deleted.

DELETE FROM azure.billing_benefits.free_services
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND free_service_name = '{{ free_service_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;