Question

Using Startswith para to retrieve project tasks

  • 11 June 2024
  • 1 reply
  • 27 views

Userlevel 3
Badge

Hi There

 

Hope you are doing well

 

I’m trying to retrieve project tasks based on some parameters but it throwing the error

 

Endpoint : /ProjectTask?$filter=startswith(ProjectTaskID, '0LED') and ProjectID eq '000407'

 

but the error i’m receiving is : 

 

  "exceptionMessage": "Incorrect syntax near the keyword 'AND'.",

 

 

Thanks


1 reply

Userlevel 7
Badge +5

Do you have any issues if you remove the startswith and just specify one ProjectTaskID and one ProjectID?

And, just to confirm, you’re making a GET request?

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