Skip to main content
Answer

Using Startswith para to retrieve project tasks

  • June 11, 2024
  • 1 reply
  • 55 views
Driss
Jr Varsity III
Forum|alt.badge.img

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

Best answer by Django

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?

🎉https://www.linkedin.com/in/driss-talainte🧑‍💻

1 reply

D
Captain II
Forum|alt.badge.img+7
  • Django
  • Captain II
  • Answer
  • June 12, 2024

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?

Chris Hackett
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