invantive documentation
Invantive Support ForumsLog In / Sign Up

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_code varchar2 itgen_freshdesk_action_code
bytes_retrieved int64 Bytes Retrieved
created_at datetime Created at
download_group_name varchar2 Download Group Name
download_uid guid Download UID
end_date_utc datetime End Date (UTC)
end_overall_date_last_updated_utc datetime End Overall Date Last Updated (UTC)
error_message varchar2 Error Message
first_date_last_updated_utc datetime First Date Last Updated (UTC)
first_ticket_id int64 First Ticket ID
from_cache char itgen_freshdesk_from_cache
last_date_last_updated_utc datetime Last Date Last Updated (UTC)
last_ticket_id int64 Last Ticket ID
max_date_last_updated_utc datetime Maximum Date Last Updated (UTC)
max_ticket_id int64 Maximum Ticket ID
min_date_last_updated_utc datetime Minimum Date Last Updated (UTC)
min_ticket_id int64 Minimum Ticket ID
page_number int32 Page Number
page_registration_date_utc datetime itgen_freshdesk_page_registration_date_utc
page_rows_added_count int64 itgen_freshdesk_page_rows_added_count
page_rows_count int64 #Rows on Page
page_rows_overwritten_count int64 itgen_freshdesk_page_rows_overwritten_count
pages_retrieved int32 Pages Retrieved
paging_code varchar2 itgen_freshdesk_paging_code
rows_retrieved int64 Rows Retrieved
start_date_utc datetime Start Date (UTC)
start_overall_date_last_updated_utc datetime Start Overall Date Last Updated (UTC)
success_flag char Success?
table_name varchar2 itgen_freshdesk_table_name
uid guid UID
updated_since_utc datetime Updated since (UTC)
url varchar2 URL

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: