Querydeck Docs
  • 👋Welcome to Query Deck
  • Getting Started
    • 😃Get Started With QueryDeck
      • Quickstart With QueryDeck
    • How It Works?
  • REST
    • Select Method
      • Joins
      • Sorting
        • Ascending/ Descending ordering
        • Dynamic Sorting
      • Filter
        • Dynamic Filtering
        • Groups
        • Exists clause
      • Pagination
        • Offset
        • Limit
    • Insert/Upsert Method
      • Nested Inserts (Joins)
      • Conflicting Columns
    • Update Method
      • Filters
    • Delete Method
    • Authentication
    • Authorization
    • Select by Id
  • GraphQL
    • Introduction to GraphQL in QueryDeck
    • Enabling GraphQL for Columns in QueryDeck
  • Testing Endpoints
Powered by GitBook
On this page
  • Overview
  • Creating a select by ID Query
  • Testing the endpoint URL
  1. REST

Select by Id

PreviousAuthorizationNextIntroduction to GraphQL in QueryDeck

Last updated 3 months ago

Overview

Selecting records by ID is a common operation when you want to retrieve specific rows based on their unique identifier. QueryDeck provides a straightforward way to implement this via the "select by id" method.

Creating a select by ID Query

Create a new API and you will see the following template page

Choose the desired table you would like to work on

Then choose the method as "select by id"

click on the save button on the top right to save the API changes made

Testing the endpoint URL

Then click on the endpoint URL to copy it from the top right region

Open postman and paste the url in the input bar

Replace :customer_id with the customer id you want to display

Hit send to send the request

You should obtain the corresponding response displaying the row with customer_id = 12