web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / OData V4 API and Credi...
Business Central forum

OData V4 API and Credit Memos entity error

(0) ShareShare
ReportReport
Posted on by Community Member

HI,

We are using the OData V4 api of Business Central to get the info of some parts of the application and we found a situation that seems to be a bug in Dynamics.

If you access the endpoints for Sales Credit Memos (9302) or Purchase Credit Memos (9309) using the "select" statement in the request AND if you specify the "Accept" header with "application/json;odata.metadata=full", a http 500 error is thrown.

Here is an example:

IMG_5F00_03102018_5F00_171314_5F00_0.png

IMG_5F00_03102018_5F00_171314_5F00_1.png

Without the select statement, it works in both cases:

IMG_5F00_03102018_5F00_171314_5F00_2.png

IMG_5F00_03102018_5F00_171314_5F00_3.png

It seems to us like a problem inside the service.

Thanks!!

Categories:
Other
I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Stefano,

    They URLs are correctly formed and they work in all the cases we tried except this two mentioned. And even in this two cases, they get to work when you don't specify the Accept header.

  • Community Member Profile Picture
    Community Member on at

    Hi Olister,

    I don't understand when you say that the query "looks like a sql query". In all cases the URLs follow the OData V4 standards and they fail only in the mentioned scenarios.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    This is a not supported url. Your second way is correct.

  • Suggested answer
    Olister Rumao Profile Picture
    Olister Rumao 3,967 on at

    Hi Adrian,

    Did you verify your wuery by going through the below URL?
    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris
    Although your query looks like a sql query. I suggest you can filter as per it is mentioned in the URL.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans