| name | ai-news-bitable-archive-dingtalk |
| description | Use when parsing a DingTalk daily news document and syncing title, date, Top 3, summary, conclusion, document link, and status into a DingTalk multidimensional table. 钉钉专用版。 |
| version | 1.0.0 |
| author | Hermes Agent |
| license | MIT |
| metadata | {"hermes":{"tags":["dingtalk","dws","aitable","archive","news","cron"]}} |
AI News → DingTalk Multidimensional Table Archive (DingTalk Edition)
Overview
This skill archives a DingTalk daily news document into a multidimensional table record. It fetches the document, extracts standard daily-report fields, creates or updates a multidimensional table record, and prints the resulting record_id.
When to Use
- A daily AI / Agent / AIGC report was published to DingTalk Docs
- The report should be searchable in the multidimensional table later
- You need idempotent create/update behavior by document token or date
Input Source: Read DingTalk Doc
dws doc read --node '<DOC_ID_OR_URL>' --format json
Extract content from the JSON response.
Archive Target: DingTalk Multidimensional Table
Use the DingTalk-specific archive script:
python3 scripts/sync_doc_to_dingtable.py \
--doc-url '<DINGTALK_DOC_URL>' \
--base-id '<DINGTALK_BASE_ID>' \
--table-id '<DINGTALK_TABLE_ID>' \
--date 'YYYY-MM-DD' \
--status '已归档'
The script:
- Reads the DingTalk doc via
dws doc read
- Parses the standard fields (标题, 日期, Top1-3, 一句话结论, 摘要)
- Obtains the multidimensional table schema via
dws aitable table get
- Maps field names to fieldIds
- Checks for existing records by 文档Token or 日期 (idempotent create/update)
- Writes via
dws aitable record create or dws aitable record update
- Outputs
record_id, mode (create/update), title, date, doc_url, and aitable_url
Validate Archived Record
dws aitable record query \
--base-id '<DINGTALK_BASE_ID>' \
--table-id '<DINGTALK_TABLE_ID>' \
--record-ids '<RECORD_ID>' \
--format json
Verify fields: 标题, 文档链接, 文档Token, 统计窗口, Top1-3, 一句话结论, 摘要, 状态.
Inspect Table Schema (when needed)
dws aitable table get --base-id '<DINGTALK_BASE_ID>' --table-id '<DINGTALK_TABLE_ID>' --format json
DingTalk multidimensional table URLs follow this format:
https://alidocs.dingtalk.com/i/nodes/{baseId}
Entry Point
python3 scripts/sync_doc_to_dingtable.py \
--doc-url 'https://alidocs.dingtalk.com/i/nodes/<NODE_ID>' \
--base-id '<DINGTALK_BASE_ID>' \
--table-id '<DINGTALK_TABLE_ID>' \
--date 'YYYY-MM-DD' \
--status '已归档'
Parsed Fields
- 标题
- 日期
- 文档链接
- 文档Token
- 统计窗口
- Top1 / Top2 / Top3
- 一句话结论
- 摘要
- 状态
Multidimensional Table Notes
- DingTalk multidimensional table uses fieldId as cell keys, not field names.
- The included script
sync_doc_to_dingtable.py automatically maps field names to fieldIds.
- Check field names/types before first use via
dws aitable table get.
Verification Checklist