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)

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi DA,

Please try to create a new flow with another new custom entity to test. If the issue disappear, take a screenshot of the detailed trigger and actions in this flow so that I would try to reproduce it.

Regards,
Mona Li

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

Tried with a new custom entity and the standard entity contact. Both do not work.
Screenshot from the custom entity:

Text output from the custom entity:
Eingaben
The database
default
The entity
MyContact
Record id
5637144576
Name
n1
Name2
b2
Ausgaben
Überschriften
{
"Pragma": "no-cache",
"x-dynint-corrid": "fcfd8b7a-d465-4f45-a1fb-6e625464edfb",
"x-dynint-userid": "09426fa9-dea9-42d8-a6cd-f62d2ce9f7fe",
"x-dynint-tenantid": "f761f78c-7d49-4d1b-b0ec-751b47c38741",
"x-dynint-namespaceid": "default",
"x-dynint-environmentid": "Default-f761f78c-7d49-4d1b-b0ec-751b47c38741",
"x-ms-client-request-id": "8802f7e2-6c87-40e4-a652-84326c7183b4",
"x-ms-correlation-request-id": "fcfd8b7a-d465-4f45-a1fb-6e625464edfb",
"x-dynint-service": "Connector",
"x-dynint-location": "West Europe",
"Strict-Transport-Security": "max-age=15724800; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"Cache-Control": "no-cache",
"Date": "Fri, 04 Nov 2016 08:19:42 GMT",
"Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"Content-Length": "116",
"Content-Type": "application/json; charset=utf-8",
"Expires": "-1"
}
Text
{
"status": 400,
"message": "No resources were found when selecting for update.",
"source": "rts-connector.powerapps.com"
}

Text output from the contact entity:
Eingaben
The database
default
The entity
Contact
Record id
5637144615
Full name
der tester
Party type
Organization
Source
Default
Is email contact allowed
true
Is phone contact allowed
false
Status
Active
Ausgaben
Überschriften
{
"Pragma": "no-cache",
"x-dynint-corrid": "b5b672cf-e810-4ac7-81c2-95b854526402",
"x-dynint-userid": "09426fa9-dea9-42d8-a6cd-f62d2ce9f7fe",
"x-dynint-tenantid": "f761f78c-7d49-4d1b-b0ec-751b47c38741",
"x-dynint-namespaceid": "default",
"x-dynint-environmentid": "Default-f761f78c-7d49-4d1b-b0ec-751b47c38741",
"x-ms-client-request-id": "78836be6-e678-4f1c-98b8-4b41ca8021fb",
"x-ms-correlation-request-id": "b5b672cf-e810-4ac7-81c2-95b854526402",
"x-dynint-service": "Connector",
"x-dynint-location": "West Europe",
"Strict-Transport-Security": "max-age=15724800; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"Cache-Control": "no-cache",
"Date": "Fri, 04 Nov 2016 08:27:50 GMT",
"Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"Content-Length": "116",
"Content-Type": "application/json; charset=utf-8",
"Expires": "-1"
}
Text
{
"status": 400,
"message": "No resources were found when selecting for update.",
"source": "rts-connector.powerapps.com"
}

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

Any Updates. Tried this in an second enviroment. Same problem. The CDS Update is not working!

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

Any Update? The CDS Update function is not working.
Tried with different environment -> same error.
Tried direct in Azure from a Logic App -> same error

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

After 4 Weeks no answer and still not working.

And further problems:
DeleteRecord function returns the same error
SelectRecord returns error 404

Does not work in differnt environments, doses not work in Azure Logic APP

Could ba a great solution but not usebale a the moment.

The internal projects planed on CDS cannot be logner on hold. So we have to find a other Solution.

Was this reply helpful? Yes No
DieterA 103 on at

Like (0)

Report
Copy link

Link copied!

We have opened a service call via Offie 365 2 weeks ago!

Same as here: No answer, no reaction

Was this reply helpful? Yes No
evel Microsoft Employee 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
Verified answer

Vijeta Microsoft Employee 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
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
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