Finance | Project Operations, Human Resources, ...

Answered

HTTP resources: Send OData Requests

(3) Share

Report

Posted on by CH-11120820-0

Hello everyone,

I am writing some code with the aim of reading data via the OData service of D365 FO. In the past I have already gained some experience with the mentioned features. For example, I read the metadata and get the relevant information about the available DataEntities.
Normally I can read data from the DataEnties by constructing the request accordingly. I am now attaching an example that already works:

GET {{d365_url}}/data/EngineeringChangeOrderHeaders(OrderNumber='0001',dataAreaId='demf')?cross-company=true

Extract from the metadata:

As you can see, the corresponding URL is filled with the keys of the EntityType. This works for the majority of entities. However, this error is always returned for the entity I want to read (ProductDocumentAttachment):

"No HTTP resource was found that matches the request URI '{{d365_url}}/data/ProductDocumentAttachments(ProductNumber='000666',DocumentAttachmentTypeCode='URL',AttachmentDescription='URL20240709-091930',AttachedDateTime='2024-07-09T07:19:31')'. No route data was found for this request."

The corresponding metadata entry shows the keys to be used:

Now to my actual question / my actual questions:

How can I find out which HTTP resources are available?
Can I assume that this is how the HTTP requests are put together?
Is there any official documentation on this, and if so, where? (Unfortunately I have not found anything after hours of internet research)
Can I somehow debug this “mapping” between HTTP request and entity?

Thank you very much for your help!

With kind regards

Christian

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (9)

Answers (1)

Martin Dráb 237,805 Most Valuable Professional on at

Like (1)

Report

To see which records are available, let the entity return all data instead of referring to a single record by its key. In your case, use just {{d365_url}}/data/ProductDocumentAttachments.

Was this reply helpful? Yes No
CH-11120820-0 97 on at

Like (1)

Report

Hello Martin,

Yes, I already know that. But it's not quite what I'm trying to achieve and it's not really an answer to my questions.

Was this reply helpful? Yes No
Martin Dráb 237,805 Most Valuable Professional on at

Like (1)

Report

Okay, so what do you mean by "How can I find out which HTTP resources are available"?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (2)

Report

Hi Christian,

Not sure, but it can be caused by a time zone conversion of the date/time you provided. Instead of using the key fields, you can try using the query option $filter. You can then try to find a record without a value for the AttachedDateTime field. You can read more about this here: Open Data Protocol (OData) - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
CH-11120820-0 97 on at

Like (2)

Report

@Andre
Yes, I am also familiar with this type of query. However, there is a small difference between the two queries. With a filter, I can at most get the result as a list with one element. Whereas sending the key fields results in the entity being output directly. Let me put it this way: this is not a problem for reading (just an extra step for my software). But if I want to update or delete something on the same entity, it is necessary in this way.

The error message suggests that this endpoint does not exist. If a value was wrong (already had this with another entity) the error message would be correspondingly different. Which brings me back to the questions.

@Martin
I found out through testing that the error message comes up when I enter a route that doesn't exist, for example. Example:
GET {{d365_url}}/data/FooEntity
So for me it looks as if a corresponding route does not exist. At this point, documentation about which routes exist in D365FO would be really helpful.

Was this reply helpful? Yes No
Martin Dráb 237,805 Most Valuable Professional on at

Like (1)

Report

It depends on what kind of route you mean.

This thread seems to be about {{d365_url}}/data/ProductDocumentAttachments(ProductNumber='000666',DocumentAttachmentTypeCode='URL',AttachmentDescription='URL20240709-091930',AttachedDateTime='2024-07-09T07:19:31'), therefore the question "what are valid routes like this?" actually means "what are keys of all records contained in this entity?". The answer is that you need to return all records from the entity, which is done by not including any filters. If you wish, you can then create a scripting taking the data and creating an access URL for each record.

Regarding {{d365_url}}/data/FooEntity, you can get the list of available entities by opening {{d365_url}}/data/FooEntity. If you don't find FooEntity there, you know that trying to use would fail. Or you can try the URL and check the response code.

Was this reply helpful? Yes No
CH-11120820-0 97 on at

Like (1)

Report

I think I'm finding it difficult to explain my problem sufficiently. I'll try to express it differently, perhaps in simpler terms first, and then I should be able to get further with the information.

If I want to use the “EngineeringChangeOrderHeaders” entity (as shown in the thread description), I have to specify the key fields stored in the metadata in the following format:
/data/EntitySet(KeyField1='value', keyField2='value')

This works for most of the entities I have found. But not for “ProductDocumentAttachment”.
Even if I specify all values defined as “key fields” in the notation described above, I get the error that the HTTP resource does not exist.

How can I delete a “ProductDocumentAttachment” with the help of OData requests?

Was this reply helpful? Yes No
Verified answer

Mariano G. 3,598 on at

Like (3)

Report

I think your problem is in the datetime format, I've tested the entity PartyLocationPostalAddresses, and in my case I get the same error if I use quotations:

D365_URL/data/PartyLocationPostalAddresses(PartyNumber='000000001',LocationId='000000001',ValidFrom='2024-10-15T10:45:45Z')

but if I don't, it works:

D365_URL/data/PartyLocationPostalAddresses(PartyNumber='000000001',LocationId='000000001',ValidFrom=2024-10-15T10:45:45Z), be aware of using 'Z' at the end of the date-time value (UTC).

date time values don't uses quotations, just like integers or booleans

Was this reply helpful? Yes No
CH-11120820-0 97 on at

Like (1)

Report

That was it for me :) <3

Was this reply helpful? Yes No

Join the conversation

Community site session details

HTTP resources: Send OData Requests

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

HTTP resources: Send OData Requests

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates