Xano Documentation
  • Welcome
  • Roadmap & Requests
  • Release notes
  • Known Issues
  • Onboarding Tutorial Reference
  • Frequently Asked Questions
  • 💡Start here
  • What is Xano?
  • What's included
    • Server Instance
    • Your Xano Workspace
      • Dashboard
      • Marketplace
      • Library
      • PostgreSQL Database
      • Settings
        • Environment Variables
      • API
      • Managing your Backend with 'Referenced By'
  • Technology
    • Docker
    • Kubernetes
    • PostgreSQL
  • What is a Backend?
  • Why have a separate Backend?
  • 🤔Fundamentals
    • Getting Started with Xano
    • The Development Life Cycle
    • Tutorial: From idea to App
      • Designing your database
      • Setting up your API
      • Working with external data
    • Connecting to a Frontend
      • Webflow
  • 🗄️ The Database
    • Database Basics
      • Database Tables
      • Table View
      • Adding Database Content
        • Generating Test Data
      • Database controls
      • Sharing
      • Best Practices
    • Field Types
      • Geography
      • Storage
      • Password Configuration
      • Vector Embeddings
    • Database Relationships
    • Data Sources
    • Triggers
    • Database Performance
      • Indexes
      • Maintenance
    • Database Storage
    • Database Views
    • Importing data
      • CSV File Import
      • Airtable Import
      • SQL / PostgreSQL
    • Exporting Data
    • Database Connector
  • 🔌The API
    • API Basics
      • API Groups
      • CRUD Operations
      • Creating an API Endpoint
      • Authenticated API Requests
      • Naming your API Endpoints
      • Move or Clone an API Endpoint
      • API Status Codes
    • No-Code API Builder
      • 1. Inputs
      • 2. Function Stack
      • 3. Response
      • Middleware
      • The Expression Builder
    • Editing & Publishing
    • Testing your API
    • Webhooks
    • Request History
    • Auto-Documentation
    • Branches & Merging
    • API Performance
      • Troubleshooting Performance
  • 🪄Working with data
    • The Basics
    • Variables
    • Data Types
      • Expressions
    • Dot Notation & Sub Path
    • Search
    • Functions
      • Database Requests
        • Query All Records
          • Filter Tab
          • Output Tab
          • External Tab
            • External Sorting
            • External Filtering
            • External Paging
        • Get Record
        • Has Record
        • Edit Record
        • Patch Record
        • Delete Record
        • Add Record
        • Add or Edit Record
        • Database Transaction
        • Clear All Records
        • Direct Database Query
        • Get Database Schema
        • Bulk Add Records
        • Bulk Update Records
        • Bulk Patch Records
        • Bulk Delete Records
        • Connecting to an External Database
      • Data Manipulation
        • Create Variable
        • Update Variable
        • Conditional
        • Loops
          • For Each Loop
          • For Loop
          • While Loop
          • Loop: Break
          • Loop: Continue
          • For Each Loop: Remove Entry
        • Math
        • Arrays
        • Objects
        • Text
      • Security
      • Data Caching
        • Caching Best Practices
        • Set a Cache Value
        • Get a Cache Value
        • Has a Cache Value
        • Delete Cache Value
        • Increment Cache Value
        • Decrement Cache Value
        • Get Cache Keys
        • Add to End of List
        • Add to Beginning of List
        • Remove From End of List
        • Remove From Beginning of List
        • Remove From List
        • Get Length of List
        • Get Elements From List
        • Rate Limit
      • Custom Functions
      • Utility Functions
      • Content Upload
        • Working with Zip Files
      • External API Request
    • Filters
      • Xano Transform Engine
      • Math Filters
      • Timestamp Filters
      • Array Filters
      • Conversion Filters
      • Text Filters
      • Security Filters
      • Manipulation Filters
        • Conditional Set Filters
      • Comparison Filters
      • Geo Filters
    • Addons (GraphQL-like)
      • List of Items
      • Single Item
      • Count
      • Existence
      • Aggregate
      • Customize the Response
    • Lambdas (JavaScript)
      • Higher Order Filters
      • Libraries & Functions
    • Cloud Storage
      • AWS OpenSearch
      • Elasticsearch
    • Date & Times
      • Timestamp Format Options
      • Relative Time Formats
      • Timestamp Filters
  • 🤝Team Collaboration
    • Real-time Collaboration
    • Agency Plan
      • Centralized Management
      • Client Invite
      • Transfer Ownership
      • Private Marketplace
      • Agency Profile
      • Commission
  • ⚒️ Building Backend Features
    • Realtime
      • Streaming Responses
      • Channel Permissions
      • Realtime Triggers
      • Realtime in your Function Stacks
      • Realtime with Webflow
    • Sign-up & Log in
      • Authentication
        • OAuth (Social Sign-In)
    • Restricting Access
    • Password Reset
    • Passwordless Auth (Magic Link)
    • Payments
    • Email Notifications
    • SMS
    • Location
    • Generating CSV Files
    • Separating Data
  • 🔀MIGRATING TO XANO
    • Adalo
    • Bubble
      • CSV Export / Import
      • Bubble Data API
      • Workflows
      • Connecting Bubble to Xano
      • Additional Resources
    • Airtable
  • 🚀Xano Features
    • Static IP (Outgoing)
    • Data Caching
    • Schema Versioning
    • Dynamic Image Transformation
    • Snippets (Share your API)
      • Create Snippets
      • Preview and Add a Snippet
      • Verified Snippets
    • Background Tasks (Cron Jobs)
    • File Management
    • Tagging
    • Connect
      • ncScale
    • Unit Tests
    • Workflow Testing
    • Actions
      • Building Actions
      • Projects
  • 📕HOW-to Guides
    • Full Build Tutorials
      • Creative Agency
      • Photo Sharing App
      • Two-sided Marketplace
    • Data Manipulation
      • Edit your Data/API Response
      • Deleting Data
        • Delete duplicate records
        • Deleting multiple records
        • Cascade delete
      • Conditionally Editing Fields
      • Getting last record of a Database Table
    • External APIs
      • Store an API Response in memory
    • Encryption
      • AES-256 Decryption
    • More Video Tutorials
      • Video Directory
  • ☁️ Your Xano Account
  • Help and Support
    • Granting Access
    • Community Code of Conduct
      • Content Modification Policy
  • Account Page
  • Billing
  • Upgrading an Instance
  • Release Track Preferences
  • Increasing Plan Limits
  • Adjust Server Performance
  • Custom Domain
  • Change Server Region
  • Manage Team
  • Bandwidth Usage
  • Time Synchronization
  • API Rate Limit
    • API Rate Limit with AppGyver
  • Developer API (deprecated)
  • Metadata API (beta)
    • Master Metadata API
    • Tables and Schema
    • Content
    • Search
    • File
    • Request History
    • Workspace Import and Export
  • Share Xano. Make money
  • 🏢Enterprise Features
    • Enterprise Plan
    • Microservice
      • unoconv (File Conversion)
    • Xano Link
    • Compliance Center
    • Permissions (RBAC)
    • Security Policy
  • 🔒Security and Compliance
    • Best Practices
    • SOC 2 Type 2 & SOC 3
    • GDPR
    • HIPAA
    • ISO 27001:2013
    • ISO 9001:2015
    • ISO 27701
    • PCI Compliance (ASV Network Scan)
    • Penetration Testing
    • Getting Answers to Security Questions
  • 💲Special Discount Pricing
    • Non Profits
    • Students
  • 🔨Troubleshooting
    • Backup and Restore
    • Statement Explorer
    • Clear Cache
    • Troubleshooting
      • Troubleshooting a Slow Response
      • Server Maintenance
      • Troubleshooting Errors
      • Memory Usage
    • Error Message Reference
    • Known Issues
Powered by GitBook
On this page

Was this helpful?

  1. 📕HOW-to Guides

Data Manipulation

Last updated 2 years ago

Edit your Data/API Response
Deleting Data
Conditionally Editing Fields
Getting last record of a Database Table