# Insert/Upsert Method
## Overview
The **Insert** method in QueryDeck allows you to add new records to your database. The **Upsert** method is a combination of "update" and "insert," allowing you to either insert a new record or update an existing one if a conflict occurs. This ensures data consistency and prevents duplicate entries when using unique constraints.
With QueryDeckâs Insert/Upsert method, you can:
* Add new records to your database.
* Handle conflicts using the `on_conflict` clause.
* Update records if they already exist based on specified constraints.
## Using the Insert or Upsert query:
#### 1. Select the Base Table
* From the left pane in the demo app, choose a base table to use. For this example, we will use the `customers` table.
#### 2. Configure the Query Method
* In the left pane:
* Change the **Method** to `Insert` or `Upsert`.
* Update the **Route Name** if required.
#### 3. Save the Endpoint
* Click on the **Save** button at the bottom of the left pane.
* Your endpoint for `Insert/Upsert` is now ready.
## Testing
* Copy the endpoint URL by clicking it in the top right corner
* Open **Postman**:
* Paste the endpoint URL into the input field.
* Change the request method to `POST`.
#### Add a Sample Request Body
* Under the **Body** tab in Postman:
* Select **raw** as the body type.
* Paste a sample request body in JSON format. For example:
```
{
"customer": [
{
"store_id": 1,
"first_name": "Jared",
"last_name": "Ely",
"address_id": 530,
"active": 1,
"activebool": true,
"create_date": "2006-02-14T00:00:00.000Z",
"email": "jared.ely@sakilacustomer.org",
"last_update": "2013-05-26T14:49:45.738Z"
},
{
"store_id": 1,
"first_name": "Mary",
"last_name": "Smith",
"address_id": 5,
"active": 1,
"activebool": true,
"create_date": "2006-02-14T00:00:00.000Z",
"email": "mary.smith@sakilacustomer.org",
"last_update": "2013-05-26T14:49:45.738Z"
}
]
}
```
#### Send the Request
* Click on the **Send** button in Postman.
* You will receive a response indicating that the query was successful.
You have now successfully created and tested your `Insert/Upsert` query.
