Noloco
Ask the CommunityHire an ExpertLoginSign up
  • Noloco Overview
  • 🚀Quickstart
    • Start with your data
    • Start with AI
    • Start with a template
  • Data to App
    • Database Consolidation
  • App Settings
  • Components
    • Containers
    • Video
  • Templates
  • 🔗Data Sources
    • Data Overview
      • Setting a Collection's Primary Field
      • Syncing
    • Noloco Tables
      • Field Types
      • Relationships
      • Automatic Links
      • Rollup Fields
      • Lookup Fields
      • Formulas
      • Noloco AI
      • Import a file
    • Airtable
    • Google Sheets
    • SmartSuite
    • MySQL
    • PostgreSQL
    • REST APIs
    • HubSpot
    • Xano
  • 📄Pages
    • Collection views
      • Show collection record count
      • Empty State
    • Blank pages
    • iFrame embeds
    • External links
    • The Home Page
    • User Profile Page
    • Parent pages & folders
    • Page visibility rules
    • Cloning pages
    • Renaming pages
    • Hiding pages
    • Sidebar dividers
    • Tabs
  • 📂Collections
    • Adding collection views
    • Display
      • Rows
      • Cards & columns
      • Tables
      • Kanban boards
      • Calendar
      • Timeline
      • Gantt
      • Split-view
      • Charts
      • Maps
      • Pivot Table
      • Single record view
      • Grouping records
      • Record Colors
    • Filters
      • Logged in user
      • Relative Filters
      • Record values
    • Filter fields
    • Sort & limit
    • Row Action
    • Column Summaries
  • 📝Forms
    • Forms
      • Customizing Form Fields
      • Passing Linked Record Values to a Form
      • Dynamic Form Field Filters
      • E-Signature Fields
    • Public Forms
  • 📃Record Pages
    • Overview
    • Visibility Settings
    • Hidden Field Values
    • Record Comments
  • ✏️Field Formatting
    • Field visibility conditions
    • In-line editing
    • Conditional Highlight Colors
    • Dates & Time Zones
  • 📊Charts
    • Overview
  • 📂Data Management
    • Export Data
    • Import Data
  • 👥Users & Permissions
    • User Table
    • User Management
    • User Roles & Permissions
      • Record-level permissions
      • Field-level permissions
    • Open Sign Up
    • Offboarding Users
    • Testing as other users
  • ⏩Actions
    • Action buttons
      • Create records
      • Update records
      • Bulk actions
      • Barcode Scanner
      • Add a Comment Action
  • ⚡Workflows
    • Workflows
      • On-demand workflows
      • Comment Added Trigger
      • Watched Fields
      • Trigger webhooks
      • Send automated emails
      • For each item in a list...do...
      • Only continue if
      • Create a Record Action
      • Update a Record Action
      • Delete a Record Action
      • Deactivate a User Action
      • Reactivate a User Action
      • Send an Invitation Email Action
      • Add a comment to a record
      • Send a Push Notification
      • Ask Chat GPT Action
      • Summarize Text Action
      • Correct Grammar Action
      • Extract Keywords Action
      • Analyze Sentiment
      • Finish Text Action
      • Send a message to a Slack Channel
      • Send a message to a Slack User
      • Generate a PDF with DocsAutomator
  • 🔔Notifications
    • Notifications
    • Notification Preferences
  • 📑API Documentation
    • API Overview
      • Fetching Records
      • Fetching a Record
      • Creating a Record
      • Update a Record
      • Deleting a record
  • ⚙️Settings
    • General Settings
      • Live Mode
      • Custom Logos
    • Theme & Design
    • Progressive web apps
    • Navigation Settings
    • Spaces
    • Email Settings
    • Custom Code
    • Custom Domain
    • Login & Signup
      • Sign in Options
      • Single Sign On
      • 2FA - Two Factor Authentication
      • Client Portal User Add-On
    • Login Screen
    • User Lists
    • Integrations & API Keys
    • Billing & Usage
    • Support
    • Publishing
      • App Version History
  • 🔄Integrations
    • Zapier
    • Make (Integromat)
    • Sign in With Google
    • Intercom
    • SMTP Emails
    • Documint
  • ⚙️Account
    • Workspaces
    • Pricing
      • Client Portal Add-on (Legacy)
    • Transferring an App
    • Onboarding Call Preparation
Powered by GitBook
On this page
  • Update an existing record with the API
  • Specifying the Record ID and Field Values
  • Choosing Response Fields
  • Conclusion
  1. API Documentation
  2. API Overview

Update a Record

Update a single record from the API

Updating existing records is a fundamental operation when maintaining your database's accuracy and relevance. Using Noloco's dynamic GraphQL API, you can seamlessly update entries through GraphQL mutations. This guide will walk you through the process of updating a record using the API.

Update an existing record with the API

To update an existing record, you'll employ a GraphQL mutation in the format mutation update<tableName>, where <tableName> stands for the name of the table containing the record you aim to update.

Examples:

  • For updating an existing project: mutation updateProjects.

  • For modifying a user's details: mutation updateUser.

Specifying the Record ID and Field Values

The primary distinction when updating, as opposed to creating, is that you must include the id argument, which represents the integer ID of the record you wish to update. This ensures you are modifying the correct record.

Additionally, only fields provided with a value will be updated. This behavior is called a "partial update" and ensures you don't overwrite fields unintentionally.

Example:

mutation {
  updateUser(id: 17, firstName: "John", lastName: "Doe") {
    id
    firstName
    lastName
    email
    age
  }
}

In this example, only the firstName and lastName fields of the user with ID 123 is being updated to "Jane" and "Doe". All other fields remain unchanged.

Choosing Response Fields

As with creating or fetching records, after updating, you can decide which fields and values you want to be returned in the response. This aids in verifying that the update operation was successful and reflects the intended changes.

Example:

mutation {
  updateProjects(id: 456, name: "Updated Project Title") {
    id
    name
    createdAt
  }
}

Post update, the response will display the id, name, and updatedAt fields, giving instant feedback about the modified record.

Conclusion

Noloco's dynamic GraphQL API ensures that updating records in your database is both intuitive and efficient. By using mutations tailored for updates and leveraging the ability to perform partial updates, you can ensure that your data remains current, consistent, and accurate without the risk of unintended changes.

PreviousCreating a RecordNextDeleting a record

Last updated 1 year ago

📑