Flexible filters
Compose SQL-like conditions in JSON with operators like =, contains, and range comparisons.
API v1
Programmatic access to social analytics datasets
ソーシャル分析データセットへのAPIアクセス
Query buzz-db and social-db using filter-based payloads. This API is optimized for fast analytical reads and predictable schema-driven responses.
Authentication
api-key: YOUR_API_KEY
Base URL
https://data-api.mugen-ai-social.jp
BigQuery-backed
Designed for analytics workloads with clean projection fields, ordering, and limits.
Schema transparency
Available fields are listed live below for both datasets to speed up query authoring.
Quick start
クイックスタート
1
Prepare credentials
認証情報の準備
Get your API key and keep it private. Every request must include it in the api-key header.
2
Build filters
フィルタを作成
Define conditions, select_fields, and an explicit date range for better performance.
3
Execute request
リクエスト実行
Send a POST call to one of the dataset endpoints and iterate quickly with Swagger or ReDoc.
Detailed how to use
APIの使い方（詳細）
Request shape
リクエスト形式
- conditions: array of filter clauses.
- select_fields: optional projection list.
- order_by + order_dir: optional sorting.
- limit (1-10000), offset (0-100000).
Operator guide
演算子ガイド
containsperforms partial string match.inexpects an array value.- Use ISO-like dates for date/timestamp fields.
- Always include a date boundary for cost control.
Output and sorting options
出力と並び順の設定
| Field | What it does | Example |
|---|---|---|
| select_fields | Choose which columns to return. If omitted, default output fields are used. | ["date", "user_name", "likes"] |
| order_by | Pick one field for sorting (for example date or likes). | "date" |
| order_dir | Sorting direction: "asc" = old/small to new/large, "desc" = reverse. |
"desc" |
| limit | How many rows to return. Good start: 20-100 for testing. | 100 |
| offset | Skip rows for pagination. Use 0 for first page, then 100, 200, ... | 0 |
Condition operations (simple guide)
条件演算子ガイド（やさしい説明）
Use this when you are not from an IT background. Pick the operator by what you want to compare.
| op | Meaning | Example |
|---|---|---|
| = | Exactly equal | {"field":"user_name","op":"=","value":"alice"} |
| != | Not equal | {"field":"tweet_type","op":"!=","value":"reply"} |
| > / >= | Greater than / greater or equal | {"field":"likes","op":">=","value":100} |
| < / <= | Less than / less or equal | {"field":"engagement","op":"<","value":5} |
| contains | Text includes keyword | {"field":"text","op":"contains","value":"campaign"} |
| in | Match any value in a list | {"field":"media_type","op":"in","value":["image","video"]} |
Recommended for beginners: start with date + one simple condition (for example likes >= 100) and test with limit: 20.
初心者向け：まずは date と単純な条件（例：likes >= 100）から始め、limit を20にして試してください。
POST /v1/buzz-db or /v1/social-db
Headers:
api-key: YOUR_API_KEY
Body:
{
"conditions": [{"field": "date", "op": ">=", "value": "2026-03-01"}],
"select_fields": ["date", "user_name", "text"],
"order_by": "date",
"order_dir": "desc",
"limit": 100,
"offset": 0
}Client example call
クライアント呼び出し例
Choose a language, review the example, then copy it. Default is Python.
import requests
BASE_URL = "https://data-api.mugen-ai-social.jp"
API_KEY = "YOUR_API_KEY"
payload = {
"conditions": [
{"field": "date", "op": ">=", "value": "2026-03-01"},
{"field": "hashtags", "op": "contains", "value": "ai"}
],
"select_fields": ["date", "user_name", "text", "likes"],
"order_by": "date",
"order_dir": "desc",
"limit": 100,
"offset": 0
}
response = requests.post(
f"{BASE_URL}/v1/buzz-db",
headers={"api-key": API_KEY, "Content-Type": "application/json"},
json=payload,
timeout=30
)
response.raise_for_status()
print(response.json())buzz-db fields
buzz-db フィールド
86 fieldsColumn descriptions
カラム説明
Each field includes a quick meaning reference for faster query design.
social-db fields
social-db フィールド
34 fieldsColumn descriptions
カラム説明
Each field includes a quick meaning reference for faster query design.