Query Monitored Posts
query_monitored_postsmode="search" (default): individual post rows. mode="stats": per-status counts.
Each row is one post a monitor surfaced, with the comment Sliq drafted for it
(draft_comment) and the post's lifecycle status: 'discovered' (claimed,
pre-draft), 'queued' (drafted + enqueued), 'commented' (comment sent),
'rejected' (user declined the draft), 'skipped' / 'skipped_no_credit' (no
comment drafted), 'engagers_only' (captured for its engagers, not commented),
'surfaced' (a surface-only monitor discovered it — no comment, no capture, just
surfaced in the feed to act on manually).
reaction_status is the independent reaction track: '' (no reaction),
'queued' (a reaction enqueued), 'reacted' (sent), 'rejected' (user declined it),
'skipped' (deduped) — disjoint from status since one post can be both
commented and reacted to. reaction_type is which reaction landed
(like/celebrate/support/love/insightful/funny, '' until sent).
Columns: id, monitor_id, post_urn, post_url, author_name, author_provider_id,
post_text, reaction_count, comment_count, posted_at, status, draft_comment,
reaction_status, reaction_type, created_at. Pass a row's id to
generate_monitored_post_comment to draft + queue a Sliq comment for it.
Pass agent_id to scope to that agent's monitors — omitting it reads every
monitored post across all the user's agents. To act on recent posts (e.g. queue
a reaction on this agent's fresh finds), pass agent_id and filter on
posted_at; this keeps actions on the agent's own scoped feed rather than the
account-wide analytics.
This is the monitor-scoped feed. query_linkedin_posts is a different table —
the account-global analytics of the user's own posts plus any post they've
fetched engagers for, with no agent/monitor dimension. Use that for "how did my
posts perform"; use this for "what did this agent's monitors find".
In search mode, {count, truncated, items array}.
In stats mode, {total, by_status: {discovered: N, commented: M, ...}}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | "search" to list rows, "stats" for per-status counts. | search |
| limit | No | Max results (default 50, capped at 100). Search mode only. | |
| offset | No | Rows to skip for paging (default 0, search mode only). When the result is truncated, re-call with offset += limit for the next page. | |
| agent_id | No | Scope to one agent's monitors. Omit for cross-agent queries. | |
| order_by | No | SQL ORDER BY (default: created_at DESC). Search mode only. | created_at DESC |
| where_clause | No | SQL WHERE condition (default: all). Examples: "status = 'commented'", "posted_at >= NOW() - INTERVAL '24 hours'", "author_name ILIKE '%founder%'" | 1=1 |