industry-department-solutions
latest
false
- Overview
- API Resources
- Data Types
Supply Chain & Retail Solutions API guide
Last updated Apr 16, 2026
Data Types
The Data Ingestion API supports the following data types when specifying the schema of the data being sent. For a full breakdown of the required request payload and which data types apply to each field, see:
- Markdown & Promotions, modules in Merchandising
- Quote Pricing, a module in Commercial Pricing
- Inventory Management
| Data Type | Description | Extra Requirements |
|---|---|---|
string | Text/string values (Limit for redshift: 65535, for snowflake it's same as Warehouse) | None |
integer | Whole number values | None |
boolean | True/false values | None |
float | Floating-point numbers | Requires precision and scale |
numeric | Precise decimal numbers | Requires precision and scale |
date | Date values (no time component) | Requires timestampFormat validation with format: "YYYY-MM-DD" |
timestamp | Date + time values | Requires timestampFormat validation with a supported timestamp format |
Data Type Categories
| Category | Types | Additional Required Fields |
|---|---|---|
| Basic Types | string, integer, boolean, json | None beyond standard validations |
| Numeric Types | float, numeric | precision (number), scale (number) |
| Date/Time Types | date, timestamp | timestampFormat validation with format field |