statistics_incremental: Freshdesk Statistics on Incremental Tables |
Catalogus: Freshdesk
Schema: Freshdesk
Primaire Sleutels: id
Label: Statistics on Incremental Tables
Documentatie:
Tickets.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Insert Freshdesk-API URL: /tickets
Update Freshdesk-API URL: /tickets
Delete Freshdesk-API URL: /tickets
Veldselectiemethode: NotRequired
Tabelkolommen
De kolommen van de tabel statistics_incremental worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
action_code |
string |
|
☐ |
|
bytes_retrieved |
int64 |
Bytes Retrieved |
☐ |
|
created_at |
datetime |
Created at |
☑ |
|
download_group_name |
string |
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 |
string |
Error Message |
☐ |
|
first_date_last_updated_utc |
datetime |
First Date Last Updated (UTC) |
☐ |
|
first_ticket_id |
int64 |
First Ticket ID |
☐ |
|
from_cache |
boolean |
|
☐ |
|
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 |
|
☐ |
|
page_rows_count |
int64 |
#Rows on Page |
☐ |
|
pages_retrieved |
int32 |
Pages Retrieved |
☐ |
|
paging_code |
string |
|
☐ |
|
rows_retrieved |
int32 |
Rows Retrieved |
☐ |
|
start_date_utc |
datetime |
Start Date (UTC) |
☐ |
|
start_overall_date_last_updated_utc |
datetime |
Start Overall Date Last Updated (UTC) |
☐ |
|
success_flag |
boolean |
Success? |
☐ |
|
table_name |
string |
|
☑ |
|
uid |
guid |
UID |
☐ |
|
updated_since_utc |
datetime |
Updated since (UTC) |
☐ |
|
url |
string |
URL |
☐ |
|
10-12-2022 17:06 Versie 22.0.461-PROD+3719