I'm trying to use http://data.stackexchange.com/stackoverflow/atom to get stackoverflow data. But I have some problems.

One of my request is to get the posts with specific tags, for example odata. (I want posts with tags contains odata, not just posts just with tags odata). And I tried the odata official url request:

http://data.stackexchange.com/stackoverflow/atom/Posts?$filter=contains(Tags, 'odata')

Then I got this error:

Unknown function 'Contains' at position 0.

So my question is: Is there an easy way to query the data using stackoverflow odata endpoint?


Data Explorer only supports up to OData version 2, but the contains function was added sometime after that (either version 3 or 4). You can view the list of supported $filter functions on the OData website.

Note that the OData endpoints have generally been deprecated in favour of the Stack Exchange API, which offers a more convenient and reliable way to get at the data, so it's unlikely that support for later OData versions will be added to Data Explorer.

That said, for your particular query, you can just use the indexof function instead. For example: /Posts?$filter=indexof(Tags,'odata') gt -1

| improve this answer | |
  • Thanks for clarify. One more question on odata endpoint for stackoverflow. Is there a limit on records returned from a request? When I run /Posts/$count, I got 18942008, but when I run /Posts, I got definitely less than 18942008 records. Is that due to some paging in OData or limit on the service? – QianLi Mar 11 '14 at 1:49
  • Yeah, I believe the default page size is 50. – Tim Stone Mar 11 '14 at 3:18
  • 3
    @TimStone Are the odata links dead now? Following the links from data.stackexchange.com gives Page Not Found responses. – Daniel Ballinger Oct 22 '14 at 1:21
  • @DanielBallinger: a late reply, but the answer appears to be yes. – halfer Sep 2 '15 at 18:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .