Using Startswith para to retrieve project tasks

  • 11 June 2024
  • 1 reply

Userlevel 3

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'.",




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?


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