API Data Provider - Online Help

StackExchange Tables

The provider models the data in API into a list of tables that can be queried using standard SQL statements.

Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

StackExchange Tables

Name Description
Answers Query answers by user, question, or sort criteria
Badges Query badges
Comments Get comments for a given post or by sort criteria
Posts Query posts based on post owner or sort criteria.
Questions Query questions based on question owner, tags, or sort criteria.
Sites List all available sites
Tags List tags based on sort criteria
Users Get users based on sort criteria

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8487.0