Odata V4 Not working

Userlevel 4
Badge +1

I am trying to run an Odata V4 query but have not been able to get it to work

This simple query works fine:

"URL/odata/Tenant/IN-StockItem?$filter=substringof('TestItem', InventoryID) eq true"


But when i add the v4 part, it does not yield any results.

"URL/odataV4/Tenant/IN-StockItem?$filter=substringof('TestItem', InventoryID) eq true"

Is the above V4 syntax wrong?

Is there something that needs to be enabled in order for Odata V4 to work?

I ensured the user has the ODatav4 User ( Access to data exposed via OData v4) role assigned.



Best answer by RohitRattan88 21 June 2023, 20:01

View original

5 replies

Userlevel 4
Badge +1


**Additional details:

When querying an actual DAC using v4, it does work, as in the following example: 



That suggests that the issue is only with generic inquires. 

Does that mean that Odata v4 is compatible only with DACs on not customer Generic Inquiries?


Userlevel 7

Hi @Ellie were you able to find a solution? Thank you!

Userlevel 4
Badge +1

@Chris Hackett, I was not. Any suggestions?

Userlevel 7
Badge +4


I think you are right about oData v4 only compatible with DACs. You could get list of all oDatav4 endpoints by querying a GET at https://<Acumatica ERP instance URL>/odatav4/<tenant>/$metadata

as per documentation at

In the OData Version 3.0 interface, you can request data from generic inquiries that are configured in Acumatica ERP. In the OData interface based on the OData Version 4.0 protocol, you can request data from Acumatica ERP by directly accessing DACs without configuring any generic inquiry

Userlevel 4
Badge +1

Thanks @RohitRattan88 

That is very unfortunate. 

From the documentation is appeared to me that we could access DAC directly in in addition to GI. I wonder why GIs would be excluded, which makes the entire Odata concept much less useful.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved