Function patchView

apps/web/src/scripts/posthog/audit-microdollar-usage.ts:140–166

(view: DataWarehouseSavedQuery)

}

async function patchView(view: DataWarehouseSavedQuery): Promise<void> {
  if (!view.query) return;

  const updatedQuery = {
    ...view.query,
    query: view.query.query.replace(SEARCH_REGEX, REPLACEMENT_TERM),
  };

  const url = `${POSTHOG_API_BASE}/api/environments/${PROJECT_ID}/warehouse_saved_queries/${view.id}`;
  console.log(`\n🔄 Patching view "${view.name}" (ID: ${view.id})`);
  console.log(`   URL: ${url}`);
  console.log(`   History ID: ${view.latest_history_id}`);
  console.log(`   Old query: ${view.query.query}`);
  console.log(`   New query: ${updatedQuery.query}`);

  const response = await fetchWithAuth(url, {
    method: 'PATCH',
    body: JSON.stringify({
      query: updatedQuery,
      edited_history_id: view.latest_history_id,
    }),
  });

  const result = await response.json();
  console.log(`✅ Successfully patched view "${view.name}"`);
  console.log(`   Response:`, JSON.stringify(result, null, 2));
}

async function patchInsight(insight: Insight): Promise<void> {
  const updatedQuery = replaceInQuery(insight.query);