Skip to main content

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.
 

 

 

**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?

 


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


@Chris Hackett, I was not. Any suggestions?


@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


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