Tulip supports several different data types across the platform. These types are important to understand as they can have implications in how you store data, usability within Analytics, and how you convert between data types.
List of data types
The table below provides information about each data type including descriptions and supported areas, as well as any specific formats or limits.
| Type | Description | Format | Limits | Area Supported |
|---|---|---|---|---|
| Boolean | True or false | True, false, yes, no | Analytics, app variables, connector functions, machine activity fields, machine attributes, table fields | |
| Color | Color values that can be used to set widget coloring dynamically | rgb(0, 0, 0), rgba(0, 0, 0, 0), #FFFF00 |
App variables, machine activity fields, table fields | |
| Datetime | Timestamp consisting of a date, time, and timestamp | MM/DD/YYYY HH:MM:SS See also: custom datetime formats |
Analytics, app variables, connector functions, machine activity fields, table fields | |
| Enum | Selection of predefined constants (i.e. Machine States) | Analytics, machine downtime, reasons, machine states | ||
| File | Link to a file, stored on cloud provider | csv, doc, docx, gif, jpeg, mp4, nc, pdf, png, qif, stl, stp, svg, txt, xlsx, xls | Max file size: 200MB (mp4), 50MB (others) Max URL length: 2048 characters |
App variables, table fields |
| Image URL | Link to an image in Tulip, stored by cloud provider | png, jpeg, gif, svg | Max file size: 20MB Max URL length: 2048 characters |
App variables, table fields, connector functions, machine activity fields |
| Integer | Integer - a number without a fractional component | 1, 6780, 43 | Max value: 9007199254740991 |
Analytics, App Variables, Connector Functions, Machine Activity Fields, Machine Attributes, Table Columns |
| Interval | Amount of time in seconds, displayed as HH:MM:SS |
120059 | Max value: 7730941132799 seconds |
Analytics, app variables, machine activity fields, table fields |
| Linked Record | Logical link between two Tables | Table fields | ||
| Machine | Machine object in Tulip from the machine library | Analytics, app variables, table fields | ||
| Number | Real numbers, including trailing zeros | 1, 7.4, 8.005, 419.38910 | Max value: 9007199254740991 |
Analytics, app variables, connector functions, machine activity fields, machine attributes, table fields |
| Object | Configurable object structure with child attributes | App variables, connector functions | ||
| Station | Station object in Tulip from the Shop Floor | Analytics, app variables | ||
| Text | Sequence of characters | Max size: 2.5kB (Tulip tables), 50kB (others) Truncated to 600 characters for analytics |
Analytics, app variables, connector functions, machine activity fields, machine attributes, table fields | |
| User | User object in Tulip from account / workspace settings | Analytics, app variables, table fields, machine activity fields | ||
| Video | Link to a video in Tulip, stored by cloud provider | mp4 | Max size: 200MB Max URL length: 2048 characters |
Table fields |
Arrays
In several areas of the platform, you can toggle these data types to display as a list. This list represents an Array - a collection of elements matching a particular data type. Below is an overview of where to assess lists:
-
App Variables
-
Connector Outputs
- For SQL connectors, check Return Multiple Rows - this format the output as an array.
- For HTTP connectors, select the output data type and toggle List.
-
Linked Records
- For one-to-many, many-to-one, and many-to-many, multiple linked records are stored as a list of linked records.
Did you find what you were looking for?
You can also head to community.tulip.co to post your question or see if others have faced a similar question!
