Solved

Filter Sales Orders using USER Defined Rest APi

  • 12 July 2023
  • 2 replies
  • 123 views

Userlevel 3
Badge

Hey All 

I’m Trying to filter all sales orders using USER-DEFIND field 

 

 

 

I’m using this Endpoint 

Method : POST 

URI: https://exemple.acumatica.com/entity/default/22.200.001/SalesOrder?$custom=Document.AttributeCPQORDNBR.value
&$filter=custom.document.AttributeCPQORDNBR eq '00000110'&$top=100


but it not working even i can see the custom field in the JSON 

Error :

message\":\"An error has occurred.\",\"exceptionMessage\":\"The child type 'custom.document.AttributeCPQORDNBR' in a cast was not an entity type. Casts can only be performed on entity types.

 

 

 

Much appreciated 

 

Thanks

icon

Best answer by kpopova 13 July 2023, 10:00

View original

2 replies

Userlevel 3
Badge +2

Please see the description of the filter parameter here: https://help.acumatica.com/(W(17))/Help?ScreenId=ShowWiki&pageid=f279ec05-2f71-4376-a76f-d3ed0e0e2556 and Example: Condition on a Field Not Defined in the Endpoint on the same page. You need to use custom cf function in the filter.

Userlevel 3
Badge

@kpopova Thank you so much! 

Reply


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