invantive documentation
Invantive Support ForumsLog In / Sign Up

StatisticsIncremental: Freshservice Statistics on Incremental Tables

insert update delete

  • Catalog: Freshservice
  • Schema: Freshservice
  • 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 StatisticsIncremental 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_freshservice_action_code
bytes_retrieved int64 itgen_freshservice_bytes_retrieved
created_at datetime itgen_freshservice_created_at
download_group_name varchar2 itgen_freshservice_download_group_name
download_uid guid itgen_freshservice_download_uid
end_date_utc datetime itgen_freshservice_end_date_utc
end_overall_date_last_updated_utc datetime itgen_freshservice_end_overall_date_last_updated_utc
error_message varchar2 itgen_freshservice_error_message
first_date_last_updated_utc datetime itgen_freshservice_first_date_last_updated_utc
first_ticket_id int64 itgen_freshservice_first_ticket_id
from_cache char itgen_freshservice_from_cache
last_date_last_updated_utc datetime itgen_freshservice_last_date_last_updated_utc
last_ticket_id int64 itgen_freshservice_last_ticket_id
max_date_last_updated_utc datetime itgen_freshservice_max_date_last_updated_utc
max_ticket_id int64 itgen_freshservice_max_ticket_id
min_date_last_updated_utc datetime itgen_freshservice_min_date_last_updated_utc
min_ticket_id int64 itgen_freshservice_min_ticket_id
page_number int32 itgen_freshservice_page_number
page_registration_date_utc datetime itgen_freshservice_page_registration_date_utc
page_rows_added_count int64 itgen_freshservice_page_rows_added_count
page_rows_count int64 itgen_freshservice_page_rows_count
page_rows_overwritten_count int64 itgen_freshservice_page_rows_overwritten_count
pages_retrieved int32 itgen_freshservice_pages_retrieved
paging_code varchar2 itgen_freshservice_paging_code
rows_retrieved int64 itgen_freshservice_rows_retrieved
start_date_utc datetime itgen_freshservice_start_date_utc
start_overall_date_last_updated_utc datetime itgen_freshservice_start_overall_date_last_updated_utc
success_flag char itgen_freshservice_success_flag
table_name varchar2 itgen_freshservice_table_name
uid guid itgen_freshservice_uid
updated_since_utc datetime itgen_freshservice_updated_since_utc
url varchar2 itgen_freshservice_url

Release Notes

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