Solved: Filter for request_path - Page 2

Report Inappropriate Content · 04-16-2015 06:32 AM

I am calling this API and am wondering if I can filter the by request_path like 'v1/resource/%'

v1/o/epsilon/environments/prod/stats/request_path?select=count(request_uri)&timeRange=4/15/2015 13:40~4/16/2015 14:40&timeUnit=hour

I am getting this error am not sure where to go to find the possible filters allowed for this API.

Invalid filter expression (request_path LIKE 'v1/resource/%')

Thanks

Report Inappropriate Content

I have tried with filter (apiproxy like 'ap%') and it worked for me. There was no error like invalid filter expression. Note that content inside single quote behaves like a string.

Following doc link has details on the filter:

http://apigee.com/docs/analytics-services/reference/analytics-reference

View solution in original post

Report Inappropriate Content

Hello Ajay,

I think the main issue here is that analytics API is not exactly SQL and uppercase vs lowercase actually makes a difference. You are using "LIKE" and the API is expecting "like" instead.

I just tried:

o/{org}/environments/{env}/stats/request_path?select=count(request_uri)&timeRange=4/15/2015 13:40~4/16/2015 14:40&timeUnit=hour&filter=(request_path+like+'/v1%')

and it worked fine for me.

I hope this helps.

View solution in original post