CODEWITHSUNDEEP
stackexchange-api
user3240560
user3240560

Reputation: 360

Result count in SEDE doesn't match with Stack Exchange's API

I queried Stack Exchange explorer with this query and got the result of 12946, and I am trying to bring same count of question count through Stack Exchange API:

@concat('search/advanced?page=',dataset().PageNumber,'&pagesize=100&fromdate=1561939200&todate=',current date,'&order=desc&sort=activity&site=stackoverflow&filter=!)5aShmihVOxZoyNN9TVy065dCekm','&q=',dataset().TagsList)

However, the API result return onlys ~7000 questions not 12000+. Base API without the q parameter: https://api.stackexchange.com/2.2/search/advanced?page=1&pagesize=100&fromdate=1561939200&order=desc&sort=activity&site=stackoverflow&filter=!)5aShmihVOxZoyNN9TVy065dCekm

Note: I am using until activity in Azure Data Factory to retrieve all the question that meets the following tags and I am increasing the page number if the has_more in the response is true.

I am passing two batch of tags as there is a limitation in the q filter.

Upvotes: 0

Views: 102

Answers (1)

double-beep
double-beep

Reputation: 5519

That's probably because Stack Exchange Data Explorer (SEDE) is updated weekly (FWIW, the count is now 13k+). Therefore, the fact that the count of questions tagged with a specific tag differs is reasonable. See the FAQ for more details.

You may also be counting the same questions twice or even three times! Make sure you put its item of the items array in a new array and filter the duplicate ones out.

Upvotes: 1

Related Questions