Function fetchFormResponses

apps/sim/connectors/google-forms/google-forms.ts:242–279

* Fetches form responses, retaining up to `MAX_RESPONSES_PER_FORM` for rendering. * Every page is scanned for the latest submission timestamp even after the * render cap is reached — the Forms API does not guarantee response order, so * the newest submission may sit on any page. `fetchLatestRespo

(accessToken: string, formId: string)

 * the listing and getDocument paths regardless of form size.
 */
async function fetchFormResponses(accessToken: string, formId: string): Promise<FetchedResponses> {
  const collected: FormResponse[] = []
  let latest = ''
  let pageToken: string | undefined

  do {
    const url = new URL(`${FORMS_API_BASE}/forms/${encodeURIComponent(formId)}/responses`)
    url.searchParams.set('pageSize', String(RESPONSES_PAGE_SIZE))
    if (pageToken) url.searchParams.set('pageToken', pageToken)

    const response = await fetchWithRetry(url.toString(), {
      method: 'GET',
      headers: {
        Authorization: `Bearer ${accessToken}`,
        Accept: 'application/json',
      },
    })

    if (!response.ok) {
      throw new Error(`Failed to list responses for form ${formId}: ${response.status}`)
    }

    const data = (await response.json()) as FormResponseList
    const responses = data.responses ?? []

    const pageLatest = latestResponseTime(responses)
    if (pageLatest && pageLatest > latest) latest = pageLatest

    for (const r of responses) {
      if (collected.length >= MAX_RESPONSES_PER_FORM) break
      collected.push(r)
    }

    pageToken = data.nextPageToken
  } while (pageToken)

  return { responses: collected, latestSubmittedTime: latest || undefined }
}

/**
 * Reads the latest response submission time for change detection without