search

pushshift / api

Pushshift API
1.29k stars 109 forks source link

Comments showing up when querying by author, but not when querying them by id. #42

Open DuncanMarshall opened 4 years ago

DuncanMarshall commented 4 years ago

This comment exists if I search for it like this: https://api.pushshift.io/reddit/comment/search/?author=duncanmarshall&size=1&sort_type=created_utc&sort=asc

But not if I search like this: https://api.pushshift.io/reddit/comment/search?ids=c3zhmtx

That's to say it shows up on an author query, but not when directly querying it's id.

What's happening here?

pushshift commented 4 years ago

Thanks for reporting this! This is actually a bug since the second search you showed is attempting to get the data from Postgres when it should be fetching from Elasticsearch. We're moving away from Postgres (for feeding the API and delivering data via the API) so that all calls use Elasticsearch only.

Also, if you are attempting to get comments by their ids only, I would recommend using the Reddit API since it will return the most recent data including updated score information.

I'll work on fixing this bug so that requesting objects by their id get routed to the correct back-end DB.