Request
|
ID #
|
Required
|
Description
|
User
|
X
|
ID of the user that edited the record
|
TableID
|
X
|
Table ID #
|
TableFieldOID
|
X
|
Record OID column in the table
|
TableFieldID
|
|
Table field ID #
Comments:
•If a blank field is entered, the value will be edited to empty •If there is a table field that has not had its ID # entered in the request, its value will remain the same |
TableFieldValue
|
|
Table field value
Notes according to the field type:
•Number: numeric digits without thousand or decimal separators •Decimal: numeric digits without thousand separator and with dot (.) as decimal separator •Date: YYYY-MM-DD •Hour: HH:MM •Boolean: 0 or 1 |
TableFileFieldID
|
|
ID # of the file type field of the table
|
FileName
|
|
File name (including its extension)
|
FileContent
|
|
Binary content of the file
|
RelationshipID
|
|
Relationship ID #
|
RelationshipFieldID
|
|
Related table field ID #
|
RelationshipFieldValue
|
|
Related table field value
Notes according to the field type:
•Number: numeric digits without thousand or decimal separators •Decimal: numeric digits without thousand separator and with dot (.) as decimal separator •Date: YYYY-MM-DD •Hour: HH:MM •Boolean: 0 or 1 |