Insert/Upsert Method

Follow these steps to create and test an 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.

4. Copy and Test the Endpoint

• 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.

  

5. 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": "[e-mail]",
      "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": "[e-mail]",
      "last_update": "2013-05-26T14:49:45.738Z"
    }
  ]
}

6. 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.