Managing posts

Every post belongs to an establishment, so you pass its id with -e. Find it with sofia establishments:list (see accounts).

Creating posts

Publish a post

Without a date, the post goes out right away.

sofia posts:create -e $ESTABLISHMENT_ID -p instagram -c "Tarte tatin du jour"

Options

Schedule a post

Pass an ISO 8601 date with -s, --date.

sofia posts:create -e $ESTABLISHMENT_ID -p instagram -c "Brunch ce samedi" -s 2026-11-07T09:00:00Z

Save a draft

--draft saves the post without publishing or scheduling it.

sofia posts:create -e $ESTABLISHMENT_ID -p instagram -c "Brunch ce samedi" --draft

Add media

-m, --media takes media ids from your library or https addresses, separated by commas.

sofia posts:create -e $ESTABLISHMENT_ID -p instagram -c "Tarte tatin du jour" \
  -m $MEDIA_ID,https://images.example.com/tarte-tatin.jpg

For an address, the type comes from the extension: video for mp4, mov, webm and m4v, image otherwise. To upload first, see media.

Several networks at once

List the networks separated by commas in -p, --platforms. Each one receives the same text.

sofia posts:create -e $ESTABLISHMENT_ID -p instagram,facebook,linkedin -c "Tarte tatin du jour"

Dry run

--dry-run checks the post against each network’s rules and publishes nothing. See Dry run.

sofia posts:create -e $ESTABLISHMENT_ID -p instagram -c "Tarte tatin du jour" --dry-run

Idempotency

Rerun a command safely with --idempotency-key: the same key gives the same post, never two. See Idempotency.

sofia posts:create -e $ESTABLISHMENT_ID -p instagram -c "Tarte tatin du jour" \
  --idempotency-key brunch-2026-11-07

Full body from a file

For per-network text, several media or a schedule in one go, write the whole body in a file and pass it with -j, --json. It replaces the content options.

sofia posts:create --json post.json

{
  "establishmentId": "$ESTABLISHMENT_ID",
  "targets": [
    {
      "platform": "instagram",
      "text": "Tarte tatin du jour",
      "media": [{ "id": "$MEDIA_ID" }],
      "format": "post"
    },
    {
      "platform": "tiktok",
      "text": "Tarte tatin du jour",
      "media": [{ "url": "https://images.example.com/tarte-tatin.mp4", "type": "video" }]
    }
  ],
  "scheduledAt": "2026-11-07T09:00:00Z",
  "status": "scheduled"
}

List posts

Filter the list with these options. The answer is paginated: see Pagination.

• -e, --establishment: only this establishment.
• --status: only posts in this status.
• --limit and --cursor: the page size and where to resume.

sofia posts:list -e $ESTABLISHMENT_ID --status scheduled --limit 20

Filter by date range

--from and --to: a date range.

sofia posts:list -e $ESTABLISHMENT_ID --from 2026-11-01 --to 2026-11-30

Filter by author

--created-by me|app: posts you wrote yourself, or those created through the API.

sofia posts:list -e $ESTABLISHMENT_ID --created-by app

Reading and updating a post

posts:update changes the date (-s), the status (draft or scheduled), or the whole body with -j.

sofia posts:get $POST_ID
sofia posts:update $POST_ID -s 2026-11-08T09:00:00Z
sofia posts:update $POST_ID --json post.json

Changing post status

posts:update --status moves a post from draft to scheduled, and back.

sofia posts:update $POST_ID --status draft
sofia posts:update $POST_ID --status scheduled -s 2026-11-08T09:00:00Z

• --status scheduled -s <date> schedules a draft at that date.
• --status draft turns a scheduled post back into a draft: it keeps its content, loses its date and will no longer go out.

Deleting posts

sofia posts:delete $POST_ID

Script with jq

Since the output is JSON, jq extracts what you need: ids, statuses, the cursor of the next page.

sofia posts:list -e $ESTABLISHMENT_ID --status scheduled | jq '.data[] | {id, status}'
sofia posts:list -e $ESTABLISHMENT_ID | jq -r '.nextCursor'

Next: accounts and media.