excalibur_list_posts
List your stored posts, server-side sorted, filtered, and offset-paginated.
Optional status filter — a single status or a comma-separated set
(e.g. draft,scheduled), matched as set membership. sort_col is one of
created|updated|status|scheduled (default created); sort_dir is
asc|desc. search is a case-insensitive regular expression matched
against the post text. date_from/date_to accept bare YYYY-MM-DD
(UTC-calendar day, end-inclusive) or an ISO instant (patron-local midnight from
the FE — exclusive upper bound when instant). Bound the date_field column,
one of created|updated|scheduled|sent
(default created). template_id filters to the sent occurrences a recurring
template fired. sent_hour (0–23) with time_zone (IANA) keeps only posts
whose last_sent_at local wall hour in that zone matches — used by the
Performance time-of-day chart deep-link. page is 0-indexed; page_size
is 1..100. Each row carries is_recurring, has_dynamic, and
template_id (set on sent occurrences).
Returns {posts:[…], total, page, page_size} reflecting the filtered set.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| npub | No | Required. Your Nostr public key (npub1...) for credit billing. | |
| page | No | ||
| search | No | ||
| status | No | ||
| date_to | No | ||
| sort_col | No | created | |
| sort_dir | No | desc | |
| date_from | No | ||
| page_size | No | ||
| sent_hour | No | ||
| time_zone | No | ||
| date_field | No | created | |
| dpop_token | No | ||
| template_id | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||