REST API for Automatic System Time

In V12 and later, support for Automatic System Time is available in the REST API to automatically set time/date/timestamp fields at record creation or update.

A new property, autosystemtime, can be set in the field information in the table object at field creation time to specify this support. Below is an example of a JSON request with auto system time support (see last entry):

{
  "fields": [
    {
      "name": "custnumb",
      "type": "CHAR",
      "length": 4
    },
    {
      "name": "custzipc",
      "type": "CHAR",
      "length": 9
    },
    {
      "name": "custstat",
      "type": "CHAR",
      "length": 2
    },
    {
      "name": "custrtng",
      "type": "CHAR",
      "length": 1
    },
    {
      "name": "custname",
      "type": "VARCHAR",
      "length": 47
    },
    {
      "name": "custaddr",
      "type": "VARCHAR",
      "length": 47
    },
    {
      "name": "custcity",
      "type": "VARCHAR",
      "length": 47
    },
    {
      "name": "custtime",
      "type": "TIME",
      "autosystemtime":
 {
      "create": true
      }
    }
  ]
}

A new field property, autotimestamp, has been added to the table object to specify the support for autosystemtime assignment and the events (create and/or update) that trigger the assignment. Here is the OpenAPI specification:

Table
    description:
            Represents a single table.
    fields
            [
            minItems: 1
            {
                name*           string
                type*           string
                                Enum:
                                Array [ 21 ]
                length          integer
                scale           integer
                precision       integer
                autosystemtime  {
                                description:
                                        The field is automatically set with systemtime,
                                         create and update settings determine when the field
                                         is populated, at creation time or at update time.
                                create  boolean
                                update  boolean
                                }
        }]
}