sfdc_instances

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

Overview

Name	sfdc_instances
Type	Resource
Id	google.integrations.sfdc_instances

Fields

Name	Datatype	Description
name	string	Resource name of the SFDC instance projects/{project}/locations/{location}/sfdcInstances/{sfdcInstance}.
description	string	A description of the sfdc instance.
authConfigId	array	A list of AuthConfigs that can be tried to open the channel to SFDC
createTime	string	Output only. Time when the instance is created
deleteTime	string	Output only. Time when the instance was deleted. Empty if not deleted.
displayName	string	User selected unique name/alias to easily reference an instance.
serviceAuthority	string	URL used for API calls after authentication (the login authority is configured within the referenced AuthConfig).
sfdcOrgId	string	The SFDC Org Id. This is defined in salesforce.
updateTime	string	Output only. Time when the instance was last updated

Methods

Name	Accessible by	Required Params	Description
projects_locations_products_sfdc_instances_get	SELECT	locationsId, productsId, projectsId, sfdcInstancesId	Gets an sfdc instance. If the instance doesn't exist, Code.NOT_FOUND exception will be thrown.
projects_locations_products_sfdc_instances_list	SELECT	locationsId, productsId, projectsId	Lists all sfdc instances that match the filter. Restrict to sfdc instances belonging to the current client only.
projects_locations_sfdc_instances_get	SELECT	locationsId, projectsId, sfdcInstancesId	Gets an sfdc instance. If the instance doesn't exist, Code.NOT_FOUND exception will be thrown.
projects_locations_sfdc_instances_list	SELECT	locationsId, projectsId	Lists all sfdc instances that match the filter. Restrict to sfdc instances belonging to the current client only.
projects_locations_products_sfdc_instances_create	INSERT	locationsId, productsId, projectsId	Creates an sfdc instance record. Store the sfdc instance in Spanner. Returns the sfdc instance.
projects_locations_sfdc_instances_create	INSERT	locationsId, projectsId	Creates an sfdc instance record. Store the sfdc instance in Spanner. Returns the sfdc instance.
projects_locations_products_sfdc_instances_delete	DELETE	locationsId, productsId, projectsId, sfdcInstancesId	Deletes an sfdc instance.
projects_locations_sfdc_instances_delete	DELETE	locationsId, projectsId, sfdcInstancesId	Deletes an sfdc instance.
projects_locations_products_sfdc_instances_patch	UPDATE	locationsId, productsId, projectsId, sfdcInstancesId	Updates an sfdc instance. Updates the sfdc instance in spanner. Returns the sfdc instance.
projects_locations_sfdc_instances_patch	UPDATE	locationsId, projectsId, sfdcInstancesId	Updates an sfdc instance. Updates the sfdc instance in spanner. Returns the sfdc instance.

SELECT examples

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

SELECT
name,
description,
authConfigId,
createTime,
deleteTime,
displayName,
serviceAuthority,
sfdcOrgId,
updateTime
FROM google.integrations.sfdc_instances
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.integrations.sfdc_instances (
locationsId,
projectsId,
sfdcOrgId,
serviceAuthority,
authConfigId,
displayName,
name,
description
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ sfdcOrgId }}',
'{{ serviceAuthority }}',
'{{ authConfigId }}',
'{{ displayName }}',
'{{ name }}',
'{{ description }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: sfdcOrgId
      value: string
    - name: serviceAuthority
      value: string
    - name: authConfigId
      value:
        - string
    - name: deleteTime
      value: string
    - name: updateTime
      value: string
    - name: displayName
      value: string
    - name: createTime
      value: string
    - name: name
      value: string
    - name: description
      value: string

UPDATE example

Updates a sfdc_instances resource.

/*+ update */
UPDATE google.integrations.sfdc_instances
SET 
sfdcOrgId = '{{ sfdcOrgId }}',
serviceAuthority = '{{ serviceAuthority }}',
authConfigId = '{{ authConfigId }}',
displayName = '{{ displayName }}',
name = '{{ name }}',
description = '{{ description }}'
WHERE 
locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND sfdcInstancesId = '{{ sfdcInstancesId }}';

DELETE example

Deletes the specified sfdc_instances resource.

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