> ## Documentation Index > Fetch the complete documentation index at: https://docs.agentsdr.ai/llms.txt > Use this file to discover all available pages before exploring further. # AI and HTTP columns > Prompt a model for every row in a table, or call any web API per row, using values from your other columns. Two column types cover what the enrichment providers don't. **Use AI** sends a prompt to a language model for each row. **HTTP API** calls any web endpoint for each row and stores part of the response. Both can read other columns in the same row with `{{column}}` tokens. ## Referencing other columns Wrap a column's key in double curly braces. A token that matches no column resolves to an empty value, so a missing first name becomes an empty string rather than a literal `{{firstName}}`. * In the AI prompt box, type `/` or `{{` to open a column picker. Pick a column and its key is inserted. Under the box the dialog lists each token and the column it points to, and warns about tokens that are not columns in this table because they would be sent blank. * In the HTTP column, tokens work in the URL, header values and request body. A column that reads other columns waits for them. With **Auto-run** on, it runs for a row once every column it references has a value. A table can't contain a loop where two columns depend on each other. ## Use AI columns ### Before you start AI columns run on your organization's own OpenRouter key (bring your own key). Connect OpenRouter and choose which models are allowed in [AI provider](/workspace/ai-provider). Until that's done the dialog shows "OpenRouter is not configured" and you can't save. Every AI column in an organization uses the connection chosen there. The model list in the dialog is the set of models you allowed, and models that don't support the chosen use case are filtered out. ### Add one Click **Actions**, then **Use AI**. **Web research** (the model can browse the internet), **Image generation**, or **Create or modify content** (most tasks, no internet access). Search the **Model** list. Your default model from AI provider is preselected when it fits the use case. Describe the task and insert columns, for example: `For the person with linkedin url {{linkedin_url}}, find their current job title.` The prompt is required. Choose **Fields** to name each result you want (and its type: Text, Number, Checkbox, Date, URL, Email, Image or JSON), or **JSON Schema** to paste a schema and get the whole answer in one column. Every field you define becomes its own column. Image models return one image into one image column. Show the model a few sample inputs and the response you expect. This pins down format and tone. Set **Auto-run**. Click **Save**, or **Save and run 10 rows** to test. ### How it runs * The prompt is filled in for each row. If every column it references is empty, the row is marked skipped and no model call is made. * For **Fields** output, every field is required in the model's JSON answer, so a missing value shows as empty rather than the key being absent. * The AI column itself shows **Completed** or **No result**. The answers are in the output columns it created. * If you edit the column later, output columns that already exist are reused by name so their data survives. A field you remove leaves its column in place. * Each cell has a timeout of 30 seconds by default (`GRID_CELL_TIMEOUT_MS` on self-hosted servers). Failures retry up to 3 attempts; see [Tables](/tables/overview). ### Cost Usage is billed by OpenRouter and your model providers on your own keys. AgentSDR doesn't compute a cost for AI columns. The figure shown in the dialog footer, such as "0 / row" for OpenRouter models, is only a display unit. Check your OpenRouter dashboard for real spend, and test on 10 rows first. An AI column that was created with an older, non-OpenRouter provider must be re-saved with an OpenRouter model and connection before it runs. ## HTTP API columns Use an HTTP column to call an API that has no built-in provider, or your own endpoint. Click **Actions**, then **HTTP API**. | Field | What it does | | - | - | | **Method** | GET, POST, PUT or PATCH. | | **URL** | Required. Tokens are allowed, for example `https://api.example.com/people/{{email}}`. Must be `http` or `https` after substitution. | | **Headers** | Name and value pairs. Values can use tokens. | | **Request body** | Shown for methods other than GET. Tokens are allowed. If you don't set a Content-Type, `application/json` is used. | | **Response path** | Optional dot path into a JSON response, such as `data.person.email`. Numbers pick array items, for example `results.0.email`. Leave it empty to store the whole response. | | **Credential env var** | The name of an environment variable that holds a secret. Only the name is stored. | | **Provider key** | An optional label recorded with each result. | | **Cost per call (cents)** | An optional flat cost you enter yourself. | Click **Save**, or **Save & run** to run it. ### Secrets: Credential env var Never paste an API key into a header. Put it in an environment variable on the server and type that variable's **name** into **Credential env var**, for example `MY_VENDOR_KEY`. When the column runs, AgentSDR reads the variable and sends it as `Authorization: Bearer `. If the value already starts with `Bearer ` it is sent as is. If you set your own `Authorization` header, yours is kept. If the variable isn't set on the server, the cell fails with "Environment variable ... is not set on this server" and isn't retried. The variable is read from the server's environment, not from your organization's saved integrations. On the hosted product you can only use variables the operator has set. When self-hosting, add the variable to your deployment (see [Configuration](/configuration)). Anyone who can create HTTP columns can reference any variable the server has, so only grant that access to people you trust. ### How results and errors behave * A response whose chosen path is empty counts as a miss, not an error. * A 4xx response, except 429, is treated as a configuration mistake and is **not** retried. A 5xx or 429 response and timeouts are retried up to 3 attempts in total. * Response bodies stored for debugging are cut at 16 KB. ## Related Connect OpenRouter and choose the allowed models. Built-in providers for emails, phones and company data. Runs, statuses and retries. Set environment variables when self-hosting. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.