organizations

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

Overview

Name	organizations
Type	Resource
Id	azure_isv.confluent.organizations

Fields

vw_organizations

Name	Datatype	Description
id	text	The ARM id of the resource.
name	text	The name of the resource.
created_time	text	field from the properties object
link_organization	text	field from the properties object
location	text	Location of Organization resource
offer_detail	text	field from the properties object
organizationName	text	field from the properties object
organization_id	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sso_url	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Organization resource tags
type	text	The type of the resource.
user_detail	text	field from the properties object

organizations

Name	Datatype	Description
id	string	The ARM id of the resource.
name	string	The name of the resource.
location	string	Location of Organization resource
properties	object	Organization resource property
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Organization resource tags
type	string	The type of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	organizationName, resourceGroupName, subscriptionId
list_by_resource_group	SELECT	resourceGroupName, subscriptionId
list_by_subscription	SELECT	subscriptionId
create	INSERT	organizationName, resourceGroupName, subscriptionId, data__properties
delete	DELETE	organizationName, resourceGroupName, subscriptionId
update	UPDATE	organizationName, resourceGroupName, subscriptionId

SELECT examples

vw_organizations

SELECT
id,
name,
created_time,
link_organization,
location,
offer_detail,
organizationName,
organization_id,
provisioning_state,
resourceGroupName,
sso_url,
subscriptionId,
system_data,
tags,
type,
user_detail
FROM azure_isv.confluent.vw_organizations
WHERE subscriptionId = '{{ subscriptionId }}';

organizations

SELECT
id,
name,
location,
properties,
systemData,
tags,
type
FROM azure_isv.confluent.organizations
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.confluent.organizations (
organizationName,
resourceGroupName,
subscriptionId,
data__properties,
properties,
tags,
location
)
SELECT 
'{{ organizationName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      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
    - name: properties
      value:
        - name: createdTime
          value: string
        - name: provisioningState
          value: []
        - name: organizationId
          value: string
        - name: ssoUrl
          value: string
        - name: offerDetail
          value:
            - name: publisherId
              value: string
            - name: id
              value: string
            - name: planId
              value: string
            - name: planName
              value: string
            - name: termUnit
              value: string
            - name: termId
              value: string
            - name: privateOfferId
              value: string
            - name: privateOfferIds
              value:
                - string
            - name: status
              value: []
        - name: userDetail
          value:
            - name: firstName
              value: string
            - name: lastName
              value: string
            - name: emailAddress
              value: string
            - name: userPrincipalName
              value: string
            - name: aadEmail
              value: string
        - name: linkOrganization
          value:
            - name: token
              value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a organizations resource.

/*+ update */
UPDATE azure_isv.confluent.organizations
SET 
tags = '{{ tags }}'
WHERE 
organizationName = '{{ organizationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified organizations resource.

/*+ delete */
DELETE FROM azure_isv.confluent.organizations
WHERE organizationName = '{{ organizationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';