sfdc_channels

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

Overview

Name	sfdc_channels
Type	Resource
Id	google.integrations.sfdc_channels

Fields

Name	Datatype	Description
name	string	Resource name of the SFDC channel projects/{project}/locations/{location}/sfdcInstances/{sfdc_instance}/sfdcChannels/{sfdc_channel}.
description	string	The description for this channel
channelTopic	string	The Channel topic defined by salesforce once an channel is opened
createTime	string	Output only. Time when the channel is created
deleteTime	string	Output only. Time when the channel was deleted. Empty if not deleted.
displayName	string	Client level unique name/alias to easily reference a channel.
isActive	boolean	Indicated if a channel has any active integrations referencing it. Set to false when the channel is created, and set to true if there is any integration published with the channel configured in it.
lastReplayId	string	Last sfdc messsage replay id for channel
updateTime	string	Output only. Time when the channel was last updated

Methods

Name	Accessible by	Required Params	Description
projects_locations_products_sfdc_instances_sfdc_channels_get	SELECT	locationsId, productsId, projectsId, sfdcChannelsId, sfdcInstancesId	Gets an sfdc channel. If the channel doesn't exist, Code.NOT_FOUND exception will be thrown.
projects_locations_products_sfdc_instances_sfdc_channels_list	SELECT	locationsId, productsId, projectsId, sfdcInstancesId	Lists all sfdc channels that match the filter. Restrict to sfdc channels belonging to the current client only.
projects_locations_sfdc_instances_sfdc_channels_get	SELECT	locationsId, projectsId, sfdcChannelsId, sfdcInstancesId	Gets an sfdc channel. If the channel doesn't exist, Code.NOT_FOUND exception will be thrown.
projects_locations_sfdc_instances_sfdc_channels_list	SELECT	locationsId, projectsId, sfdcInstancesId	Lists all sfdc channels that match the filter. Restrict to sfdc channels belonging to the current client only.
projects_locations_products_sfdc_instances_sfdc_channels_create	INSERT	locationsId, productsId, projectsId, sfdcInstancesId	Creates an sfdc channel record. Store the sfdc channel in Spanner. Returns the sfdc channel.
projects_locations_sfdc_instances_sfdc_channels_create	INSERT	locationsId, projectsId, sfdcInstancesId	Creates an sfdc channel record. Store the sfdc channel in Spanner. Returns the sfdc channel.
projects_locations_products_sfdc_instances_sfdc_channels_delete	DELETE	locationsId, productsId, projectsId, sfdcChannelsId, sfdcInstancesId	Deletes an sfdc channel.
projects_locations_sfdc_instances_sfdc_channels_delete	DELETE	locationsId, projectsId, sfdcChannelsId, sfdcInstancesId	Deletes an sfdc channel.
projects_locations_products_sfdc_instances_sfdc_channels_patch	UPDATE	locationsId, productsId, projectsId, sfdcChannelsId, sfdcInstancesId	Updates an sfdc channel. Updates the sfdc channel in spanner. Returns the sfdc channel.
projects_locations_sfdc_instances_sfdc_channels_patch	UPDATE	locationsId, projectsId, sfdcChannelsId, sfdcInstancesId	Updates an sfdc channel. Updates the sfdc channel in spanner. Returns the sfdc channel.

SELECT examples

Lists all sfdc channels that match the filter. Restrict to sfdc channels belonging to the current client only.

SELECT
name,
description,
channelTopic,
createTime,
deleteTime,
displayName,
isActive,
lastReplayId,
updateTime
FROM google.integrations.sfdc_channels
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND sfdcInstancesId = '{{ sfdcInstancesId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.integrations.sfdc_channels (
locationsId,
projectsId,
sfdcInstancesId,
description,
name,
isActive,
displayName,
lastReplayId,
channelTopic
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ sfdcInstancesId }}',
'{{ description }}',
'{{ name }}',
{{ isActive }},
'{{ displayName }}',
'{{ lastReplayId }}',
'{{ channelTopic }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: description
      value: string
    - name: name
      value: string
    - name: updateTime
      value: string
    - name: isActive
      value: boolean
    - name: displayName
      value: string
    - name: lastReplayId
      value: string
    - name: channelTopic
      value: string
    - name: deleteTime
      value: string
    - name: createTime
      value: string

UPDATE example

Updates a sfdc_channels resource.

/*+ update */
UPDATE google.integrations.sfdc_channels
SET 
description = '{{ description }}',
name = '{{ name }}',
isActive = true|false,
displayName = '{{ displayName }}',
lastReplayId = '{{ lastReplayId }}',
channelTopic = '{{ channelTopic }}'
WHERE 
locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND sfdcChannelsId = '{{ sfdcChannelsId }}'
AND sfdcInstancesId = '{{ sfdcInstancesId }}';

DELETE example

Deletes the specified sfdc_channels resource.

/*+ delete */
DELETE FROM google.integrations.sfdc_channels
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND sfdcChannelsId = '{{ sfdcChannelsId }}'
AND sfdcInstancesId = '{{ sfdcInstancesId }}';