connector_mappings

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

Overview

Name	connector_mappings
Type	Resource
Id	azure_extras.customer_insights.connector_mappings

Fields

vw_connector_mappings

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
description	text	field from the properties object
connectorName	text	field from the properties object
connector_mapping_name	text	field from the properties object
connector_name	text	field from the properties object
connector_type	text	field from the properties object
created	text	field from the properties object
data_format_id	text	field from the properties object
display_name	text	field from the properties object
entity_type	text	field from the properties object
entity_type_name	text	field from the properties object
hubName	text	field from the properties object
last_modified	text	field from the properties object
mappingName	text	field from the properties object
mapping_properties	text	field from the properties object
next_run_time	text	field from the properties object
resourceGroupName	text	field from the properties object
run_id	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
tenant_id	text	field from the properties object
type	text	Resource type.

connector_mappings

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
properties	object	The connector mapping definition.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	connectorName, hubName, mappingName, resourceGroupName, subscriptionId	Gets a connector mapping in the connector.
list_by_connector	SELECT	connectorName, hubName, resourceGroupName, subscriptionId	Gets all the connector mappings in the specified connector.
create_or_update	INSERT	connectorName, hubName, mappingName, resourceGroupName, subscriptionId	Creates a connector mapping or updates an existing connector mapping in the connector.
delete	DELETE	connectorName, hubName, mappingName, resourceGroupName, subscriptionId	Deletes a connector mapping in the connector.

SELECT examples

Gets all the connector mappings in the specified connector.

vw_connector_mappings

SELECT
id,
name,
description,
connectorName,
connector_mapping_name,
connector_name,
connector_type,
created,
data_format_id,
display_name,
entity_type,
entity_type_name,
hubName,
last_modified,
mappingName,
mapping_properties,
next_run_time,
resourceGroupName,
run_id,
state,
subscriptionId,
tenant_id,
type
FROM azure_extras.customer_insights.vw_connector_mappings
WHERE connectorName = '{{ connectorName }}'
AND hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

connector_mappings

SELECT
id,
name,
properties,
type
FROM azure_extras.customer_insights.connector_mappings
WHERE connectorName = '{{ connectorName }}'
AND hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.customer_insights.connector_mappings (
connectorName,
hubName,
mappingName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ connectorName }}',
'{{ hubName }}',
'{{ mappingName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: connectorName
          value: string
        - name: connectorType
          value: []
        - name: created
          value: string
        - name: lastModified
          value: string
        - name: entityType
          value: string
        - name: entityTypeName
          value: string
        - name: connectorMappingName
          value: string
        - name: displayName
          value: string
        - name: description
          value: string
        - name: dataFormatId
          value: string
        - name: mappingProperties
          value:
            - name: folderPath
              value: string
            - name: fileFilter
              value: string
            - name: hasHeader
              value: boolean
            - name: errorManagement
              value:
                - name: errorManagementType
                  value: string
                - name: errorLimit
                  value: integer
            - name: format
              value:
                - name: formatType
                  value: string
                - name: columnDelimiter
                  value: string
                - name: acceptLanguage
                  value: string
                - name: quoteCharacter
                  value: string
                - name: quoteEscapeCharacter
                  value: string
                - name: arraySeparator
                  value: string
            - name: availability
              value:
                - name: frequency
                  value: string
                - name: interval
                  value: integer
            - name: structure
              value:
                - - name: propertyName
                    value: string
                  - name: columnName
                    value: string
                  - name: customFormatSpecifier
                    value: string
                  - name: isEncrypted
                    value: boolean
            - name: completeOperation
              value:
                - name: completionOperationType
                  value: string
                - name: destinationFolder
                  value: string
        - name: nextRunTime
          value: string
        - name: runId
          value: string
        - name: state
          value: string
        - name: tenantId
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

DELETE example

Deletes the specified connector_mappings resource.

/*+ delete */
DELETE FROM azure_extras.customer_insights.connector_mappings
WHERE connectorName = '{{ connectorName }}'
AND hubName = '{{ hubName }}'
AND mappingName = '{{ mappingName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';