Function getSpreadsheetWebUrl

apps/sim/tools/microsoft_excel/utils.ts:242–272

(
  spreadsheetId: string,
  accessToken: string,
  driveId?: string
)

 * unlike the Graph API URL which requires an access token.
 */
export async function getSpreadsheetWebUrl(
  spreadsheetId: string,
  accessToken: string,
  driveId?: string
): Promise<string> {
  const basePath = getItemBasePath(spreadsheetId, driveId)
  try {
    const response = await fetch(`${basePath}?$select=id,webUrl`, {
      headers: {
        Authorization: `Bearer ${accessToken}`,
      },
    })

    if (!response.ok) {
      logger.warn('Failed to fetch spreadsheet webUrl, using Graph API URL as fallback', {
        spreadsheetId,
        status: response.status,
      })
      return basePath
    }

    const data = await response.json()
    return data.webUrl || basePath
  } catch (error) {
    logger.warn('Error fetching spreadsheet webUrl, using Graph API URL as fallback', {
      spreadsheetId,
      error,
    })
    return basePath
  }
}