Finance | Project Operations, Human Resources, ...

Unable to use the link provided by MS Dynamics to fetch the Entity.

(1) Share

Report

Posted on by KC-27040946-0

Hi All,

I am working on an entity /BillOfMaterialsVersionsV3/. I am trying to update and delete the data on it through OData. However, the OData Id (@odata.id) that I am receiving throws an HTTP error 400 (Bad Request - Invalid URL) when I try to hit it on the browser. It is working fine for other entities. How can I get the correct link for the same?

URL for reference that I am receiving from MS Dynamics 365: https://trial-0zyrz7.trial.operations.dynamics.com/data/BillOfMaterialsVersionsV3(dataAreaId='usmf',ManufacturedItemNumber='4401',BOMId='000021',ProductionSiteId='1',ProductConfigurationId='',ProductColorId='Green',ProductSizeId='',ProductStyleId='',ProductVersionId='',IsActive=Microsoft.Dynamics.DataEntities.NoYes'Yes',ValidFromDate=1900-01-01T12:00:00Z,FromQuantity=1)

I have cross checked the values for the key attributes, and they are all correct.

Here's the error:

Thanks in advance.

Regards,
Kushank.

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Kushank, As the error suggested, the issue is in URL. I suggest to try removing few fields like isActive, FromDate to narrow down which field is the root cause.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 305,354 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi Kushank,

Instead of trying to specify the entity key, you can also use the filter syntax.

https://trial-0zyrz7.trial.operations.dynamics.com/data/BillOfMaterialsVersionsV3?$filter=dataAreaId eq 'usmf' and ManufacturedItemNumber eq '4401' and BOMId eq '000021' and ProductionSiteId eq '1' and ProductConfigurationId eq '' and ProductColorId eq 'Green' and ProductSizeId eq '' and ProductStyleId eq '' and ProductVersionId eq '' and IsActive eq Microsoft.Dynamics.DataEntities.NoYes'Yes' and ValidFromDate eq 1900-01-01T12:00:00Z and FromQuantity eq 1

Note that there is no active version. To get at least one record, you can use the next link.

https://trial-0zyrz7.trial.operations.dynamics.com/data/BillOfMaterialsVersionsV3?$filter=dataAreaId eq 'usmf' and ManufacturedItemNumber eq '4401' and BOMId eq '000021' and ProductionSiteId eq '1' and ProductConfigurationId eq '' and ProductColorId eq 'Green' and ProductSizeId eq '' and ProductStyleId eq '' and ProductVersionId eq '' and IsActive eq Microsoft.Dynamics.DataEntities.NoYes'No' and ValidFromDate eq 1900-01-01T12:00:00Z and FromQuantity eq 1

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report
Copy link

Link copied!

Try this.

<D365URL>/data/BillOfMaterialsVersionsV3?cross-company=true&$filter=dataAreaId eq 'usmf' and ManufacturedItemNumber eq '4401'and BOMId eq '000021'

Was this reply helpful? Yes No
KC-27040946-0 9 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohit, Andre and Bharani.

Thanks for the responses. I am able to use the filter to fetch the data.

But I want to update and delete the data on it using OData. I cannot use that link with filter for the same. I have to use the "EditLink" that is provided by MSD365 but in this case it is not working. Here are the few attributes from the same data object that are not shown by default.

"@odata.type": "#Microsoft.Dynamics.DataEntities.BillOfMaterialsVersionV3",
"@odata.id": "https://trial-0zyrz7.trial.operations.dynamics.com/data/BillOfMaterialsVersionsV3(dataAreaId='usmf',ManufacturedItemNumber='4401',BOMId='000021',ProductionSiteId='1',ProductConfigurationId='',ProductColorId='Green',ProductSizeId='',ProductStyleId='',ProductVersionId='',IsActive=Microsoft.Dynamics.Ax.Xpp.NoYes'Yes',ValidFromDate=1900-01-01T12:00:00Z,FromQuantity=1)",
"@odata.etag": "W/\"JzE1MzEyNjU5NSw2ODcxOTQ4Mzc2Myc=\"",
"@odata.editLink": "./BillOfMaterialsVersionsV3(dataAreaId='usmf',ManufacturedItemNumber='4401',BOMId='000021',ProductionSiteId='1',ProductConfigurationId='',ProductColorId='Green',ProductSizeId='',ProductStyleId='',ProductVersionId='',IsActive=Microsoft.Dynamics.Ax.Xpp.NoYes'Yes',ValidFromDate=1900-01-01T12:00:00Z,FromQuantity=1)",

To update/delete the data, I use the @odata.id and/or the @odata.editlink. I want to find out the correct editlink in this case.

Note: The value for "IsActive" attribute is wrong in the id and editlink. I have to manually change it by checking the following attributes:

"IsActive@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsActive": "Yes"

Can you please suggest me a way to get a working @odata.id or @odata.editlink. That would help me a lot.

Thanks in advance.

Regards,

Kushank.

Was this reply helpful? Yes No
André Arnaud de Cal... 305,354 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Maybe a video form Rachit Garg would help you out. It shows how to update or delete records using LogicApps. What tool are you using?

When updating or deleting the record, you would need to provide all the fields of the entity key and the DataAreaId. When you are using the Fin and Ops connector in Logic Apps or Power Automate, ensure the default company of the user is the same as the company from which you want to update or delete records.

Here is the video: OData - DELETE Method call - YouTube

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

If your question is answered, please mark the useful answers as verified so that this can be useful for others in future.

Was this reply helpful? Yes No
KC-27040946-0 9 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Apologies for the late reply.

I watched that video. I am doing the same thing on Postman. My delete and update requests are successful for other objects (for example ReleasedProductsV2). If you see the video, Rachit is sending a delete request to a certain URI but for me that URI itself is not working. That makes delete and update impossible to execute.

This URI is the same "@odata.id" that I mentioned in the post.

Here is the sample of "@odata.id" working for ReleasedProductsV2:

Update request using the same "@odata.id":

After this request, the purchase price is being updated. But back to the same question. This "@odata.id" doesn't work in case of the entity "BillOfMaterialsVersionsV3". I cannot hit the same on browser, I cannot send any delete or update requests either. If you know how I can get the valid URI for the mentioned object, that would be extremely helpful.

Sharing the sample URI for "BillOfMaterialsVersionsV3" again: https://trial-05lr9c.trial.operations.dynamics.com/data/BillOfMaterialsVersionsV3(dataAreaId='usmf',ManufacturedItemNumber='D0002',BOMId='D0002BOM',ProductionSiteId='1',ProductConfigurationId='',ProductColorId='',ProductSizeId='',ProductStyleId='',ProductVersionId='',IsActive=Microsoft.Dynamics.DataEntities.NoYes'Yes',ValidFromDate=1900-01-01T12:00:00Z,FromQuantity=1)

Thanks,

Kushank.

Was this reply helpful? Yes No
André Arnaud de Cal... 305,354 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Kushank,

I thought I replied already, but can't find my latest comment. There is another similar question on this forum where it was working for one item, but not another item. Maybe there is an issue with a maximum length to specify the key fields with their values. I would suggest to check if it works correctly with other entities with less fields in the entity key. Then you can consider contacting Microsoft Support.

Was this reply helpful? Yes No