versions
Creates, updates, deletes, gets or lists a versions resource.
Overview
| Name | versions |
| Type | Resource |
| Id | google.integrations.versions |
Fields
| Name | Datatype | Description |
|---|---|---|
name | string | Output only. Auto-generated primary key. |
description | string | Optional. The integration description. |
cloudLoggingDetails | object | Cloud Logging details for execution info |
createTime | string | Output only. Auto-generated. |
createdFromTemplate | string | Optional. Optional. The resource name of the template from which the integration is created. |
databasePersistencePolicy | string | Optional. Flag to disable database persistence for execution data, including event execution info, execution export info, execution metadata index and execution param index. |
enableVariableMasking | boolean | Optional. True if variable masking feature should be turned on for this version |
errorCatcherConfigs | array | Optional. Error Catch Task configuration for the integration. It's optional. |
integrationConfigParameters | array | Optional. Config Parameters that are expected to be passed to the integration when an integration is published. This consists of all the parameters that are expected to provide configuration in the integration execution. This gives the user the ability to provide default values, value, add information like connection url, project based configuration value and also provide data types of each parameter. |
integrationParameters | array | Optional. Parameters that are expected to be passed to the integration when an event is triggered. This consists of all the parameters that are expected in the integration execution. This gives the user the ability to provide default values, add information like PII and also provide data types of each parameter. |
integrationParametersInternal | object | LINT.IfChange This is the frontend version of WorkflowParameters. It's exactly like the backend version except that instead of flattening protobuf parameters and treating every field and subfield of a protobuf parameter as a separate parameter, the fields/subfields of a protobuf parameter will be nested as "children" (see 'children' field below) parameters of the parent parameter. Please refer to enterprise/crm/eventbus/proto/workflow_parameters.proto for more information about WorkflowParameters. |
lastModifierEmail | string | Optional. The last modifier's email address. Generated based on the End User Credentials/LOAS role of the user making the call. |
lockHolder | string | Optional. The edit lock holder's email address. Generated based on the End User Credentials/LOAS role of the user making the call. |
origin | string | Optional. The origin that indicates where this integration is coming from. |
parentTemplateId | string | Optional. The id of the template which was used to create this integration_version. |
runAsServiceAccount | string | Optional. The run-as service account email, if set and auth config is not configured, that will be used to generate auth token to be used in Connector task, Rest caller task and Cloud function task. |
snapshotNumber | string | Optional. An increasing sequence that is set when a new snapshot is created. The last created snapshot can be identified by [workflow_name, org_id latest(snapshot_number)]. However, last created snapshot need not be same as the HEAD. So users should always use "HEAD" tag to identify the head. |
state | string | Output only. User should not set it as an input. |
status | string | Output only. Generated by eventbus. User should not set it as an input. |
taskConfigs | array | Optional. Task configuration for the integration. It's optional, but the integration doesn't do anything without task_configs. |
taskConfigsInternal | array | Optional. Task configuration for the integration. It's optional, but the integration doesn't do anything without task_configs. |
teardown | object | |
triggerConfigs | array | Optional. Trigger configurations. |
triggerConfigsInternal | array | Optional. Trigger configurations. |
updateTime | string | Output only. Auto-generated. |
userLabel | string | Optional. A user-defined label that annotates an integration version. Typically, this is only set when the integration version is created. |
Methods
| Name | Accessible by | Required Params | Description |
|---|---|---|---|
projects_locations_integrations_versions_get | SELECT | integrationsId, locationsId, projectsId, versionsId | Get a integration in the specified project. |
projects_locations_integrations_versions_list | SELECT | integrationsId, locationsId, projectsId | Returns the list of all integration versions in the specified project. |
projects_locations_products_integrations_versions_get | SELECT | integrationsId, locationsId, productsId, projectsId, versionsId | Get a integration in the specified project. |
projects_locations_products_integrations_versions_list | SELECT | integrationsId, locationsId, productsId, projectsId | Returns the list of all integration versions in the specified project. |
projects_locations_integrations_versions_create | INSERT | integrationsId, locationsId, projectsId | Create a integration with a draft version in the specified project. |
projects_locations_products_integrations_versions_create | INSERT | integrationsId, locationsId, productsId, projectsId | Create a integration with a draft version in the specified project. |
projects_locations_integrations_versions_delete | DELETE | integrationsId, locationsId, projectsId, versionsId | Soft-deletes the integration. Changes the status of the integration to ARCHIVED. If the integration being ARCHIVED is tagged as "HEAD", the tag is removed from this snapshot and set to the previous non-ARCHIVED snapshot. The PUBLISH_REQUESTED, DUE_FOR_DELETION tags are removed too. This RPC throws an exception if the version being deleted is DRAFT, and if the locked_by user is not the same as the user performing the Delete. Audit fields updated include last_modified_timestamp, last_modified_by. Any existing lock is released when Deleting a integration. Currently, there is no undelete mechanism. |
projects_locations_products_integrations_versions_delete | DELETE | integrationsId, locationsId, productsId, projectsId, versionsId | Soft-deletes the integration. Changes the status of the integration to ARCHIVED. If the integration being ARCHIVED is tagged as "HEAD", the tag is removed from this snapshot and set to the previous non-ARCHIVED snapshot. The PUBLISH_REQUESTED, DUE_FOR_DELETION tags are removed too. This RPC throws an exception if the version being deleted is DRAFT, and if the locked_by user is not the same as the user performing the Delete. Audit fields updated include last_modified_timestamp, last_modified_by. Any existing lock is released when Deleting a integration. Currently, there is no undelete mechanism. |
projects_locations_integrations_versions_patch | UPDATE | integrationsId, locationsId, projectsId, versionsId | Update a integration with a draft version in the specified project. |
projects_locations_products_integrations_versions_patch | UPDATE | integrationsId, locationsId, productsId, projectsId, versionsId | Update a integration with a draft version in the specified project. |
projects_locations_integrations_versions_download | EXEC | integrationsId, locationsId, projectsId, versionsId | Downloads an integration. Retrieves the IntegrationVersion for a given integration_id and returns the response as a string. |
projects_locations_integrations_versions_download_json_package | EXEC | integrationsId, locationsId, projectsId, versionsId | Downloads an Integration version package like IntegrationVersion,Integration Config etc. Retrieves the IntegrationVersion package for a given integration_id and returns the response as a JSON. |
projects_locations_integrations_versions_publish | EXEC | integrationsId, locationsId, projectsId, versionsId | This RPC throws an exception if the integration is in ARCHIVED or ACTIVE state. This RPC throws an exception if the version being published is DRAFT, and if the locked_by user is not the same as the user performing the Publish. Audit fields updated include last_published_timestamp, last_published_by, last_modified_timestamp, last_modified_by. Any existing lock is on this integration is released. |
projects_locations_integrations_versions_unpublish | EXEC | integrationsId, locationsId, projectsId, versionsId | Sets the status of the ACTIVE integration to SNAPSHOT with a new tag "PREVIOUSLY_PUBLISHED" after validating it. The "HEAD" and "PUBLISH_REQUESTED" tags do not change. This RPC throws an exception if the version being snapshot is not ACTIVE. Audit fields added include action, action_by, action_timestamp. |
projects_locations_integrations_versions_upload | EXEC | integrationsId, locationsId, projectsId | Uploads an integration. The content can be a previously downloaded integration. Performs the same function as CreateDraftIntegrationVersion, but accepts input in a string format, which holds the complete representation of the IntegrationVersion content. |
projects_locations_products_integrations_versions_download | EXEC | integrationsId, locationsId, productsId, projectsId, versionsId | Downloads an integration. Retrieves the IntegrationVersion for a given integration_id and returns the response as a string. |
projects_locations_products_integrations_versions_publish | EXEC | integrationsId, locationsId, productsId, projectsId, versionsId | This RPC throws an exception if the integration is in ARCHIVED or ACTIVE state. This RPC throws an exception if the version being published is DRAFT, and if the locked_by user is not the same as the user performing the Publish. Audit fields updated include last_published_timestamp, last_published_by, last_modified_timestamp, last_modified_by. Any existing lock is on this integration is released. |
projects_locations_products_integrations_versions_takeover_edit_lock | EXEC | integrationsId, locationsId, productsId, projectsId, versionsId | Clears the locked_by and locked_at_timestampin the DRAFT version of this integration. It then performs the same action as the CreateDraftIntegrationVersion (i.e., copies the DRAFT version of the integration as a SNAPSHOT and then creates a new DRAFT version with the locked_by set to the user_taking_over and the locked_at_timestamp set to the current timestamp). Both the locked_by and user_taking_over are notified via email about the takeover. This RPC throws an exception if the integration is not in DRAFT status or if the locked_by and locked_at_timestamp fields are not set.The TakeoverEdit lock is treated the same as an edit of the integration, and hence shares ACLs with edit. Audit fields updated include last_modified_timestamp, last_modified_by. |
projects_locations_products_integrations_versions_unpublish | EXEC | integrationsId, locationsId, productsId, projectsId, versionsId | Sets the status of the ACTIVE integration to SNAPSHOT with a new tag "PREVIOUSLY_PUBLISHED" after validating it. The "HEAD" and "PUBLISH_REQUESTED" tags do not change. This RPC throws an exception if the version being snapshot is not ACTIVE. Audit fields added include action, action_by, action_timestamp. |
projects_locations_products_integrations_versions_upload | EXEC | integrationsId, locationsId, productsId, projectsId | Uploads an integration. The content can be a previously downloaded integration. Performs the same function as CreateDraftIntegrationVersion, but accepts input in a string format, which holds the complete representation of the IntegrationVersion content. |
SELECT examples
Returns the list of all integration versions in the specified project.
SELECT
name,
description,
cloudLoggingDetails,
createTime,
createdFromTemplate,
databasePersistencePolicy,
enableVariableMasking,
errorCatcherConfigs,
integrationConfigParameters,
integrationParameters,
integrationParametersInternal,
lastModifierEmail,
lockHolder,
origin,
parentTemplateId,
runAsServiceAccount,
snapshotNumber,
state,
status,
taskConfigs,
taskConfigsInternal,
teardown,
triggerConfigs,
triggerConfigsInternal,
updateTime,
userLabel
FROM google.integrations.versions
WHERE integrationsId = '{{ integrationsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';
INSERT example
Use the following StackQL query and manifest file to create a new versions resource.
- All Properties
- Manifest
/*+ create */
INSERT INTO google.integrations.versions (
integrationsId,
locationsId,
projectsId,
origin,
userLabel,
triggerConfigs,
taskConfigs,
triggerConfigsInternal,
createdFromTemplate,
description,
teardown,
enableVariableMasking,
snapshotNumber,
parentTemplateId,
lastModifierEmail,
cloudLoggingDetails,
runAsServiceAccount,
integrationConfigParameters,
errorCatcherConfigs,
databasePersistencePolicy,
lockHolder,
taskConfigsInternal,
integrationParametersInternal,
integrationParameters
)
SELECT
'{{ integrationsId }}',
'{{ locationsId }}',
'{{ projectsId }}',
'{{ origin }}',
'{{ userLabel }}',
'{{ triggerConfigs }}',
'{{ taskConfigs }}',
'{{ triggerConfigsInternal }}',
'{{ createdFromTemplate }}',
'{{ description }}',
'{{ teardown }}',
{{ enableVariableMasking }},
'{{ snapshotNumber }}',
'{{ parentTemplateId }}',
'{{ lastModifierEmail }}',
'{{ cloudLoggingDetails }}',
'{{ runAsServiceAccount }}',
'{{ integrationConfigParameters }}',
'{{ errorCatcherConfigs }}',
'{{ databasePersistencePolicy }}',
'{{ lockHolder }}',
'{{ taskConfigsInternal }}',
'{{ integrationParametersInternal }}',
'{{ integrationParameters }}'
;
- name: your_resource_model_name
props:
- name: origin
value: string
- name: userLabel
value: string
- name: triggerConfigs
value:
- - name: startTasks
value:
- - name: displayName
value: string
- name: taskId
value: string
- name: taskConfigId
value: string
- name: description
value: string
- name: condition
value: string
- name: alertConfig
value:
- - name: alertThreshold
value: integer
- name: thresholdType
value: string
- name: durationThreshold
value: string
- name: thresholdValue
value:
- name: absolute
value: string
- name: percentage
value: integer
- name: metricType
value: string
- name: aggregationPeriod
value: string
- name: disableAlert
value: boolean
- name: displayName
value: string
- name: onlyFinalAttempt
value: boolean
- name: properties
value: object
- name: triggerId
value: string
- name: nextTasksExecutionPolicy
value: string
- name: label
value: string
- name: position
value:
- name: x
value: integer
- name: 'y'
value: integer
- name: cloudSchedulerConfig
value:
- name: cronTab
value: string
- name: location
value: string
- name: serviceAccountEmail
value: string
- name: errorMessage
value: string
- name: description
value: string
- name: trigger
value: string
- name: triggerNumber
value: string
- name: errorCatcherId
value: string
- name: triggerType
value: string
- name: taskConfigs
value:
- - name: taskTemplate
value: string
- name: failurePolicy
value:
- name: condition
value: string
- name: intervalTime
value: string
- name: maxRetries
value: integer
- name: retryStrategy
value: string
- name: taskId
value: string
- name: nextTasksExecutionPolicy
value: string
- name: description
value: string
- name: conditionalFailurePolicies
value:
- name: failurePolicies
value:
- - name: condition
value: string
- name: intervalTime
value: string
- name: maxRetries
value: integer
- name: retryStrategy
value: string
- name: successPolicy
value:
- name: finalState
value: string
- name: parameters
value: object
- name: taskExecutionStrategy
value: string
- name: errorCatcherId
value: string
- name: nextTasks
value:
- - name: displayName
value: string
- name: taskId
value: string
- name: taskConfigId
value: string
- name: description
value: string
- name: condition
value: string
- name: externalTaskType
value: string
- name: displayName
value: string
- name: jsonValidationOption
value: string
- name: task
value: string
- name: triggerConfigsInternal
value:
- - name: nextTasksExecutionPolicy
value: string
- name: position
value:
- name: 'y'
value: integer
- name: x
value: integer
- name: triggerName
value: string
- name: startTasks
value:
- - name: combinedConditions
value:
- - name: conditions
value:
- - name: value
value:
- name: stringValue
value: string
- name: intValue
value: string
- name: stringArray
value:
- name: values
value:
- string
- name: intArray
value:
- name: values
value:
- string
- name: doubleValue
value: number
- name: booleanValue
value: boolean
- name: doubleArray
value:
- name: values
value:
- number
- name: protoValue
value: object
- name: eventPropertyKey
value: string
- name: operator
value: string
- name: condition
value: string
- name: taskNumber
value: string
- name: taskConfigId
value: string
- name: label
value: string
- name: description
value: string
- name: triggerNumber
value: string
- name: triggerCriteria
value:
- name: triggerCriteriaTaskImplementationClassName
value: string
- name: parameters
value:
- name: parameters
value:
- - name: value
value:
- name: protoArray
value:
- name: protoValues
value:
- object
- name: doubleArray
value:
- name: doubleValues
value:
- number
- name: stringValue
value: string
- name: intValue
value: string
- name: doubleValue
value: number
- name: booleanValue
value: boolean
- name: serializedObjectValue
value:
- name: objectValue
value: string
- name: intArray
value:
- name: intValues
value:
- string
- name: booleanArray
value:
- name: booleanValues
value:
- boolean
- name: stringArray
value:
- name: stringValues
value:
- string
- name: protoValue
value: object
- name: key
value: string
- name: masked
value: boolean
- name: condition
value: string
- name: description
value: string
- name: properties
value: object
- name: pauseWorkflowExecutions
value: boolean
- name: triggerType
value: string
- name: alertConfig
value:
- - name: alertName
value: string
- name: durationThresholdMs
value: string
- name: playbookUrl
value: string
- name: warningEnumList
value:
- name: filterType
value: string
- name: enumStrings
value:
- string
- name: onlyFinalAttempt
value: boolean
- name: aggregationPeriod
value: string
- name: metricType
value: string
- name: numAggregationPeriods
value: integer
- name: thresholdType
value: string
- name: clientId
value: string
- name: thresholdValue
value:
- name: percentage
value: integer
- name: absolute
value: string
- name: alertDisabled
value: boolean
- name: triggerId
value: string
- name: enabledClients
value:
- string
- name: errorCatcherId
value: string
- name: cloudSchedulerConfig
value:
- name: errorMessage
value: string
- name: cronTab
value: string
- name: location
value: string
- name: serviceAccountEmail
value: string
- name: label
value: string
- name: createTime
value: string
- name: createdFromTemplate
value: string
- name: description
value: string
- name: teardown
value:
- name: teardownTaskConfigs
value:
- - name: teardownTaskImplementationClassName
value: string
- name: name
value: string
- name: properties
value:
- name: properties
value:
- - name: key
value: string
- name: creatorEmail
value: string
- name: nextTeardownTask
value:
- name: name
value: string
- name: enableVariableMasking
value: boolean
- name: snapshotNumber
value: string
- name: parentTemplateId
value: string
- name: lastModifierEmail
value: string
- name: state
value: string
- name: cloudLoggingDetails
value:
- name: enableCloudLogging
value: boolean
- name: cloudLoggingSeverity
value: string
- name: updateTime
value: string
- name: runAsServiceAccount
value: string
- name: integrationConfigParameters
value:
- - name: value
value:
- name: intArray
value:
- name: intValues
value:
- string
- name: doubleArray
value:
- name: doubleValues
value:
- number
- name: intValue
value: string
- name: stringArray
value:
- name: stringValues
value:
- string
- name: doubleValue
value: number
- name: stringValue
value: string
- name: jsonValue
value: string
- name: booleanArray
value:
- name: booleanValues
value:
- boolean
- name: booleanValue
value: boolean
- name: parameter
value:
- name: description
value: string
- name: inputOutputType
value: string
- name: isTransient
value: boolean
- name: producer
value: string
- name: dataType
value: string
- name: jsonSchema
value: string
- name: searchable
value: boolean
- name: containsLargeData
value: boolean
- name: masked
value: boolean
- name: key
value: string
- name: displayName
value: string
- name: errorCatcherConfigs
value:
- - name: description
value: string
- name: startErrorTasks
value:
- - name: displayName
value: string
- name: taskId
value: string
- name: taskConfigId
value: string
- name: description
value: string
- name: condition
value: string
- name: label
value: string
- name: errorCatcherNumber
value: string
- name: errorCatcherId
value: string
- name: status
value: string
- name: name
value: string
- name: databasePersistencePolicy
value: string
- name: lockHolder
value: string
- name: taskConfigsInternal
value:
- - name: taskNumber
value: string
- name: lastModifiedTime
value: string
- name: taskType
value: string
- name: nextTasks
value:
- - name: combinedConditions
value:
- - name: conditions
value:
- - name: eventPropertyKey
value: string
- name: operator
value: string
- name: condition
value: string
- name: taskNumber
value: string
- name: taskConfigId
value: string
- name: label
value: string
- name: description
value: string
- name: disableStrictTypeValidation
value: boolean
- name: taskExecutionStrategy
value: string
- name: errorCatcherId
value: string
- name: failurePolicy
value:
- name: retryStrategy
value: string
- name: retryCondition
value: string
- name: maxNumRetries
value: integer
- name: intervalInSeconds
value: string
- name: taskEntity
value:
- name: taskType
value: string
- name: stats
value:
- name: dimensions
value:
- name: triggerId
value: string
- name: taskName
value: string
- name: warningEnumString
value: string
- name: clientId
value: string
- name: errorEnumString
value: string
- name: retryAttempt
value: string
- name: workflowName
value: string
- name: enumFilterType
value: string
- name: taskNumber
value: string
- name: workflowId
value: string
- name: warningRate
value: number
- name: qps
value: number
- name: durationInSeconds
value: number
- name: errorRate
value: number
- name: paramSpecs
value:
- name: parameters
value:
- - name: config
value:
- name: helpText
value: string
- name: isHidden
value: boolean
- name: label
value: string
- name: uiPlaceholderText
value: string
- name: subSectionLabel
value: string
- name: parameterNameOption
value: string
- name: inputDisplayOption
value: string
- name: descriptivePhrase
value: string
- name: hideDefaultValue
value: boolean
- name: validationRule
value:
- name: doubleRange
value:
- name: max
value: number
- name: min
value: number
- name: intRange
value:
- name: min
value: string
- name: max
value: string
- name: stringRegex
value:
- name: regex
value: string
- name: exclusive
value: boolean
- name: protoDef
value:
- name: fullName
value: string
- name: path
value: string
- name: isOutput
value: boolean
- name: jsonSchema
value: string
- name: key
value: string
- name: dataType
value: string
- name: collectionElementClassName
value: string
- name: required
value: boolean
- name: className
value: string
- name: isDeprecated
value: boolean
- name: defaultValue
value:
- name: stringValue
value: string
- name: doubleValue
value: number
- name: protoValue
value: object
- name: stringArray
value:
- name: stringValues
value:
- string
- name: booleanValue
value: boolean
- name: intArray
value:
- name: intValues
value:
- string
- name: jsonValue
value: string
- name: serializedObjectValue
value:
- name: objectValue
value: string
- name: doubleArray
value:
- name: doubleValues
value:
- number
- name: booleanArray
value:
- name: booleanValues
value:
- boolean
- name: protoArray
value:
- name: protoValues
value:
- object
- name: intValue
value: string
- name: uiConfig
value:
- name: taskUiModuleConfigs
value:
- - name: moduleId
value: string
- name: metadata
value:
- name: activeTaskName
value: string
- name: externalDocHtml
value: string
- name: isDeprecated
value: boolean
- name: externalDocMarkdown
value: string
- name: tags
value:
- string
- name: externalDocLink
value: string
- name: admins
value:
- - name: googleGroupEmail
value: string
- name: userEmail
value: string
- name: externalCategorySequence
value: integer
- name: iconLink
value: string
- name: docMarkdown
value: string
- name: descriptiveName
value: string
- name: system
value: string
- name: standaloneExternalDocHtml
value: string
- name: defaultSpec
value: string
- name: name
value: string
- name: g3DocLink
value: string
- name: category
value: string
- name: externalCategory
value: string
- name: codeSearchLink
value: string
- name: defaultJsonValidationOption
value: string
- name: status
value: string
- name: description
value: string
- name: disabledForVpcSc
value: boolean
- name: jsonValidationOption
value: string
- name: taskName
value: string
- name: externalTaskType
value: string
- name: alertConfigs
value:
- - name: numAggregationPeriods
value: integer
- name: alertName
value: string
- name: thresholdType
value: string
- name: alertDisabled
value: boolean
- name: playbookUrl
value: string
- name: aggregationPeriod
value: string
- name: clientId
value: string
- name: onlyFinalAttempt
value: boolean
- name: metricType
value: string
- name: durationThresholdMs
value: string
- name: preconditionLabel
value: string
- name: label
value: string
- name: parameters
value: object
- name: precondition
value: string
- name: createTime
value: string
- name: creatorEmail
value: string
- name: conditionalFailurePolicies
value:
- name: failurePolicies
value:
- - name: retryStrategy
value: string
- name: retryCondition
value: string
- name: maxNumRetries
value: integer
- name: intervalInSeconds
value: string
- name: description
value: string
- name: incomingEdgeCount
value: integer
- name: successPolicy
value:
- name: finalState
value: string
- name: nextTasksExecutionPolicy
value: string
- name: rollbackStrategy
value:
- name: rollbackTaskImplementationClassName
value: string
- name: parameters
value:
- name: parameters
value:
- - name: key
value: string
- name: dataType
value: string
- name: masked
value: boolean
- name: taskNumbersToRollback
value:
- string
- name: taskTemplateName
value: string
- name: taskSpec
value: string
- name: integrationParametersInternal
value:
- name: parameters
value:
- - name: producer
value: string
- name: producedBy
value:
- name: elementIdentifier
value: string
- name: elementType
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: attributes
value:
- name: readOnly
value: boolean
- name: dataType
value: string
- name: searchable
value: string
- name: isRequired
value: boolean
- name: masked
value: boolean
- name: isSearchable
value: boolean
- name: logSettings
value:
- name: seedPeriod
value: string
- name: seedScope
value: string
- name: logFieldName
value: string
- name: taskVisibility
value:
- string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- - name: producer
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- - name: producer
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- - name: producer
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- - name: producer
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- - name: producer
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- - name: producer
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- - name: producer
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- - name: producer
value: string
- name: containsLargeData
value: boolean
- name: inOutType
value: string
- name: required
value: boolean
- name: key
value: string
- name: dataType
value: string
- name: protoDefName
value: string
- name: jsonSchema
value: string
- name: protoDefPath
value: string
- name: name
value: string
- name: description
value: string
- name: children
value:
- []
- name: isTransient
value: boolean
- name: isTransient
value: boolean
- name: isTransient
value: boolean
- name: isTransient
value: boolean
- name: isTransient
value: boolean
- name: isTransient
value: boolean
- name: isTransient
value: boolean
- name: isTransient
value: boolean
- name: isTransient
value: boolean
- name: integrationParameters
value:
- - name: description
value: string
- name: inputOutputType
value: string
- name: isTransient
value: boolean
- name: producer
value: string
- name: dataType
value: string
- name: jsonSchema
value: string
- name: searchable
value: boolean
- name: containsLargeData
value: boolean
- name: masked
value: boolean
- name: key
value: string
- name: displayName
value: string
UPDATE example
Updates a versions resource.
/*+ update */
UPDATE google.integrations.versions
SET
origin = '{{ origin }}',
userLabel = '{{ userLabel }}',
triggerConfigs = '{{ triggerConfigs }}',
taskConfigs = '{{ taskConfigs }}',
triggerConfigsInternal = '{{ triggerConfigsInternal }}',
createdFromTemplate = '{{ createdFromTemplate }}',
description = '{{ description }}',
teardown = '{{ teardown }}',
enableVariableMasking = true|false,
snapshotNumber = '{{ snapshotNumber }}',
parentTemplateId = '{{ parentTemplateId }}',
lastModifierEmail = '{{ lastModifierEmail }}',
cloudLoggingDetails = '{{ cloudLoggingDetails }}',
runAsServiceAccount = '{{ runAsServiceAccount }}',
integrationConfigParameters = '{{ integrationConfigParameters }}',
errorCatcherConfigs = '{{ errorCatcherConfigs }}',
databasePersistencePolicy = '{{ databasePersistencePolicy }}',
lockHolder = '{{ lockHolder }}',
taskConfigsInternal = '{{ taskConfigsInternal }}',
integrationParametersInternal = '{{ integrationParametersInternal }}',
integrationParameters = '{{ integrationParameters }}'
WHERE
integrationsId = '{{ integrationsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND versionsId = '{{ versionsId }}';
DELETE example
Deletes the specified versions resource.
/*+ delete */
DELETE FROM google.integrations.versions
WHERE integrationsId = '{{ integrationsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND versionsId = '{{ versionsId }}';