Select by Id

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