go back Home

RowAuditLogTx

Sample XML

The following is only an example of what the XML should look like. The order of fields is not guaranteed and null fields are not included in returned data from the services.

<audit_log_tx company_id="..." id="..." application_id="..." change_date_time="..." change_date_time_utc="..." changed_values="..." primary_key_crc="..." primary_key_values="..." sql_statement="..." table_name="..." transaction_id="..." user_id="..."/>

Sample JSON

The following is only an example of what the JSON should look like. The order of fields is not guaranteed and null fields are not included in returned data from the services.

{"__type":"audit_log_tx","company_id":"...","id":"...","application_id":"...","change_date_time":"...","change_date_time_utc":"...","changed_values":"...","primary_key_crc":"...","primary_key_values":"...","sql_statement":"...","table_name":"...","transaction_id":"...","user_id":"..."}

Fields

key name size type
company_id 4 String
id 32 String
application_id 10 int
change_date_time 19 Date
change_date_time_utc 19 Date
changed_values -1 String
primary_key_crc 10 int
primary_key_values 220 String
sql_statement 250 String
table_name 30 String
transaction_id 10 int
user_id 10 String