The modern link attribution platform. Loved by world-class engineering teams at Twilio, Zillow, Jobber, Vercel, Raycast, and more.
TypeScript clickhousemysqlnextjsopen-sourceplanetscaleprismatailwindcsstinybirdtypescriptupstashvercel
"use server";
import { anthropic } from "@ai-sdk/anthropic";
import { createStreamableValue } from "@ai-sdk/rsc";
import { Output, streamText } from "ai";
import * as z from "zod/v4";
export async function generateCsvMapping(
fieldColumns: string[],
firstRows: Record<string, string>[],
) {
const stream = createStreamableValue();
(async () => {
const { partialOutputStream } = streamText({
model: anthropic("claude-sonnet-4-6"),
output: Output.object({
schema: z.object({
link: z
.string()
.optional()
.describe("The shortlink (link), including the domain and path."),
url: z.string().optional().describe("The full URL of the shortlink"),
title: z.string().optional().describe("The title of the shortlink"),
description: z
.string()
.optional()
.describe("The description of the shortlink"),
tags: z
.string()
.optional()
.describe(
"A comma-separated list of tags for shortlink organization (NOT to be mapped to a description).",
),
createdAt: z
.string()
.optional()
.describe(
"The date and time the shortlink was created (createdAt)",
),
}),
}),
prompt:
`The following columns are the headings from a CSV import file for importing a company's short links. ` +
`Map these column names to the correct fields in our database (link, url, title, description, tags, createdAt) by providing the matching column name for each field.` +
`You may also consult the first few rows of data to help you make the mapping, but you are mapping the columns, not the values. ` +
`If you are not sure or there is no matching column, omit the value.\n\n` +
`Columns:\n${fieldColumns.join(",")}\n\n` +
`First few rows of data:\n` +
firstRows.map((row) => JSON.stringify(row)).join("\n"),
temperature: 0.2,
});
for await (const partialObject of partialOutputStream) {
stream.update(partialObject);
}
stream.done();
})();
return { object: stream.value };
}