cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cmvyas
Frequent Visitor

Update and delete table rows using the Web API throws - An error occurred while validating input parameters:

Request Type - Patch

https://{OrganizationURL}.crm.dynamics.com/api/data/v9.2/TableName(%entityID%)

Headers:

Accept: application/json

Content-Type: application/json; charset=utf-8

OData-MaxVersion: 4.0
OData-Version: 4.0
Prefer: return=representation
If-Match: *
Authorization: Bearer %Token%

 

Body:

 

{"%entityColumn%":"%entityValue%"}  

 

{"error":{"code":"0x0","message":"An error occurred while validating input parameters: System.ArgumentException: Stream was not readable.\r\n at System.IO.StreamReader..ctor(Stream stream, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean leaveOpen)\r\n at System.IO.StreamReader..ctor(Stream stream, Encoding encoding)\r\n at Microsoft.OData.JsonLight.ODataJsonLightInputContext.CreateTextReader(Stream messageStream, Encoding encoding)\r\n at Microsoft.OData.JsonLight.ODataJsonLightInputContext..ctor(ODataMessageInfo messageInfo, ODataMessageReaderSettings messageReaderSettings)\r\n at Microsoft.OData.Json.ODataJsonFormat.CreateInputContext(ODataMessageInfo messageInfo, ODataMessageReaderSettings messageReaderSettings)\r\n at Microsoft.OData.ODataMessageReader.ReadFromInput[T](Func`2 readFunc, ODataPayloadKind[] payloadKinds)\r\n at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.Read(ODataMessageReader messageReader, Type type, ODataDeserializerContext readContext)\r\n at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger)"}}

 

 

Can anyone please help? The same is working fine on postman but not working in power automate desktop using Invoke Web Service - https://docs.microsoft.com/en-us/power-apps/developer/data-platform/webapi/update-delete-entities-us...

 

Refer to the below snap for exact details

cmvyas_1-1653810581145.png

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,336)