Pass alternate key to lookup alternate key

(0) Share

Report

Posted on by Joshua Wright

410

We recently moved to CRM online, and trying to limit number of application interactions have been setting up a number of alternate keys.

On one of our entities the alternate key fields are lookups to another entity. Example below.

Entity 1
- Fields
  - Entity1id {pk}
  - Entity1altkey {string}
- AlternateKey
  - {Entity1altkey}
Entity 2
- Fields
  - Entity2id {pk}
  - Entity2altkey {string}
- AlternateKey
  - {Entity2altkey}
Entity 3
- Fields
  - Entity3id {pk}
  - Entity3_Entity1id
  - Entity3_Entity2id
- AlternateKey
  - {Entity3_Entity1id, Entity3_Entity2id}

I have been successful calling an update passing /entity3s(_entity3_entity1id_value=1231234-1234-1234-1234-123412341234,_entity3_entity2id_value=1231234-1234-1234-1234-123412341234), but what I want to do to prevent having to prescan Dynamics is /entity3s(_entity3_entity1id_value=/entity1s(entity1altkey='string1'), _entity3_entity2id_value=/entity2s(entity2altkey='string2'))

Has anyone been successful doing this? Is it possible?