---
title: "Get products CSV column schema"
method: GET
path: "/products/csvSchema"
tags: ["Products", "PCS-11321"]
---

# Get products CSV column schema

`GET /products/csvSchema`

## Request

- Base URL: `https://api.pics.io`
- URL: `https://api.pics.io/products/csvSchema`
- Auth: HTTP bearer

Returns the canonical CSV column schema (locked system columns, media columns, built-in fields, and the team's custom attributes) used by both POST /products/exportCSV and POST /products/batchImport column mapping.

## Response `200`

Ok

- object
  - `version` number
  - `columns` object[]
    - `key` string
    - `label` string
    - `aliases` string[]
    - `scope` 'product' | 'variant' | 'shared'
    - `kind` 'system' | 'media' | 'builtin' | 'custom' | 'option'
    - `type` string
    - `part` 'value' | 'unit' | 'currency'
    - `attributeTitle` string
    - `locked` boolean
    - `cellBehaviors` string[]

---

[API](https://skmtc.dev/pics/apis/pics-io-rest-api.md) - [All operations](https://skmtc.dev/pics/apis/pics-io-rest-api/llms.txt) - [OpenAPI document](https://skmtc.dev/pics/apis/pics-io-rest-api/revisions/ea41cba5ac37?raw)