---
agentTools:
  projectIndex: https://gigasheet.readme.io/llms.txt
---

# Get Columns

Get column details for a sheet, including column IDs

# OpenAPI definition

```json
{
  "openapi": "3.0.0",
  "info": {
    "description": "Gigasheet - The Big Data Cloud Spreadsheet",
    "title": "Gigasheet API",
    "termsOfService": "https://gigasheet.com/terms-of-use",
    "contact": {
      "name": "Gigasheet Support",
      "url": "https://gigasheet.freshdesk.com/support/home",
      "email": "support@gigasheet.com"
    },
    "version": "1.0"
  },
  "paths": {
    "/dataset/{handle}/columns": {
      "get": {
        "security": [
          {
            "ApiKeyAuth": []
          }
        ],
        "description": "Get column details for a sheet, including column IDs",
        "tags": [
          "data"
        ],
        "summary": "Get Columns",
        "parameters": [
          {
            "description": "file handle",
            "name": "handle",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string"
            }
          },
          {
            "description": "if true, return hidden columns in the output",
            "name": "showHidden",
            "in": "query",
            "schema": {
              "type": "string"
            }
          },
          {
            "description": "if set, filter to only include columns with this data type",
            "name": "type",
            "in": "query",
            "schema": {
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {}
              }
            }
          },
          "400": {
            "description": "Bad Request",
            "content": {
              "application/json": {
                "schema": {}
              }
            }
          },
          "401": {
            "description": "Unauthorized",
            "content": {
              "application/json": {
                "schema": {}
              }
            }
          },
          "403": {
            "description": "Forbidden",
            "content": {
              "application/json": {
                "schema": {}
              }
            }
          },
          "500": {
            "description": "Internal Server Error",
            "content": {
              "application/json": {
                "schema": {}
              }
            }
          }
        }
      }
    }
  },
  "servers": [
    {
      "url": "//api.gigasheet.com"
    }
  ],
  "components": {
    "securitySchemes": {
      "ApiKeyAuth": {
        "description": "API key authentication for Gigasheet, contact support@gigasheet.com for instructions",
        "type": "apiKey",
        "name": "X-GIGASHEET-TOKEN",
        "in": "header"
      }
    }
  },
  "x-readme": {
    "explorer-enabled": true,
    "proxy-enabled": true
  },
  "_id": {
    "buffer": {
      "0": 99,
      "1": 106,
      "2": 153,
      "3": 247,
      "4": 195,
      "5": 218,
      "6": 27,
      "7": 0,
      "8": 15,
      "9": 88,
      "10": 245,
      "11": 236
    }
  }
}
```