Skip to main content

sfdc_instances

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

Overview

Namesfdc_instances
TypeResource
Idgoogle.integrations.sfdc_instances

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
namestringResource name of the SFDC instance projects/{project}/locations/{location}/sfdcInstances/{sfdcInstance}.
authConfigIdarrayA list of AuthConfigs that can be tried to open the channel to SFDC
createTimestring (google-datetime)Output only. Time when the instance is created
deleteTimestring (google-datetime)Output only. Time when the instance was deleted. Empty if not deleted.
descriptionstringOptional. A description of the sfdc instance.
displayNamestringOptional. User selected unique name/alias to easily reference an instance.
serviceAuthoritystringOptional. URL used for API calls after authentication (the login authority is configured within the referenced AuthConfig).
sfdcOrgIdstringThe SFDC Org Id. This is defined in salesforce.
updateTimestring (google-datetime)Output only. Time when the instance was last updated

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
projects_locations_products_sfdc_instances_getselectprojectsId, locationsId, productsId, sfdcInstancesIdGets an sfdc instance. If the instance doesn't exist, Code.NOT_FOUND exception will be thrown.
projects_locations_products_sfdc_instances_listselectprojectsId, locationsId, productsIdpageSize, pageToken, filter, readMaskLists all sfdc instances that match the filter. Restrict to sfdc instances belonging to the current client only.
projects_locations_sfdc_instances_getselectprojectsId, locationsId, sfdcInstancesIdGets an sfdc instance. If the instance doesn't exist, Code.NOT_FOUND exception will be thrown.
projects_locations_sfdc_instances_listselectprojectsId, locationsIdpageSize, pageToken, filter, readMaskLists all sfdc instances that match the filter. Restrict to sfdc instances belonging to the current client only.
projects_locations_products_sfdc_instances_createinsertprojectsId, locationsId, productsIdCreates an sfdc instance record. Store the sfdc instance in Spanner. Returns the sfdc instance.
projects_locations_sfdc_instances_createinsertprojectsId, locationsIdCreates an sfdc instance record. Store the sfdc instance in Spanner. Returns the sfdc instance.
projects_locations_products_sfdc_instances_patchupdateprojectsId, locationsId, productsId, sfdcInstancesIdupdateMaskUpdates an sfdc instance. Updates the sfdc instance in spanner. Returns the sfdc instance.
projects_locations_sfdc_instances_patchupdateprojectsId, locationsId, sfdcInstancesIdupdateMaskUpdates an sfdc instance. Updates the sfdc instance in spanner. Returns the sfdc instance.
projects_locations_products_sfdc_instances_deletedeleteprojectsId, locationsId, productsId, sfdcInstancesIdDeletes an sfdc instance.
projects_locations_sfdc_instances_deletedeleteprojectsId, locationsId, sfdcInstancesIdDeletes an sfdc instance.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
locationsIdstring
productsIdstring
projectsIdstring
sfdcInstancesIdstring
filterstring
pageSizeinteger (int32)
pageTokenstring
readMaskstring (google-fieldmask)
updateMaskstring (google-fieldmask)

SELECT examples

Gets an sfdc instance. If the instance doesn't exist, Code.NOT_FOUND exception will be thrown.

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

INSERT examples

Creates an sfdc instance record. Store the sfdc instance in Spanner. Returns the sfdc instance.

INSERT INTO google.integrations.sfdc_instances (
data__name,
data__displayName,
data__description,
data__sfdcOrgId,
data__authConfigId,
data__serviceAuthority,
projectsId,
locationsId,
productsId
)
SELECT
'{{ name }}',
'{{ displayName }}',
'{{ description }}',
'{{ sfdcOrgId }}',
'{{ authConfigId }}',
'{{ serviceAuthority }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ productsId }}'
RETURNING
name,
authConfigId,
createTime,
deleteTime,
description,
displayName,
serviceAuthority,
sfdcOrgId,
updateTime
;

UPDATE examples

Updates an sfdc instance. Updates the sfdc instance in spanner. Returns the sfdc instance.

UPDATE google.integrations.sfdc_instances
SET
data__name = '{{ name }}',
data__displayName = '{{ displayName }}',
data__description = '{{ description }}',
data__sfdcOrgId = '{{ sfdcOrgId }}',
data__authConfigId = '{{ authConfigId }}',
data__serviceAuthority = '{{ serviceAuthority }}'
WHERE
projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND productsId = '{{ productsId }}' --required
AND sfdcInstancesId = '{{ sfdcInstancesId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
authConfigId,
createTime,
deleteTime,
description,
displayName,
serviceAuthority,
sfdcOrgId,
updateTime;

DELETE examples

Deletes an sfdc instance.

DELETE FROM google.integrations.sfdc_instances
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND productsId = '{{ productsId }}' --required
AND sfdcInstancesId = '{{ sfdcInstancesId }}' --required;