Home Tables Add an HTTP Column

Add an HTTP Column

Last updated on May 13, 2026

Add an HTTP Column

This article explains how to add an HTTP Column to a table, call any external API endpoint, and map the response to output columns.

What an HTTP Column does

An HTTP Column lets you call any REST API endpoint from within a TexAu table. You define the URL, HTTP method, headers, and body. TexAu sends the request for each row and maps the JSON response to your output columns.

Use an HTTP Column when you want to connect to a tool that is not in the TexAu action library, or when you need to build a custom API call with specific logic.

Before you begin

You need:

  • The API endpoint URL you want to call

  • The authentication method (API key in header, bearer token, basic auth, or none)

  • The request parameters or body structure the API expects

  • A TexAu account on a plan that includes HTTP Columns (check Settings > Billing if you are unsure)

Add an HTTP Column

  1. Open a table.

  2. Click the + icon at the right end of the column header row.

  3. Select HTTP Column from the column type list.

  4. The HTTP Column configuration panel opens.

Configure the request

Set the URL

  1. Click the URL field.

  2. Enter the full API endpoint URL.

To include a value from another column in the URL, type {{ and select the column from the autocomplete list. For example:

https://api.example.com/contacts/{{contact_id}}

Set the HTTP method

Click the Method dropdown and select GET, POST, PUT, PATCH, or DELETE.

Add headers

Headers are required for most APIs (authentication, content type, etc.).

  1. Click Add header.

  2. Enter the header name in the first field (e.g., Authorization).

  3. Enter the header value in the second field (e.g., Bearer {{api_key}}).

  4. Repeat for each header you need.

To reference a value from a column in a header, type {{ and select the column name.

Add a request body (POST, PUT, PATCH only)

  1. Click the Body tab.

  2. Select the body format: JSON or Form data.

  3. For JSON: Enter the JSON structure in the text editor. Use {{column_name}} placeholders to inject column values.

Example body:

{
  "email": "{{email_column}}",
  "firstName": "{{first_name_column}}"
}

Add query parameters (GET only)

  1. Click Add parameter.

  2. Enter the parameter name and value.

Use {{column_name}} to pull values from columns.

Map the response to output columns

After configuring the request, click Test request. TexAu sends a sample request and displays the JSON response.

  1. In the Output mapping section, click Add output field.

  2. Enter the field name (this becomes the column name in your table).

  3. Enter the JSON path for the value in the response. For example: $.data.email or $.results[0].name.

  4. Repeat for each field you want to capture.

Handle pagination (optional)

If the API returns paginated results:

  1. Open the Pagination tab.

  2. Select the pagination type: Offset/limit, Page number, or Cursor.

  3. Configure the pagination parameters based on the API's documentation.

  4. Set a Max results limit to control how many rows are created.

Save the column

Click Save column. The column appears in your table.

Test with a single row

Before running enrichment on all rows:

  1. Right-click a single row.

  2. Select Run this row.

  3. Check the result in the output columns.

Adjust the configuration if the response does not populate as expected.

Run enrichment

  1. Click Run enrichment in the top toolbar.

  2. Select which rows to run.

  3. Click Run.

Troubleshooting

The test request returns a 401 error.
Your authentication is incorrect. Check that the Authorization header value is valid. If you are using an API key, verify the key is active in the external system.

The test request returns a 404 error.
The URL is incorrect. Check the endpoint URL against the API documentation. Verify that any column placeholders in the URL are resolving to valid values.

The response is received but output columns are empty.
The JSON path you entered does not match the actual response structure. Use the Test request panel to view the raw response and trace the correct path to the field you need.

The column fails on some rows but not others.
The value being injected from a column is empty or malformed for the failing rows. Add a condition on the column so it only runs when the input is not empty.

The API rate limit is exceeded.
TexAu sends one request per row at the speed the API allows. If the API enforces a rate limit, contact TexAu support to configure a request delay for your HTTP Column.