Function fetchLatestResponseTime

apps/sim/connectors/google-forms/google-forms.ts:292–325

* Reads the latest response submission time for change detection without * retaining responses. Scans every page — the Forms API does not guarantee * response order, so the newest submission may sit on any page. Returns the * greatest `lastSubmittedTime` (falling back to `createTime`), or undefin

(
  accessToken: string,
  formId: string
)

 * `skippedOnError` → `listingCapped`.
 */
async function fetchLatestResponseTime(
  accessToken: string,
  formId: string
): Promise<string | undefined> {
  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 read responses for change detection on form ${formId}: ${response.status}`
      )
    }

    const data = (await response.json()) as FormResponseList
    const pageLatest = latestResponseTime(data.responses ?? [])
    if (pageLatest && pageLatest > latest) latest = pageLatest
    pageToken = data.nextPageToken
  } while (pageToken)

  return latest || undefined
}

/**
 * Returns the greatest submission timestamp across the given responses, or