logologo
Get Started
Guide
Development
Plugins
API
English
简体中文
Get Started
Guide
Development
Plugins
API
English
简体中文
logologo
Overview

Data sources

Data source manager
Main data source

External data sources (Databases)

Overview
External MySQL
External MariaDB
External PostgreSQL
External MSSQL
External Oracle
Main vs External Databases
REST API data source
KingbaseES data source

Collections

Overview
General collection
Inheritance collection
File collection
Tree collection
Calendar collection
Comment collection
Expression collection
SQL collection
View collection

Collection fields

Overview
Field Validation

Basic

Single text
Long text
Phone
Email
URL
Integer
Number
Percent
Password
Color
Icon

Choices

Checkbox
Select
Multiple select
Radio group
Checkbox group

Media

Markdown
Markdown (Vditor)
Rich text
Attachment (Relationship)
Attachment (URL)

Date & Time

Overview
Date & time (with timezone)
Date & time (without timezone)
Unix timestamp
Date (without time)
Time

Geometry

Point
Line
Circle
Polygon

Advanced

Snowflake ID (53-bit)
UUID
Nano ID
Sort
Formula
Sequence
JSON
Collection select
Encryption

System info

Created at
Updated at
Created by
Last updated by
Space
Table OID

Associations

Overview
One to one
One to many
Many to one
Many to many
Many to many (array)

Development

Overview
Previous PageMain vs External Databases
Next PageKingbaseES data source

#REST API Data Source

This feature is provided by the commercial plugin «Data source: REST API», please purchase to use

#Introduction

This plugin allows you to integrate data from REST API sources seamlessly.

#Installation

This is a commercial plugin. For detailed activation instructions, please refer to: Commercial Plugin Activation Guide

#Adding a REST API Source

After activating the plugin, you can add a REST API source by selecting it from the Add new dropdown menu in the data source management section.

20240721171420

Configure the REST API source.

20240721171507

#Adding a Collection

In NocoBase, a RESTful resource is mapped to a Collection, such as a Users resource.

GET /users
POST /users
GET /users/1
PUT /users/1
DELETE /users/1

These API endpoints are mapped in NocoBase as follows:

GET /users:list
POST /users:create
POST /users:get?filterByTk=1
POST /users:update?filterByTk=1
POST /users:destroy?filterByTk=1

For a comprehensive guide on NocoBase API design specifications, refer to the API documentation.

20240716213344

Check the "NocoBase API - Core" chapter for detailed information.

20240716213258

The Collection configuration for a REST API data source includes the following:

#List

Map the interface for viewing a list of resources.

20251201162457

#Get

Map the interface for viewing resource details.

20251201162744

#Create

Map the interface for creating a resource.

20251201163000

#Update

Map the interface for updating a resource.

20251201163058

#Destroy

Map the interface for deleting a resource.

20251201163204

Both the List and Get interfaces are required to be configured.

#Debugging the API

#Request parameter integration

Example: Configure pagination parameters for the List API. If the third-party API does not support pagination natively, NocoBase will paginate based on the retrieved list data.

20251201163500

Please note that only variables added in the interface will take effect.

Third-party API params nameNocoBase params
page{{request.params.page}}
limit{{request.params.pageSize}}

You can click Try it out to debug and view the response.

20251201163635

#Response format transformation

The response format of the third-party API may not be in NocoBase standard, and it needs to be transformed before it can be correctly displayed on the front end.

20251201164529

Adjust the conversion rules based on the response format of the third-party API to ensure the output conforms to the NocoBase standard.

20251201164629

Debugging process description

20250418085020

#Extract error message

When a third-party API throws an exception, its response format may not follow NocoBase’s standard. In such cases, the error message needs to be transformed before it can be correctly displayed on the frontend.

20251201170545

If no error message transformer is configured, NocoBase will apply the default transformation, converting the error into a message that contains the HTTP status code.

20251201170732

After configuring an error message transformer to match NocoBase’s output standard, the frontend will be able to properly display the exception messages returned by the third-party API.

20251201170946 20251201171113

#Variables

The REST API data source supports three types of variables for API integration:

  • Custom data source variables
  • NocoBase request variables
  • Third-party response variables

#Custom Data Source Variables

20240716221937

20240716221858

#NocoBase Request

  • Params: URL query parameters (Search Params), which vary depending on the interface.
  • Headers: Custom request headers, primarily providing specific X- information from NocoBase.
  • Body: The request body.
  • Token: The API token for the current NocoBase request.

20251201164833

#Third-Party Responses

Currently, only the response body is available.

20251201164915

Below are the variables available for each interface:

#List

ParameterDescription
request.params.pageCurrent page
request.params.pageSizeNumber of items per page
request.params.filterFilter criteria (must meet NocoBase Filter format)
request.params.sortSorting criteria (must meet NocoBase Sort format)
request.params.appendsFields to load on demand, typically for association fields
request.params.fieldsFields to include (whitelist)
request.params.exceptFields to exclude (blacklist)

#Get

ParameterDescription
request.params.filterByTkRequired, typically the current record ID
request.params.filterFilter criteria (must meet NocoBase Filter format)
request.params.appendsFields to load on demand, typically for association fields
request.params.fieldsFields to include (whitelist)
request.params.exceptFields to exclude (blacklist)

#Create

ParameterDescription
request.params.whiteListWhitelist
request.params.blacklistBlacklist
request.bodyInitial data for creation

#Update

ParameterDescription
request.params.filterByTkRequired, typically the current record ID
request.params.filterFilter criteria (must meet NocoBase Filter format)
request.params.whiteListWhitelist
request.params.blacklistBlacklist
request.bodyData for update

#Destroy

ParameterDescription
request.params.filterByTkRequired, typically the current record ID
request.params.filterFilter criteria (must meet NocoBase Filter format)

#Field Configuration

Field metadata (Fields) is extracted from the CRUD interface data of the adapted resource to serve as the fields of the collection.

20250418085048

Extract field metadata.

20251201165133

Fields and preview.

20240716224403

Edit fields (similar to other data sources).

20240716224704

#Adding REST API Data Source Blocks

Once the collection is configured, you can add blocks to the interface.

20240716225120