Dynamics CRM Web API POST Products 'Internal Server Error'

(0) Share

Report

Posted on by Community Member

Hi,

I've working on a C#.net desktop application to create a products in CRM but when I post my request my response message IsSuccessStatusCode returns false and ReasonPhrase value is "Internal Server Error".

requestUri = https://xxxxxx.xxxxxx.com/api/data/v8.2/products

Content = { "description": "Desc12345", "productnumber": "12345", "name": "Name12345" }

This is for an on-prem. version of CRM and my code to patch/update existing product values all works fine, so I have to assume the Uri isn't the issue.

I've tried including other fields in my content on the assumption that there could be a mandatory value I need to populate but even when I set values to match other products the error still appears.

Can anyone give me suggestions on how I can dig deeper to find details of the error?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Jim ,

Could you please share your code. Meanwhile you can also validate your code with below reference. The internal server error is basically coming when request is not hitting to the server which you want.

www.inogic.com/.../programming-using-webapi-through-c-in-dynamics-crm-2016

You can download fiddler to see where it's actually fails.

Hope this helps.

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello Jim,

You will need to pass defaultuomid, defauluomscheduleid and quantitydecimal fields as well because all of those fields are "platform required".

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Here's my code:

string thisRequest = _BaseAddress + _APIDataVersion + "products";

using (System.Net.Http.HttpRequestMessage thisHttpRequestMessage = new System.Net.Http.HttpRequestMessage(System.Net.Http.HttpMethod.Post, thisRequest))

{

JObject newProduct = new JObject();

newProduct.Add("description",ProductDescription);

newProduct.Add("productnumber",ProductNumber);

newProduct.Add("name",ProductName);

thisHttpRequestMessage.Content = new System.Net.Http.StringContent(newProduct.ToString());

thisHttpRequestMessage.Content.Headers.ContentType = System.Net.Http.Headers.MediaTypeHeaderValue.Parse("application/json");

System.Net.Http.HttpResponseMessage thisResponse = httpClient.SendAsync(thisHttpRequestMessage).Result;

if (thisResponse.IsSuccessStatusCode == false)

{

throw new Exception("Error " + thisResponse.ReasonPhrase);

}

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried adding those fields (as below) after seeing your response to a similar query but it didn't stop the error occurring.

newProduct.Add("defaultuomscheduleid@odata.bind", "/uomschedules(4560d506-eee2-4cf8-a8d2-3e189ffd5572)");

newProduct.Add("defaultuomid@odata.bind", "/uoms(bfd3f507-1532-48c1-a35b-d0da82d4f477)");

newProduct.Add("quantitydecimal", 1);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Goutam/Andrew,

Thanks for your advise but believe it or not it's now started working. I've been trying to fix the problem for hours and now it looks like it's posting, typical!.

Cheers

Jim

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

For me it was enough. Can you please doublecheck that you don't have product with the same productnumber in the system?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I've just re-checked and I don't (and didn't) have any duplicates, in-fact the CRM database had only a few products in there.

Was this reply helpful? Yes No