Input: HTML Content + Meta-Daten + Media Assets
Output: WordPress Post (Draft/Published) + Post ID + URL

${WORDPRESS_URL}/wp-json/wp/v2/

// Basic Auth Header
const auth = Buffer.from(`${username}:${appPassword}`).toString('base64');

headers: {
  'Authorization': `Basic ${auth}`,
  'Content-Type': 'application/json'
}

{
  "title": "Artikel-Titel",
  "content": "<article>HTML Content...</article>",
  "excerpt": "Kurzbeschreibung für Listings",
  "status": "draft",
  "slug": "artikel-slug",
  "date": "2024-01-15T10:00:00",
  "featured_media": 123,
  "categories": [1, 5],
  "tags": [10, 15, 20],
  "meta": {
    "_yoast_wpseo_title": "SEO Title",
    "_yoast_wpseo_metadesc": "SEO Description"
  },
  "acf": {
    "custom_field_1": "value",
    "custom_field_2": "value"
  }
}

const uploadMedia = async (imageBuffer: Buffer, filename: string) => {
  const formData = new FormData();
  formData.append('file', imageBuffer, filename);

  const response = await fetch(`${WP_URL}/wp-json/wp/v2/media`, {
    method: 'POST',
    headers: {
      'Authorization': `Basic ${auth}`,
      'Content-Disposition': `attachment; filename="${filename}"`
    },
    body: formData
  });

  return response.json(); // { id: 123, source_url: "..." }
};

await updatePost(postId, {
  featured_media: mediaId
});

// POST mit ACF-Feldern
const postData = {
  title: "...",
  content: "...",
  acf: {
    hero_image: mediaId,
    author_bio: "Autor-Beschreibung",
    reading_time: "12 min",
    content_type: "pillar",
    related_articles: [101, 102, 103]
  }
};

meta: {
  '_yoast_wpseo_title': 'SEO Title | Brand',
  '_yoast_wpseo_metadesc': 'Meta Description...',
  '_yoast_wpseo_focuskw': 'primary keyword',
  '_yoast_wpseo_canonical': 'https://example.com/page',
  '_yoast_wpseo_opengraph-title': 'OG Title',
  '_yoast_wpseo_opengraph-description': 'OG Description',
  '_yoast_wpseo_twitter-title': 'Twitter Title',
  '_yoast_wpseo_twitter-description': 'Twitter Description'
}

meta: {
  'rank_math_title': 'SEO Title | Brand',
  'rank_math_description': 'Meta Description...',
  'rank_math_focus_keyword': 'primary keyword',
  'rank_math_canonical_url': 'https://example.com/page',
  'rank_math_facebook_title': 'OG Title',
  'rank_math_twitter_title': 'Twitter Title'
}

// Kategorie-ID finden
const categories = await fetch(`${WP_URL}/wp-json/wp/v2/categories?search=Marketing`);

// Post mit Kategorien erstellen
const postData = {
  // ...
  categories: [5, 12] // Kategorie-IDs
};

const newCategory = await fetch(`${WP_URL}/wp-json/wp/v2/categories`, {
  method: 'POST',
  body: JSON.stringify({
    name: 'Neue Kategorie',
    slug: 'neue-kategorie',
    parent: 5 // Optional: Parent-Kategorie
  })
});

// Tag-IDs finden oder erstellen
const tag = await fetch(`${WP_URL}/wp-json/wp/v2/tags?search=SEO`);

// Post mit Tags erstellen
const postData = {
  // ...
  tags: [10, 15, 20] // Tag-IDs
};

const postData = {
  title: "...",
  content: "...",
  status: "future",
  date: "2024-02-01T09:00:00", // UTC oder mit Timezone
  date_gmt: "2024-02-01T08:00:00" // Explizit GMT
};

// WordPress Timezone-Setting prüfen
const settings = await fetch(`${WP_URL}/wp-json/wp/v2/settings`);
// settings.timezone_string

// Datum entsprechend anpassen
const publishDate = new Date('2024-02-01T10:00:00');
const gmtDate = publishDate.toISOString();

try {
  const response = await fetch(url, options);

  if (!response.ok) {
    const error = await response.json();
    console.error('WP Error:', error.code, error.message);
    throw new Error(`WordPress API Error: ${error.message}`);
  }

  return response.json();
} catch (error) {
  // Retry-Logik oder Fallback
}

{
  "success": true,
  "post": {
    "id": 12345,
    "title": "Artikel-Titel",
    "slug": "artikel-slug",
    "status": "publish",
    "url": "https://example.com/artikel-slug",
    "date": "2024-01-15T10:00:00",
    "featured_image": {
      "id": 123,
      "url": "https://example.com/wp-content/uploads/..."
    },
    "categories": ["Marketing", "Content"],
    "tags": ["SEO", "Strategy"]
  },
  "seo": {
    "title": "SEO Title | Brand",
    "description": "Meta description...",
    "canonical": "https://example.com/artikel-slug"
  }
}

// Nach WordPress-Publish
await ctx.db.patch(articleId, {
  wordpressPostId: wpPost.id,
  wordpressUrl: wpPost.url,
  publishedAt: new Date().toISOString(),
  status: 'published'
});

// Convex Schema
export const articles = defineTable({
  // ...
  wordpressPostId: v.optional(v.number()),
  wordpressUrl: v.optional(v.string()),
  wordpressSyncedAt: v.optional(v.string()),
  wordpressSyncStatus: v.union(
    v.literal('pending'),
    v.literal('synced'),
    v.literal('error')
  )
});