Solved
Odata with Date Parameter not working and shows following Error
Best answer by hdussa
Hi
Yes, the GI parameters and conditions are honored if they are available and active. Try disabling the condition at the GI and the filters will help retrieving the wanting results.
You will find more information about parameters at the below link.
https://help.acumatica.com/?ScreenId=ShowWiki&pageid=c5e2f36a-0971-4b33-b127-3c3fe14106ff
Hello
I would check the datetime format of the parameter and try with this format
$filter=DateFrom gt datetime'yyyy-mm-dd hh:mm:ss'Hope this helps.
~ Harish Dussa
1 person likes this
<m:message>Syntax error at position 20 in 'DateField gt 2024-09-01 00:00:00'.</m:message>
<m:type>Microsoft.Data.OData.ODataException</m:type>
Hi
I tried accessing OData of AR Invoices GI from Excel and it worked for me with the below filter.
/odata/AR-Invoices and Memos?$filter=Date ge datetime'2024-08-23'
~ Harish Dussa
Though its showing data but only of todays
the GI has a Default Date Parameter as @today , is that the reason ? actually
am not trying to Filter the Data, am Trying to get data from with different date parameter
1 person likes this
Hi
Yes, the GI parameters and conditions are honored if they are available and active. Try disabling the condition at the GI and the filters will help retrieving the wanting results.
You will find more information about parameters at the below link.
https://help.acumatica.com/?ScreenId=ShowWiki&pageid=c5e2f36a-0971-4b33-b127-3c3fe14106ff
~ Harish Dussa
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.