Answered

Using Get Record Action in Common Data Service

(0) Share

Report

Posted on by 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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-bacao-msft on at

Like (3)

Report
Re: Using Get Record Action in Common Data Service

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,

Was this reply helpful? Yes No
AnotherRedbeard 37 on at

Like (0)

Report

Re: Using Get Record Action in Common Data Service

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

Was this reply helpful? Yes No
moizmh 6 on at

Like (0)

Report

Re: Using Get Record Action in Common Data Service

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

Hope this helps (others).

Was this reply helpful? Yes No