rest - Office365 报告 REST API - "The query is invalid."

Question

为什么我能够使用以下请求查询 Office365 的报告 API:

https://reports.office365.com/ecp/reportingwebservice/reporting.svc/MessageTrace?$select=Subject,SenderAddress,RecipientAddress,Status,Received,Received&$filter=SenderAddress eq 'foo@bar.com' and RecipientAddress eq 'bar@foo.com' and StartDate eq datetime'2016-10-01T00:00:00' and EndDate eq datetime'2016-10-03T00:00:00'

但是当我修改它以过滤 时主题 同样，它返回一个错误:

https://reports.office365.com/ecp/reportingwebservice/reporting.svc/MessageTrace?$select=Subject,SenderAddress,RecipientAddress,Status,Received,Received&$filter=SenderAddress eq 'foo@bar.com' and RecipientAddress eq 'bar@foo.com' and StartDate eq datetime'2016-10-01T00:00:00' and EndDate eq datetime'2016-10-03T00:00:00' and Subject eq 'Test'

{ "odata.error": { "code": "InvalidQueryException", "message": { "lang": "", "value": "The query is invalid." } } }

Answer 1

尝试类似

startswith(Subject,'Test')