Skip to content

Updating visuals

If you see any images containing outdated UI, please bear with us.

We are updating all content as quickly as possible to mirror our new UI.

Intro to the Data & API ​

WeWeb's native database & APIs helps you store data, manage users, and run secure server logic, without setting up a separate service. You'll create tables for your data, build views with filters and parameters, and expose API Endpoints that your app can call.

Understanding the backend ​

The Data & API tab is what is termed the 'backend'. The backend is different to the interface. In the backend, all logic and data is secure. Whereas, in the interface, any workflows and variables you have are not secure and are viewable/editable by malicious users.

This means you can utilize the backend to store private data and handle secure logic.

Core blocks ​

  • Tables — Define structured data (rows and columns). Learn more →
  • Views — Saved filters, sorts, and parameters over a table. Learn more →
  • API Endpoints — Secure, versioned workflows for database editing and third‑party APIs. Learn more →
  • Scheduled Tasks — Run backend workflows automatically, once at a specific time or on a recurring schedule. Learn more →
  • Authentication — Manage users and roles; enforce access on views and API Endpoints. Learn more →
  • AI Gateway — Generate text, images, or embeddings from backend workflows. Learn more →

Each block has its own subtab in the bar on the left of the Data & API tab. From top to bottom: Tables (tables and views), Backend Workflows (API Endpoints and the other backend workflows), Authentication, Storage, Scheduled Tasks, AI, Logs, and Integrations.

The Data and API tab with the bar of subtabs on the left, Tables selected

Creating a table ​

  1. Go to the Data & API tab, then open the Tables subtab
  2. Click Add Table, choose WeWeb Tables, enter a Name and an optional Description, then click Continue
  3. Define the columns of the table, such as a text or number column, with the + at the end of the column headers
The Data and API tab with the Tables subtab, the Add Table button and WeWeb Tables in the Select a data source windowThe plus button at the end of the column headers and the Add column panel

COLUMN TYPES AND SETTINGS

Columns have various available types and settings that you can configure. Understanding all these possible types and configurations allows you to build as efficiently and as scalably as possible.

Learn more about tables →

Adding data to the table ​

You can add records in two ways:

Inline in the editor ​

  • Double-click a cell to edit its value, or hover a row and click the pencil icon next to its checkbox to edit all its fields in Update Row
  • Tick the checkbox of several rows to delete them at once, with the delete button that replaces Insert
A row of the tasks table on hover, with the pencil icon next to its checkboxTwo rows of the tasks table ticked, and the Delete 2 rows button in place of Insert
  1. In the Data & API tab, open the Backend Workflows subtab, then open API Endpoints and create an API Endpoint.
  2. Add parameters in Parameters (optional) (for example, name, logoUrl, or a Table Link to auto‑map columns)
  3. Add the Insert rows action from the Tables folder, and map the parameters to the columns
  4. In Interface, call the API Endpoint from a workflow: click Add an action, go to From Data & API → API, then select your endpoint

SECURING DATA ACTIONS

It is critical to have a solid understanding of API Endpoints so you can ensure your data updates are both performative and secured.

Learn more about API Endpoints →

Fetching data from a table ​

You typically fetch data with a view or an API Endpoint:

Views for lists and UI binding ​

  1. Go to the Data & API tab, then open the Tables subtab, then select the table you want to use.
  2. At the top of the table, click New view.
  3. (Optional) Click Parameters and add things like search if you want your view to be filterable (for example, a search input in your interface).
  4. Set up what the view should return using Filter, Sort, and the access button (Public or Authenticated).
The My tasks view of the tasks table, with the New view tab and the Parameters, Filter, Sort and Authenticated buttons above the table

API Endpoint for custom logic ​

  1. In the Data & API tab, open the Backend Workflows subtab, then open API Endpoints and create an API Endpoint.
  2. Add the Get rows action from the Tables folder and choose your table. Then, in Filters & Sort: - Filter on id to fetch a single record - Or add your own filters to fetch matching records (optionally choose the Columns to return, a sort, and a Limit in Pagination)
  3. Return the resulting data with Send Response
  4. Call the API Endpoint from the interface and use the resulting data (such as saving it in a variable)

FILTERS, SORTS & PARAMETERS

Using views massively simplifies the process of retrieving exactly the data you need.

Learn more about views →

Practical examples ​

BUILD GUIDES

See full, practical examples of using tables, views, and API Endpoints.

See backend build guides →