service_endpoints

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

Overview

Name	service_endpoints
Type	Resource
Id	azure_extras.intelligent_recommendations.service_endpoints

Fields

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	ServiceEndpoint resource properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, serviceEndpointName, subscriptionId	Returns ServiceEndpoint resources for a given name.
list_by_account_resource	SELECT	accountName, resourceGroupName, subscriptionId	Returns list of ServiceEndpoint resources for a given Account name.
create_or_update	INSERT	accountName, resourceGroupName, serviceEndpointName, subscriptionId	Creates or updates ServiceEndpoint resource.
delete	DELETE	accountName, resourceGroupName, serviceEndpointName, subscriptionId	Deletes ServiceEndpoint resources of a given name.
update	UPDATE	accountName, resourceGroupName, serviceEndpointName, subscriptionId	Updates ServiceEndpoint resource details.

SELECT examples

Returns list of ServiceEndpoint resources for a given Account name.

SELECT
location,
properties,
systemData,
tags
FROM azure_extras.intelligent_recommendations.service_endpoints
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new service_endpoints resource.

All Properties

/*+ create */
INSERT INTO azure_extras.intelligent_recommendations.service_endpoints (
accountName,
resourceGroupName,
serviceEndpointName,
subscriptionId,
tags,
location,
properties,
systemData
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ serviceEndpointName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ systemData }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: preAllocatedCapacity
          value: integer
        - name: pairedLocation
          value: string
        - name: url
          value: string
        - name: provisioningState
          value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a service_endpoints resource.

/*+ update */
UPDATE azure_extras.intelligent_recommendations.service_endpoints
SET 
tags = '{{ tags }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceEndpointName = '{{ serviceEndpointName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified service_endpoints resource.

/*+ delete */
DELETE FROM azure_extras.intelligent_recommendations.service_endpoints
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceEndpointName = '{{ serviceEndpointName }}'
AND subscriptionId = '{{ subscriptionId }}';