Using Get Record Action in Common Data Service

[AnotherRedbeard]

Hi all,

I'm trying to use the 'Get Record' Action from the Common Data Service (CDS) Connector to lookup a record in CDS and then either do an Update or Insert, but I'm having trouble figuring out what to put in the 'Item identifier' section.

My flow is a Json object that has the ID in it and I'm parsing that Json and attempting to use the ID to look up the record in CDS.  It is a custom entity and I have made the ID the key.

Here is the error I get from Get Record:

"status": 400,

"message": "Invalid value: 1128138 provided for item ID"

In the very next step, just to make sure it's there, I have a 'Create Record' action and it returns this error:

"status": 412,

"message": "A record that has the attribute values ID already exists. The entity key ID requires that this set of attributes contains unique values. Select unique values and try again."

So I know the record exists, but I can't seem to figure out exactly what to put in that Item Identifier field.  Please help  !

[v-bacao-msft · Accepted solution]

Hi @AnotherRedbeard ,

Item identifier is similar to GUID, generated automatically, not ID like 1128138 you configured, as below:

If you use the obtained ID value to configure Item identifier field, you cannot get the record.

• Since you need to find the record by ID, you could configure List records-Filter Query to get the record. ID field has a unique value in Entity, so only one record will be obtained.

For example, I created ID field in my entity with a unique value of type Whole Number and set it to Key.

• Get its Name as shown below, then configure Filter Query.

• Note that if ID field is of type string, you need to enclose it in single quotes.

Finally, determine whether there is a record corresponding to ID value in the Entity.

• Enter "id" in input box when configuring Record identifier, and then select Dynamic content corresponding to Unique identifier for entity instances generated by the system.

Please take a try.

Best Regards,

[AnotherRedbeard]

Thanks @v-bacao-msft , that is what I ended up doing and thank you for explaing the record identifier...that makes more sense now.

[moizmh]

I was trying the same thing but got the flow working with just specifying the ItemInternalId in "Record Identifier"

Hope this helps (others).