Skip to main content
Answer

Odata V4 Not working

  • May 3, 2023
  • 5 replies
  • 1091 views
E
Varsity I
Forum|alt.badge.img+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

@Ellie 

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 https://help.acumatica.com/(W(30))/Help?ScreenId=ShowWiki&pageid=642945d9-df36-429b-8784-0f1bcf0e5495

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

5 replies

E
Varsity I
Forum|alt.badge.img+1
  • Ellie
  • Author
  • May 8, 2023

 

**Additional details:

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

URL/ODatav4/Tenant/PX_Objects_AR_Customer

 

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?

 

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • June 21, 2023

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
E
Varsity I
Forum|alt.badge.img+1
  • Ellie
  • Author
  • June 21, 2023

@Chris Hackett, I was not. Any suggestions?

RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+4
  • RohitRattan88
  • Acumatica Moderator
  • Answer
  • June 21, 2023

@Ellie 

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 https://help.acumatica.com/(W(30))/Help?ScreenId=ShowWiki&pageid=642945d9-df36-429b-8784-0f1bcf0e5495

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

Chris Hackett
E
Varsity I
Forum|alt.badge.img+1
  • Ellie
  • Author
  • June 21, 2023

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.
 

Terms & ConditionsCookie settingsAccessibility statement
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