resources

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

Overview

Name	resources
Type	Resource
Id	azure_extras.saas.resources

Fields

The following fields are returned by SELECT queries:

get

Request successful. The request returns the resulting SaaS resource.

Name	Datatype	Description
id	string	The resource uri
name	string	The name of the resource
properties	object	saas resource properties
tags	object	the resource tags.
type	string	Resource type.

list

Name	Datatype	Description
id	string	The resource uri
name	string	The name of the resource
properties	object	saas resource properties
tags	object	the resource tags.
type	string	Resource type.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resourceId		Gets information about the specified SaaS.
list	select			Get All Resources
create	insert			Creates a SaaS resource.
update	update	resourceId		Updates a SaaS resource.

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
resourceId	string	The Saas resource ID. This is a GUID-formatted string (e.g. 00000000-0000-0000-0000-000000000000)

SELECT examples

get

Gets information about the specified SaaS.

SELECT
id,
name,
properties,
tags,
type
FROM azure_extras.saas.resources
WHERE resourceId = '{{ resourceId }}' -- required
;

list

Get All Resources

SELECT
id,
name,
properties,
tags,
type
FROM azure_extras.saas.resources
;

INSERT examples

create

Creates a SaaS resource.

INSERT INTO azure_extras.saas.resources (
data__name,
data__tags,
data__location,
data__properties
)
SELECT 
'{{ name }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
RETURNING
id,
name,
properties,
tags,
type
;

Manifest

# Description fields are for documentation purposes
- name: resources
  props:
    - name: name
      value: string
      description: |
        The resource name
    - name: tags
      value: object
      description: |
        the resource tags.
    - name: location
      value: string
      description: |
        Resource location. Only value allowed for SaaS is 'global'
    - name: properties
      value: object
      description: |
        properties for creation saas

UPDATE examples

update

Updates a SaaS resource.

UPDATE azure_extras.saas.resources
SET 
data__name = '{{ name }}',
data__tags = '{{ tags }}',
data__location = '{{ location }}',
data__properties = '{{ properties }}'
WHERE 
resourceId = '{{ resourceId }}' --required
RETURNING
id,
name,
properties,
tags,
type;