API Examples
API Examples
Here are practical examples of using the Memoreru API. All requests require an Authorization header.
List content
curl -H "Authorization: Bearer mk_xxxxxxxxxxxx" \
https://memoreru.com/api/v1/contentsFilter by type:
curl -H "Authorization: Bearer mk_xxxxxxxxxxxx" \
"https://memoreru.com/api/v1/contents?content_type=table"Create a page
curl -X POST \
-H "Authorization: Bearer mk_xxxxxxxxxxxx" \
-H "Content-Type: application/json" \
-d '{"title": "Meeting Notes 2026-03-15", "description": "Weekly meeting record", "scope": "private"}' \
https://memoreru.com/api/v1/contents/pagesGet table rows
curl -H "Authorization: Bearer mk_xxxxxxxxxxxx" \
"https://memoreru.com/api/v1/contents/tables/{table_id}/rows?limit=50"Add a single row to a table
curl -X POST \
-H "Authorization: Bearer mk_xxxxxxxxxxxx" \
-H "Content-Type: application/json" \
-d '{
"data": {
"column_id_1": "Task A",
"column_id_2": "In Progress"
}
}' \
"https://memoreru.com/api/v1/contents/tables/{table_id}/rows"Add multiple rows (up to 100)
Use the same endpoint with a rows array:
curl -X POST \
-H "Authorization: Bearer mk_xxxxxxxxxxxx" \
-H "Content-Type: application/json" \
-d '{
"rows": [
{"column_id_1": "Task A", "column_id_2": "In Progress"},
{"column_id_1": "Task B", "column_id_2": "Not Started"}
]
}' \
"https://memoreru.com/api/v1/contents/tables/{table_id}/rows"Get column definitions
curl -H "Authorization: Bearer mk_xxxxxxxxxxxx" \
"https://memoreru.com/api/v1/contents/tables/{table_id}/columns"Retrieve column definitions to find each column's ID, display name, and data type. Use column IDs when adding or updating rows.
Update a table
curl -X PATCH \
-H "Authorization: Bearer mk_xxxxxxxxxxxx" \
-H "Content-Type: application/json" \
-d '{"title": "Updated Title"}' \
"https://memoreru.com/api/v1/contents/tables/{table_id}"Create or update a row (upsert)
If a row with a matching value in the specified column exists, it gets updated; otherwise a new row is created. Useful for syncing data from external systems without creating duplicates when the same data is sent more than once.
curl -X POST \
-H "Authorization: Bearer mk_xxxxxxxxxxxx" \
-H "Content-Type: application/json" \
-d '{
"match_column_id": "column_id_1",
"match_value": "Task A",
"data": {
"column_id_2": "Done"
}
}' \
"https://memoreru.com/api/v1/contents/tables/{table_id}/rows/upsert"This example looks for a row where column_id_1 equals "Task A". If found, it updates column_id_2; if not, it creates a new row.
Use Case Scenarios
Automated Reporting
Use cron jobs or GitHub Actions to periodically aggregate table data and write summaries to pages, automating daily or weekly reports.
External System Integration
Sync data from CRMs or project management tools into Memoreru tables via API, then visualize with dashboards.
AI Workflows
Combine with the MCP server to let AI analyze, summarize, and input data, streamlining information management.
Full Specification
For detailed request/response schemas and the complete endpoint reference, see the API Documentation.
コメント