statistics_incremental: Freshdesk Statistics on Incremental Tables
insert update delete
- Catalog:
Freshdesk - Schema:
Freshdesk - Primary Keys:
id - Label: Statistics on Incremental Tables
Can retrieve data and change data using insert, update and delete.
Summary
Tickets.
Table Columns
The columns of the table statistics_incremental are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
action_ |
varchar2 |
itgen_freshdesk_action_code | |||
bytes_ |
int64 |
Bytes Retrieved | |||
created_ |
datetime |
Created at | |||
download_ |
varchar2 |
Download Group Name | |||
download_ |
guid |
Download UID | |||
end_ |
datetime |
End Date (UTC) | |||
end_ |
datetime |
End Overall Date Last Updated (UTC) | |||
error_ |
varchar2 |
Error Message | |||
first_ |
datetime |
First Date Last Updated (UTC) | |||
first_ |
int64 |
First Ticket ID | |||
from_ |
char |
itgen_freshdesk_from_cache | |||
last_ |
datetime |
Last Date Last Updated (UTC) | |||
last_ |
int64 |
Last Ticket ID | |||
max_ |
datetime |
Maximum Date Last Updated (UTC) | |||
max_ |
int64 |
Maximum Ticket ID | |||
min_ |
datetime |
Minimum Date Last Updated (UTC) | |||
min_ |
int64 |
Minimum Ticket ID | |||
page_ |
int32 |
Page Number | |||
page_ |
datetime |
itgen_freshdesk_page_registration_date_utc | |||
page_ |
int64 |
itgen_freshdesk_page_rows_added_count | |||
page_ |
int64 |
#Rows on Page | |||
page_ |
int64 |
itgen_freshdesk_page_rows_overwritten_count | |||
pages_ |
int32 |
Pages Retrieved | |||
paging_ |
varchar2 |
itgen_freshdesk_paging_code | |||
rows_ |
int64 |
Rows Retrieved | |||
start_ |
datetime |
Start Date (UTC) | |||
start_ |
datetime |
Start Overall Date Last Updated (UTC) | |||
success_ |
char |
Success? | |||
table_ |
varchar2 |
itgen_freshdesk_table_name | |||
uid |
guid |
UID | |||
updated_ |
datetime |
Updated since (UTC) | |||
url |
varchar2 |
URL |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: