import {z} from 'zod' export type GetApiImportAnalyzeArgs = {attachmentUrl: string, fileType: 'csv' | 'excel'}; export type GetApiImportAnalyzeOptions = {baseUrl?: string | undefined, bearerAuth?: string | undefined, fetch?: typeof fetch | undefined}; export const getApiImportAnalyzeResponse = z.object({worksheets: z.record(z.string(), z.object({name: z.string(), columns: z.array(z.object({type: z.enum(["singleLineText", "longText", "user", "attachment", "checkbox", "multipleSelect", "singleSelect", "date", "number", "rating", "formula", "rollup", "conditionalRollup", "link", "createdTime", "lastModifiedTime", "createdBy", "lastModifiedBy", "autoNumber", "button"]), name: z.string()}))}))}); export const validateResponse = async ( schema: { readonly '~standard': { readonly validate: (value: unknown) => ({ readonly value: Output; readonly issues?: undefined } | { readonly issues: ReadonlyArray<{ readonly message: string; readonly path?: ReadonlyArray | undefined }> }) | Promise<{ readonly value: Output; readonly issues?: undefined } | { readonly issues: ReadonlyArray<{ readonly message: string; readonly path?: ReadonlyArray | undefined }> }> } }, value: unknown ): Promise => { const result = await schema['~standard'].validate(value) if (result.issues !== undefined) { const detail = result.issues .map(({ message, path }) => path?.length ? `${path.map((segment) => String(typeof segment === 'object' ? segment.key : segment)).join('.')}: ${message}` : message ) .join('; ') throw new Error(`Response does not match the schema: ${detail}`, { cause: { issues: result.issues } }) } return result.value }; /** * Get a column info from analyze sheet * * GET /import/analyze */ export const getApiImportAnalyze = async (args: GetApiImportAnalyzeArgs, options?: GetApiImportAnalyzeOptions) => { const {baseUrl = "https://app.teable.ai/api", fetch: fetchFn = fetch, bearerAuth} = options ?? {} const query = new URLSearchParams() const headers = new Headers() headers.set('accept', "application/json") if (args.attachmentUrl != null) query.append("attachmentUrl", String(args.attachmentUrl)) if (args.fileType != null) query.append("fileType", String(args.fileType)) if (bearerAuth !== undefined) headers.set('authorization', `Bearer ${bearerAuth}`) const url = `${baseUrl.replace(/\/+$/, '')}/import/analyze${query.size > 0 ? `?${query}` : ''}` const res = await fetchFn(url, {method: "GET", headers}) if (!res.ok) throw new Error(`Request failed with status ${res.status}`, {cause: {status: res.status, body: await res.text()}}) return validateResponse(getApiImportAnalyzeResponse, await res.json()) };