Create Schema Relationship
-
Click on the
Step 2 - Relationship Descriptor Customer Account To PlanAPI request in theXDM Schema Lab -> Create Relationship Descriptorsfoldernote caution CAUTION Do not execute the request…yet
-
Update the following properties in the body of the API call.
- Set the value of the
xdm:sourceSchemaproperty to the$idof the Customer Account schema you saved from the Create Schema lab step - Set the value of the
xdm:sourcePropertyto the path of theplanIDfield from the Customer Account Schema. - Set the value of the
xdm:destinationSchemaproperty to the$idofdep: Lookup Planschema you saved in 1st step
NOTE
Use the dot notation value of the planId field from the Customer Account Schema and replace the
. with /Don’t forget the leading
/ either 😄EXAMPLE ONLY
{
"@type": "xdm:descriptorOneToOne",
"xdm:sourceSchema": "https://ns.adobe.com/devbc/schemas/8415ac18dd8943e35d12caf0c24b57b4a5a9ab7fd637245e",
"xdm:sourceVersion": 1,
"xdm:sourceProperty": "/_devbc/plan/planID",
"xdm:destinationSchema": "https://ns.adobe.com/devbc/schemas/6470f71181cf87aa39c2c2c43824eaa15f523652f7f88ff7"
,
"xdm:destinationVersion": 1
}
NOTE
Remember to update the tenant name above (_devbc) with the your own
-
Save your request before continuing using the
Savebutton -
Execute the API by clicking the
Sendbutton
You should now see a 201 Created response like below
NOTE
Remember the Real-Time Customer Profile (and all of Experience Platform) only supports what we call a one (1) hop join from either the XDM Individual Profile or XDM Experience Event schemas (i.e. you can only create one (1) level lookup relationships)
NOTE
Did you notice the relationship descriptor
@type is set to a value of OneToOne? Isn’t the relationship between the Customer Account and Plan table in the XDM ERD on Paper a 1:N? What is going on?The Real-Time Customer Profile is built to describe the traits and behaviors of an individual person. Therefore from a individual person lens a lookup table is only ever defined as a 1:1 relationship during segmentation.
Its okay if your brain hurts…
recommendation-more-help
blueprints-learn-help-blueprints