Date and time format
Grand Central stores date/time values without time zone offsets. Automatically captured dates are stored in UTC, while user-specified dates are stored in the financial institution’s time zone. For date and time values, Grand Central’s connectors use the ISO 8601 standard. Values are returned in theyyyy-MM-dd'T'HH:mm:ssZ format, for example: 2023-10-26T00:00:00+0000. For data parameters without a time code, the short version of the ISO 8601 standard is used: yyyy-MM-dd.
Phone number format
Different core systems accept phone numbers in different formats. Grand Central standardizes the phone number format it accepts and provides. It is responsible for converting the uniform phone number format to the specific format required by each core system. This table describes the value formats that Grand Central uses and provides examples:| Value | Standardized format | Regex pattern | Example |
|---|---|---|---|
number | A string consisting of only numeric characters. | [0-9]+ | 1234567890 |
countryCode | A string consisting of + as the first character, followed by numeric characters. | \+[0-9]+ | +91 |