Function fetchOrganizationSubscription

apps/sim/hooks/queries/organization.ts:208–236

* Fetch organization subscription data

(orgId: string, _signal?: AbortSignal)

 * Fetch organization subscription data
 */
async function fetchOrganizationSubscription(orgId: string, _signal?: AbortSignal) {
  if (!orgId) {
    return null
  }

  const response = await client.subscription.list({
    query: { referenceId: orgId },
  })

  if (response.error) {
    logger.error('Error fetching organization subscription', { error: response.error })
    return null
  }

  // Any paid subscription attached to the org counts as its active sub.
  // Priority: Enterprise > Team > Pro (matches `getHighestPrioritySubscription`).
  // This intentionally includes `pro_*` plans that have been transferred
  // to the org — they are pooled org-scoped subscriptions.
  const rawSubscriptions: unknown = response.data
  const entitled = (Array.isArray(rawSubscriptions) ? rawSubscriptions : [])
    .filter(isOrganizationSubscriptionCandidate)
    .filter((sub) => hasPaidSubscriptionStatus(sub.status) && isPaid(sub.plan))
  const enterpriseSubscription = entitled.find((sub) => isEnterprise(sub.plan))
  const teamSubscription = entitled.find((sub) => isTeam(sub.plan))
  const proSubscription = entitled.find((sub) => !isEnterprise(sub.plan) && !isTeam(sub.plan))
  const activeSubscription = enterpriseSubscription || teamSubscription || proSubscription

  return activeSubscription || null
}

/**
 * Hook to fetch organization subscription