Getting Error while Performing Delete Action on D365 F&O Via Odata Call

(0) Share

Report

Posted on by GP Development comm...

135

Hi All,

I am working on ODATA CRUD concept in F & O data entities. I stuck in ODATA delete call, while deleting the values in data entities, Below is the code i used to delete the data entity values, actually I am receiving the 404 Error,

Could any one help me to implement the delete call, or a sample to delete the F & O Data entity Values via ODATA.

Data entity used : SecurityUserRoleAssociations

public async Task<string> DeleteAsync(AXEntity entity)

{

var fullUrl = ApiUrl + entity.LogicalName + "(";

foreach (var a in entity.Attributes)

{

fullUrl = fullUrl + a.Key + "='" + a.Value.ToString() + "',";

}

fullUrl = fullUrl.TrimEnd(',') + ")"; // An URL be like https://dynamics*****0390ceaos.cloudax.dynamics.com/data/SecurityUserRoleOrganizations( SecurityRoleIdentifier='ANONYMOUSAPPLICANT',OrganizationId='INMF',UserId='pavithra')

var request = new HttpRequestMessage(new HttpMethod("Delete"), fullUrl)

{

Content = new StringContent("{}", Encoding.UTF8, "application/json")

};

var response = await _baseAuthorization.GetHttpCliente().SendAsync(request);

string isSuccess = ResponseValidator.EnsureSuccessStatusCode(response);

return isSuccess;

}

Thanks

Praveen

I have the same question (0)

All responses (3)

Answers (0)

Jie G on at

Like (0)

Report

RE: Getting Error while Performing Delete Action on D365 F&O Via Odata Call

Hi Praveen,

404 means the data entity you're looking for does not exist on the server. Have you viewed the URL using the browser, can you see the entity is available?

Was this reply helpful? Yes No
GP Development comm... 135 on at

Like (0)

Report

RE: Getting Error while Performing Delete Action on D365 F&O Via Odata Call

Hi Ada,

Thanks for the response

Yes, i am able to retrieve the data in browser by the query i am passing in code, below is the error which i am actually getting.

Thanks

Praveen

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Getting Error while Performing Delete Action on D365 F&O Via Odata Call

I have the exact same issue trying to delete SecurityUserRoleOrganizations using the OData REST API.

I've even tried it on other entities with composite keys but still receive a 404 error. Given the lack of documentation from Microsoft (for this API and others) I can only assume that their OData implementation can't handle composite keys.

One thing you might be missing in your example @Praveen, is the OrganizationType. From what i've found this value is part of the composite key, but as it is an Enum you need to reference it like this: OrganizationType=Microsoft.Dynamics.DataEntities.OMInternalOrganizationType'LegalEntity'

Something else worth mentioning, I've even tried to do this Microsoft Flow. Strangely, the "Get record" connector returns an ItemInternalId value when you get records from the SecurityUserRoleOrganizations entity, but this still can't be used to reference the individual record so it can be deleted.

Was this reply helpful? Yes No