TIBCO Scribe Insight - Using CRM Alternate Keys with Upsert
Article ID: KB0078191
Updated On:
| Products | Versions |
|---|---|
| TIBCO Scribe Insight | - |
Description
CRM Alternate Key:
Is an optional, unique ID value you define in Dynamics CRM.
Any decimal, integer, or string field can be used to define either a simple alternate key, defined by a single field, or a complex alternate key, defined by multiple fields.
An alternate key has both a display name that appears in the interface, and a key name that Dynamics CRM uses to identify the field.
By default, the key name is the display name with a new_ prefix. For example, if you define the display name as MyKey, the key name assigned is new_MyKey.
For the Upsert operation, TIBCO Scribe has created a virtual field named vfAlternateKeyName.
This field needs to be populated in the DTS with the name of the CRM Alternate Key field.
See the attached document for more information
Any decimal, integer, or string field can be used to define either a simple alternate key, defined by a single field, or a complex alternate key, defined by multiple fields.
An alternate key has both a display name that appears in the interface, and a key name that Dynamics CRM uses to identify the field.
By default, the key name is the display name with a new_ prefix. For example, if you define the display name as MyKey, the key name assigned is new_MyKey.
For the Upsert operation, TIBCO Scribe has created a virtual field named vfAlternateKeyName.
This field needs to be populated in the DTS with the name of the CRM Alternate Key field.
See the attached document for more information
Environment
TIBCO Scribe Insight
Issue/Introduction
Upsert operations that update data in CRM can be performed based on linking a primary or alternate key.
This article discusses how to use Upsert using a CRM Alternate Key
Feedback
Yes
No
Powered by
