industry-department-solutions
latest
false
- Overview
- API Resources
- Data Types
Supply Chain & Retail Solutions API guide
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 same as the warehouse default) | None |
integer | Whole number values | None |
boolean | True/false values | None |
float | Floating-point numbers | None — precision and scale are not accepted for float and will be rejected at schema save |
numeric | Precise decimal numbers | Requires precision (1–38) and scale (0–37) |
json | Arbitrary JSON values — stored as Snowflake VARIANT / Redshift SUPER | None |
date | Date values (no time component) | Requires a timestampFormat validation with format: "YYYY-MM-DD" |
timestamp | Date + time values | Requires a timestampFormat validation with format: "YYYY-MM-DD HH:MI:SS" or format: "YYYY-MM-DD HH:MI:SS ±hh:mm" |
Data Type Categories
| Category | Types | Additional Required Fields |
|---|---|---|
| Basic Types | string, integer, boolean, float, json | None beyond standard validations |
| Numeric Types | numeric | precision (number), scale (number) |
| Date/Time Types | date, timestamp | timestampFormat validation with format field |