Select

• To get specific columns in response, the user will provide a 'select' param.

URL

• Schema based API url

  /api/schema/user-path/instance/database/table?select=first_name,last_name
  

• schemaless API url

  /api/gen/user-path/instance/database/table?select=first_name,last_name
  

• Got only first_name, last_name, and primary key fields in the response.

{
    "data": [
        {
            "customer_id": 1,
            "first_name": "Bob",
            "last_name": "Lin"
        },
        {
            "customer_id": 2,
            "first_name": "Alice",
            "last_name": "Page"
        },
        {
            "customer_id": 3,
            "first_name": "Mallory",
            "last_name": "Brown"
        },
        {
            "customer_id": 4,
            "first_name": "Eve",
            "last_name": "Mathly"
        },
        {
            "customer_id": 5,
            "first_name": "Eve",
            "last_name": "Page"
        }
    ]   
}

Negative value

• Use '-' before the column name and remove that column from the response.

/api/gen/user-path/instance/database/table?select=-first_name