Answered

CDS Update Record returns status 400

(0) Share

Report

Posted on by DieterA

103

Trying to update and existing record in a custom entity returns status 400: No resources were found when selecting for update

The Record with the given ID exits in the db.

Categories:

Using connectors

I have the same question (0)

All responses (16)

Answers (1)

Strahlemann 16 on at

Like (0)

Report
Copy link

Link copied!

You can only use "CDS update record" when the key value, you are searching against, is actually defined as the Primary Key in the CDS Database settings.

Was this reply helpful? Yes No
mcorning 332 on at

Like (0)

Report
Copy link

Link copied!

I just found the same issue. screenshots follow.

Flow error
CDS record to update (note correct RecordId)

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

Tested this with Standard and custom entity.

The workorund using the PrimaryId field as the Record Id is working.

The answer took so long because i ran in another isssue with lookup fileds adn the overall slow web interface at the moment

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

The MyContact Entity was only for testing and is deleted.
At the moment i use the standard contact entity.
But i tested with diffrent entities and flows.

But as mentioned in my other post the workorund using the PrimaryId field as the Record Id seems to work.

Usimg the ReordID filed as Record Id results still in the erros.

I will setup an sync flow for one of our SQL Tables.
I will the post further feedback.

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

I don't no if i missed somethig yesterday or something has changed.

I creadted a new Flow using the PrimaryId field as the Record Id and it is working.

So we can use this as workaround.

Usimg the ReordID filed as Record Id results still in the erros.

Was this reply helpful? Yes No
Vijeta on at

Like (0)

Report
Copy link

Link copied!

Can you please share screenshots of your flow and also the MyContact entity fields? I am assuming you are trying to update MyContact entity record. Thanks

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

manually entering the value of an exiting reords returns also error 400

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

Using the primary ID results in the same error 400

Was this reply helpful? Yes No
Verified answer

Vijeta on at

Like (0)

Report
Copy link

Link copied!

Hello DA,

Sorry for the delay. As a workaround can you please try to provide the value of PrimaryId field as the Record Id field input for the update action?

Was this reply helpful? Yes No
evel on at

Like (0)

Report
Copy link

Link copied!

Hi @DA,

I wasn't able to reproduce your issue, and I've escalated your question to some folks who might be able to know more. Sorry about the long wait time. Hopefully we'll be able to work together to solve your issue.

Thanks,
-evel

Was this reply helpful? Yes No