API Reference Manual Examples

Browse categorized examples from the NocoDB API reference documentation to quickly access common scripting tasks and operations.

The following examples are discussed in API reference documentation and are indexed here for quick access.

🗃️ Base Operations

• Getting All Tables
• Checking for a Specific Table
• Working with Collaborators

📌 Cursor

• Checking the Context
• Bulk Update Script

📄 Table & Records

➕ Creating & Updating Records

• Creating and Updating Records

🔍 Querying & Filtering

• Querying and Filtering Records

📦 Bulk Processing

• Bulk Processing with Pagination

👁️ Views

• Using Views for Filtering
• Creating Interactive Reports Using Views

🏷️ Fields

• Getting a Field from a Table
• Creating a New Field
• Updating Field Options
• Working with Select Field Choices

📊 Record Query Results

• Paginated Processing
• Finding Records in the Result
• Grouping Records

📌 Record Operations

• Reading Record Data
• Comparing Records
• Working with Linked Records
• Using Record Values in Calculations
• Complex Record Processing

👤 Session

• Getting Current User Information

👥 Collaborator

• Finding a Specific Collaborator
• Checking if Current User Matches a Specific Collaborator

✏️ Input

• Form-Based Data Entry
• File Upload and Processing
• Interactive Record Selection and Update

📤 Output

• Creating a Structured Report

🌐 Fetch & External APIs

🔄 Fetching & Sending Data

• Fetching Data from a Public API
• Sending Data to a Webhook
• Integrating with Google Sheets API

🧾 Data Formats

• JSON Data
• Form Data

Related pages

• Find and Replace : Search and replace text patterns across records in any text-based field with preview and confirmation
• Convert Attachments to URLs : Convert attachment fields into comma-separated URL lists for integration with external services
• Randomize Values : Generate random data for empty fields across multiple data types with customizable ranges and constraints
• Validate Emails : Identify and list all invalid email addresses in email fields for data quality assurance
• Get Select Options : Extract and display all available options from Single Select or Multiple Select fields in various formats
• Save View Ordering to Field : Preserve manual record ordering from any view by saving it as sequential numbers in a numeric field
• Link Records by Field : Link records between two tables using matching field values, with pagination and summary reporting.
• Unique Field Values Summary : View unique values and their frequencies in any field, with summary and table output