JSON Data Conventions

TrackTik's API features some common datatypes that can be learned without needing to refer to additional documentation. The following are the most common and useful to become familiar with:

Datatypes

Datatype

Context

Constraints

String

Title, ID, Label

255 characters

String

Description, Post, Memo

65535 characters

Boolean

All

true|false

Integers

ID

4 bytes, signed -2,147,483,648 to 2,147,483,648 (without commas)

Currency

Most

n…n.nn (padded)

Billing rates

Most

n…n.nn (unpadded)

Rates

Billing and payroll

n…n.nnnn1

Dates

All

yyyy-mm-dd

DateTimes

Most

yyyy-mm-dd hh:mm:ss
24h format

DateTimes with Timezones

Most

yyyy-mm-ddThh:mm:dd+hh:mm
T is literal, +hh:mm is an offset

Empty Fields

Most

null
Literal text “null”

1 CCC CNS has 4 digits of precision for their fuel reimbursement rate

Formatting

Field

Context

Behaviour

Text

Symbol characters

Special characters are escaped with the \ character.
E.g.

"\"Escaping text.\" - normal quotes

Text

International characters

No change.
E.g.

Caractères français

Text

Carriage returns /
Line Feeds

Guarding Suite and Guard Tour interpret \r\n as carriage return and line feed pairs.
E.g.

line 1\r\nline2

Text

Curly quotes

Preserved as entered

 

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more