Unanswered

Operation return invalid status code 'Bad Request' : Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha

(0) Share

Report

Posted on by Community Power Pla...

Our Requirement:
We have Azure Linux server resource group. So we need to create azure function in .net core 3.1.

So, we got the following package which provide supports in .net core azure function
Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha

Let me include few details about our implementation:

1. We have used Dynamics connection string - ClientSecret Authentication types

2. Following things working fine with the above connection string.

- Retrieve records from Entities - Working fine.

- Insert/Update operation in Entity which doesn't contain EntityReference type (Lookup) - Working fine.

3. When we perform Insert/update operation in Entity which contains EntityReference type (Lookup), it gives error
Operation return invalid status code 'Bad Request'

Let me attach some code which we implemented in console application:

var service = new CdsServiceClient(connectionString);
if (service.IsReady)
{
Entity account = GetAccountEntity(service);
Entity coupon = GetCouponEntity(service);

Entity couponPerCustomer = new Entity("couponpercustomer");
couponPerCustomer["couponid"] = coupon.ToEntityReference();
couponPerCustomer["customerid"] = account.ToEntityReference();
service.Create(couponPerCustomer);
}

When we run above code it gives error in "service.Create(couponPerCustomer)"
Error: Operation return invalid status code 'Bad Request'

All responses (5)

Answers (0)

Ben Thompson 1,400 on at

Like (0)

Report

Re: Operation return invalid status code 'Bad Request' : Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha

As I posted in your other thread - the .net core packages are alpha code and support is being done via the github repository at

https://github.com/microsoft/PowerPlatform-CdsServiceClient/issues

But I'm not sure I would be using alpha code to fulfil any requirement and I would be pushing back and saying the only option is to use the .net framework which is both supported (and no importantly for your requirement actually works)
Community Power Pla... on at

Like (0)

Report

Re: Operation return invalid status code 'Bad Request' : Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha

Hi @DianaBirkelbach
We have 1:N relationship.
Same code is working fine with package Microsoft.CrmSdk.XrmTooling.CoreAssembly inside .net Framework Project.
But above package has dependency of .net Framework.
As per new requirement, we have to use .net core project.
So, we are using .net core compatible package: Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha

We are getting error Operation return invalid status code 'Bad Request'
Diana Birkelbach 3,072 Most Valuable Professional on at

Like (0)

Report

Re: Operation return invalid status code 'Bad Request' : Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha

Hi @Anonymous ,
I wonder if "couponpercustomer" is a N:N relationship. That would mean that you would need an "associate" request, instead of create.
Maybe you get more details in the error call stack?

Kind regards,
Diana
Community Power Pla... on at

Like (0)

Report

Re: Operation return invalid status code 'Bad Request' : Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha

Hi ben-thompson,
Thanks for the quick reply.

We have already tried this solution
couponPerCustomer["couponid"] = new EntityReference(coupon.LogicalName,coupon.Id);
couponPerCustomer["customerid"] = new EntityReference(account.LogicalName,account.Id);

It is not working for us.
Ben Thompson 1,400 on at

Like (0)

Report

Re: Operation return invalid status code 'Bad Request' : Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha

You can't just convert an entity to an entity reference as an entity contains far more data.

An entityreference consists of 2 parts the logicalname of the entity you are referencing and the id of the entity. Thankfully getting the id from the entity is easy so you can use either of

couponPerCustomer["couponid"] = new EntityReference("coupon",coupon.Id);
couponPerCustomer["customerid"] = new EntityReference("account",account.Id);

or

couponPerCustomer["couponid"] = new EntityReference(coupon.LogicalName,coupon.Id);
couponPerCustomer["customerid"] = new EntityReference(account.LogicalName,account.Id);

both of which will give you valid entityreferences.