I have a Azure API management service(API Gateway) from which I am trying to fetch analytics data i.e. reports by operation. The Azure docs states the use of '$filter' to filter the data using multiple parameters. My goal is to filter the data based on timestamp and productID. Adding only timestamp filter returns correct data but combining it with 'productId' returns blank data wit response code of 200. Not sure why. I get the same issue when working with Azure API explorer too. Below is my $filter formation. Please help resolve.
'$filter' : "timestamp ge datetime'2021-06-01Y00:00:00' and timestamp le datetime'2021-06-01Y00:00:00' and productId eq '/products/myproduct' "
Document I am referencing : https://docs.microsoft.com/en-us/rest/api/apimanagement/2019-12-01/reports/list-by-operation