TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Call GET method with filter parameter
Hi Team! I need your help...

I'm try call an URL with GET method and "Filter" parameters, this filter include a date, but to call URL I can't add correctly the date format because appear an error message.

URL: /secure/api/v2/{appid}/{table}/select.json?column=RUT%2F%2FCOUNT&filter=%5BRUT%5D%3D%2217575509-8%22%20and%20%5BOTP%5D%3D%22173641%22%20and%20%5BTELEFONO%5D%3D%22%2B56994512175%22and%20%5BRESET%5D%3D2023-05-2510%3A32%3A21

Field date: RESET
Date: 2023-05-25T10:31:21.13-05:00

Error message:
"error": 400,
"code": 2002,
"source": "filter",
"message": "Unexpected ':'"

Please, if possible share me an example, I'm review the document ( but not appear nothing.


Francisco Ahumada
Date Created
6/28/2023 9:14:06 AM
Date Updated
6/28/2023 9:27:11 AM
Slava Shinderov  Staff  6/28/2023 9:20:56 AM
Here you go:

In general, please consider using regular view to construct/test your filter formula.
Pierre 6/28/2023 9:27:11 AM
Hello Francisco

I have struggled just as you do.

The way I do it now is the following:
I create a variable called [Filter], which I build with regular characters, ex (with date):

"[@Fact-HA]<>'"&[DEV@FactHAANePasAllouer]&"' and [@Organisation]='" & [@Organisation] & "' and [@Fournisseur]='" & [@Fournisseur] & "' and [@Société Destinataire (Nous)]='" & [@Nous] & "' and [#Achat]=0 and [Date de Facture]>=#" & Nz(Left(Format([Date de Commande],"s"),10),'2021-01-01') & "# and [Données Facture]='Validé'"

In the call URL, I use this variable and let TeamDesk convert it:

Kind regards,


Back to Search Results