Skip to main content
Solved

REST API: using $filter on a Generic Inquiry

  • June 3, 2024
  • 3 replies
  • 412 views
B
Semi-Pro I
Forum|alt.badge.img+2

I following the instructions listed here:

https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/

 

However, my Generic Inquiry is really large so I’d like to apply a filter.  However, since I created a Result set using the instructions above, I get an error when I want to filter on a Generic Inquiry value:

    "exceptionMessage": "The parent value for a property access of a property 'InventoryID' is not a single value. Property access can only be applied to a single value.",

 

I’m able to filter in the UI on the Generic Inquiry page when I click VIEW INQUIRY so it seems like I shouldn’t have followed the instructions above when creating my Web Service Endpoint.

 

Question: are there a separate set of instructions to follow when using $filter with Generic Inquiry and REST?

 

Here’s the URL I’m using:

https://sandbox.acumatica.com/entity/INStockItem/22.200.001/POReceiptPackages?$expand=Result&$filter=Result/InventoryID eq '331-0470'

Best answer by Dmitrii Naumov

@bpgraves since you use PUT to get the data from a GI, the $filter expression is not supported. 

You can add the condition in the GI itself and send it in the body of the request.

3 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Dmitrii Naumov
  • Acumatica Moderator
  • Answer
  • June 3, 2024

@bpgraves since you use PUT to get the data from a GI, the $filter expression is not supported. 

You can add the condition in the GI itself and send it in the body of the request.

D
jinin
Chris Hackett
T
Freshman I
  • tracy27
  • Freshman I
  • August 6, 2025

Do you think for once you could put in an answer?  I mean you talk about it but you never actually answer the question and I am tired of seeing examples that never have an answer.  So how about an answer for a change.

JSpikowski
Jr Varsity II
Forum|alt.badge.img
  • JSpikowski
  • Jr Varsity II
  • August 6, 2025

Tracy,

That kind of request will get you ignored.  Try a more humble approach.

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