Function getItemBasePath

apps/sim/tools/microsoft_excel/utils.ts:132–152

(spreadsheetId: string, driveId?: string)

 * When driveId is omitted, uses /me/drive/items/{itemId} (personal OneDrive).
 */
export function getItemBasePath(spreadsheetId: string, driveId?: string): string {
  const spreadsheetValidation = validatePathSegment(spreadsheetId, {
    paramName: 'spreadsheetId',
    customPattern: GRAPH_ID_PATTERN,
  })
  if (!spreadsheetValidation.isValid) {
    throw new Error(spreadsheetValidation.error)
  }

  if (driveId) {
    const driveValidation = validatePathSegment(driveId, {
      paramName: 'driveId',
      customPattern: GRAPH_ID_PATTERN,
    })
    if (!driveValidation.isValid) {
      throw new Error(driveValidation.error)
    }
    return `https://graph.microsoft.com/v1.0/drives/${driveId}/items/${spreadsheetId}`
  }
  return `https://graph.microsoft.com/v1.0/me/drive/items/${spreadsheetId}`
}

/**
 * Resolves a worksheet name and cell address from either an explicit sheet name