Get Table Columns

Get columns from a specific table

GET /connections/{nameOrID}/columns

Get Table Columns

cURL

curl --request GET \
  --url https://use.hoop.dev/api/connections/{nameOrID}/columns

200

{
  "columns": [
    {
      "name": "<string>",
      "nullable": true,
      "type": "<string>"
    }
  ]
}

Path Parameters

nameOrID · string · required

Name or UUID of the connection

Query Parameters

database · string · required

Name of the database

table · string · required

Name of the table

schema · string

Name of the schema (optional - for PostgreSQL default is 'public', for others defaults to database name)

Response

200

application/json

OK

columns · object[]

The columns of a table

Show child attributes