Solved

Odata V4 Not working

  • 4 May 2023
  • 5 replies
  • 411 views
E
Rank
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.
 

 

icon

Best answer by RohitRattan88 21 June 2023, 20:01

View original

5 replies

E
Rank
Userlevel 4
Badge +1

 

**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
Rank
Userlevel 7
Badge

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
Rank
Userlevel 4
Badge +1

@Chris Hackett, I was not. Any suggestions?

RohitRattan88
Rank
Userlevel 7
Badge +4

@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

E
Rank
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.
 

Reply


Terms & ConditionsCookie settings
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