Data Types

Column data types are used to define the output format of your data as well as add basic data validations (for number, boolean, and date). A data type can be set on a column by adding the data_type field. If not provided, the column will default to being a string. Currently data types are supported for templates configured via SDK or created with the API. Check out the docs for more details.

Data Types

• string (default)
• number
  
• date
• boolean
  

{
  "columns": [
    {
      "name": "First Name",
      "key": "first_name",
      "required": true,
      "description": "The first name of the user",
      "suggested_mappings": ["First", "Name"],
      "data_type": "string"
    },
    {
      "name": "Age",
      "data_type": "number"
    },
    {
      "name": "Joined On",
      "data_type": "date"
    },
    {
      "name": "Active",
      "data_type": "boolean"
    }
  ]
}

What's Next?

We'll be adding many more validation options over the coming weeks. If you have any feedback or ideas for which validators we should prioritize next, reach out through our GitHub repository or community Slack.