locations

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

Overview

Name	locations
Type	Resource
Id	azure_stack.subscriptions_admin.locations

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Location identifier.
name	string	Location name.
displayName	string	Display name of the location.
latitude	string	Latitude of the location.
longitude	string	Longitude of the location.

list

Name	Datatype	Description
id	string	Location identifier.
name	string	Location name.
displayName	string	Display name of the location.
latitude	string	Latitude of the location.
longitude	string	Longitude of the location.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, location		Get the specified location.
list	select	subscriptionId		Get a list of all AzureStack location.
create_or_update	insert	subscriptionId, location		Updates the specified location.

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.

Name	Datatype	Description
location	string	The AzureStack location.
subscriptionId	string	Subscription credentials which uniquely identify Microsoft Azure subscription.The subscription ID forms part of the URI for every service call.

SELECT examples

get

Get the specified location.

SELECT
id,
name,
displayName,
latitude,
longitude
FROM azure_stack.subscriptions_admin.locations
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND location = '{{ location }}' -- required
;

list

Get a list of all AzureStack location.

SELECT
id,
name,
displayName,
latitude,
longitude
FROM azure_stack.subscriptions_admin.locations
WHERE subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

create_or_update

Updates the specified location.

INSERT INTO azure_stack.subscriptions_admin.locations (
data__displayName,
data__id,
data__latitude,
data__longitude,
data__name,
subscriptionId,
location
)
SELECT 
'{{ displayName }}',
'{{ id }}',
'{{ latitude }}',
'{{ longitude }}',
'{{ name }}',
'{{ subscriptionId }}',
'{{ location }}'
RETURNING
id,
name,
displayName,
latitude,
longitude
;

Manifest

# Description fields are for documentation purposes
- name: locations
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the locations resource.
    - name: location
      value: string
      description: Required parameter for the locations resource.
    - name: displayName
      value: string
      description: |
        Display name of the location.
    - name: id
      value: string
      description: |
        Location identifier.
    - name: latitude
      value: string
      description: |
        Latitude of the location.
    - name: longitude
      value: string
      description: |
        Longitude of the location.
    - name: name
      value: string
      description: |
        Location name.