Filter API URL (400) Bad Request

[Anonymous]

https://AAA_WebServer/api/items/logs?$select=field,action,time,old_value,new_value,note,change_source,article_id,action_field,source_text,username_username,username_email,article_id_name,article_id_bim_id,article_id_number_name?filter=items\time gt '2021-06-30'

Is there anything in the syntax that looks wrong? the API URL works if I leave out the filter section.

btw. I also tried filter=items\time gt datetime''2021-06-30T00:00:00'

[v-kelly-msft]

Hi  @Anonymous ，

Try below format:

$filter=StartDate ge datetime'2014-01-01T00%3a00%3a00'

Check the reference below:

https://newbedev.com/rest-api-filter-by-start-and-end-dates-using-today

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Thank you @mahoneypat and @v-kelly-msft for your responses. The ampersand worked!

Cheers, I really appreciate this forum. I am learning so much.

[mahoneypat · Accepted solution]

Yes.  Typically each parameter is separated by '&', and filter should be prefixed by $.

https://AAA_WebServer/api/items/logs?$select=field,action,time,old_value,new_value,note,change_source,article_id,action_field,source_text,username_username,username_email,article_id_name,article_id_bim_id,article_id_number_name&$filter=items\time gt '2021-06-30'

Pat