MSPBots WIKI : Halo Public Datasets
Here are the published or alpha version Halo datasets that you can use to create the widgets and dashboards.
In total, there are 40 publish/alpha Datasets
Name | Description | Created Date | Last updated | Fields |
---|---|---|---|---|
Halo Users - API | ODS Dataset which generated from Halo Users | Aug 17, 2022 | Aug 17, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "site_id", "site_name", "client_name", "first_name", "surname", "initials", "phonenumber_preferred", "sitephonenumber", "phonenumber", "telpref", "onpremise_activedirectory_dn", "inactive", "colour", "isimportantcontact", "neversendemails", "priority_id", "linked_agent_id", "isserviceaccount", "use", "client_id"] |
Halo Quotation - API | ODS Dataset which generated from Halo Quotation | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "use", "title", "ticket_id", "status", "po_ref", "date", "expiry_date", "revenue", "cost", "profit", "carriage_desc", "carriage_price", "auth_by", "note", "user_id", "user_name", "site_id", "site_name", "client_id", "client_name", "scope", "risk", "qr2filename", "agent_id", "include_group_editemprice", "include_group_editemqty", "daystodeliver", "currency", "currency_code", "currency_conversion_rate", "include_quotation_linenotes", "include_group_priceandqty", "approval_datetime", "approvalnote", "approvalstate", "pdftemplate_id", "quote_viewed", "canned_text_id", "canned_text_name", "last_update_time", "internal_approval_status", "internal_approvalagent", "internal_approval_email_address", "internal_approvalnote", "internal_approval_agent_id", "internal_approval_datetime", "datto_commerce_id", "datto_commerce_url"] |
Halo Report - API | ODS Dataset which generated from Halo Report | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "group_id", "group_name", "name", "description", "type", "datasource_id", "restrictaccess", "system_report_id", "canbe_accessed_by_allusers", "can_update"] |
Halo Site - API | ODS Dataset which generated from Halo Site | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "client_id", "client_name", "clientsite_name", "inactive", "sla_id", "phonenumber", "colour", "timezone", "invoice_address_isdelivery", "isstocklocation", "messagegroup_id", "use", "itglue_id"] |
Halo KBArticle - API | ODS Dataset which generated from Halo KBArticle | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "description", "view_count", "useful_count", "notuseful_count", "date_created", "date_edited", "tag_string", "inactive", "type", "next_review_date", "use"] |
Halo Projects - API | ODS Dataset which generated from Halo Projects | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "dateoccurred", "summary", "details", "status_id", "tickettype_id", "sla_id", "priority_id", "client_id", "client_name", "site_id", "site_name", "user_id", "user_name", "team", "agent_id", "category1", "category2", "category3", "category4", "estimate", "estimatedays", "parent_id", "child_count", "attachment_count", "flagged", "read", "enduserstatus", "onhold", "respondbydate", "fixbydate", "dateassigned", "excludefromsla", "slaholdtime", "site_timezone", "lastactiondate", "organisation_id", "department_id", "reportedby", "user_email", "emailtolist", "matched_kb_id", "release_id", "release2_id", "release3_id", "lastincomingemail", "workflow_id", "workflow_step", "is_vip", "isimportantcontact", "inactive", "impact", "urgency", "startdate", "starttime", "starttimeslot", "targetdate", "targettime", "targettimeslot", "deadlinedate", "oppvalueadjusted", "cost", "quantity", "projecttimeactual", "projectmoneyactual", "userdef1", "userdef2", "userdef3", "userdef4", "userdef5", "source", "release_important", "releasenotegroup_id", "supplier_status", "appointment_type", "section_timezone", "projectinternaltask", "use", "maximum_restricted_priority", "idsummary", "ticketage", "useful_count", "notuseful_count", "updateservicestatus", "servicestatusnote", "itil_requesttype_id", "closed_in_integration_system"] |
Halo Opportunities - API | ODS Dataset which generated from Halo Opportunities | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "dateoccurred", "summary", "details", "status_id", "tickettype_id", "sla_id", "priority_id", "client_id", "client_name", "site_id", "site_name", "user_id", "user_name", "team", "agent_id", "category1", "category2", "category3", "category4", "estimate", "estimatedays", "child_count", "attachment_count", "flagged", "read", "enduserstatus", "onhold", "respondbydate", "fixbydate", "dateassigned", "excludefromsla", "slaholdtime", "site_timezone", "lastactiondate", "organisation_id", "department_id", "reportedby", "user_email", "emailtolist", "matched_kb_id", "release_id", "release2_id", "release3_id", "lastincomingemail", "workflow_id", "workflow_step", "workflow_seq", "is_vip", "isimportantcontact", "inactive", "impact", "urgency", "starttime", "starttimeslot", "targetdate", "targettime", "targettimeslot", "deadlinedate", "oppcontactname", "oppcompanyname", "oppemailaddress", "opptel", "oppaddr1", "oppaddr2", "oppaddr3", "oppaddr4", "opppostcode", "opptype", "oppvalueadjusted", "opptimezonename", "cost", "quantity", "userdef1", "userdef2", "userdef3", "userdef4", "userdef5", "source", "release_important", "releasenotegroup_id", "supplier_status", "appointment_type", "section_timezone", "projectinternaltask", "use", "maximum_restricted_priority", "idsummary", "ticketage", "useful_count", "notuseful_count", "updateservicestatus", "servicestatusnote", "itil_requesttype_id", "ticket_tags"] |
Halo Clients - API | ODS Dataset which generated from Halo Clients | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "toplevel_id", "toplevel_name", "inactive", "colour", "confirmemail", "actionemail", "clearemail", "messagegroup_id", "override_org_logo", "override_org_name", "override_org_phone", "override_org_email", "override_org_website", "override_org_portalurl", "mailbox_override", "default_mailbox_id", "item_tax_code", "service_tax_code", "prepay_tax_code", "contract_tax_code", "pritech", "sectech", "accountmanagertech", "thirdpartynhdapiurl", "xeroid", "use", "xero_tenant_id", "accountsid", "gficlientid", "overridepdftemplateinvoice", "kashflow_tenant_id", "client_to_invoice", "invoiceduedaysextraclient", "itglue_id", "clientcurrency", "sentinel_subscription_id", "sentinel_workspace_name", "sentinel_resource_group_name", "default_currency_code", "client_to_invoice_recurring", "snow_id", "cautomateid", "dbc_company_id", "stopped", "customertype"] |
Halo Assets - API | ODS Dataset which generated from Halo Assets | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "inventory_number", "key_field", "key_field2", "key_field3", "client_id", "client_name", "site_id", "site_name", "business_owner_id", "business_owner_cab_id", "technical_owner_id", "technical_owner_cab_id", "assettype_id", "assettype_name", "colour", "icon", "inactive", "supplier_id", "supplier_contract_id", "supplier_sla_id", "supplier_priority_id", "itemstock_id", "item_id", "non_consignable", "reserved_salesorder_id", "reserved_salesorder_line_id", "use", "device_number", "status_id", "third_party_id", "automate_id", "ninjarmm_id", "syncroid", "itglue_url", "defaultsequence", "datto_alternate_id", "snow_id", "auvik_device_id", "auvik_url", "datto_id", "issue_consignment_line_id", "item_name"] |
Halo Attachment - API | ODS Dataset which generated from Halo Attachment | Aug 25, 2022 | Aug 25, 2022 | ["id", "tenant_code", "sync_time", "other_id", "filename", "datecreated", "note", "filesize", "type", "unique_id", "description", "isimage", "showforusers", "showonchild"] |
Halo Invoices - API | ODS Dataset which generated from Halo Invoices | Aug 25, 2022 | Aug 25, 2022 | ["id", "sync_time", "tenant_code", "other_id", "use", "client_id", "client_name", "sitenumber", "site_name", "uid", "invoicenumber", "thirdpartyinvoicenumber", "posted", "name", "address1", "address2", "address3", "address4", "address5", "invoice_date", "schedule_date", "dateposted", "last_synced", "last_modified", "notes_1", "cust_order_number", "salesorder_id", "datetype", "percent", "type", "contract_id", "contract_ref", "datesent", "currency", "currency_code", "currency_conversion_rate", "paymentterms", "hideinvoice", "ticket_id", "invoicetype", "datepaid", "paymentstatus", "xeroid", "amountpaid", "amountdue", "emailstatus", "address", "invoicevalue", "pdftemplate_id", "is_recurring_invoice", "recurring_invoice_id", "add_contract_assets", "add_labour", "add_project", "add_travel", "add_mileage", "add_itemsissued", "add_prepay", "add_salesorder", "qboid", "billingcategory", "xero_tenant_id", "xero_branding_theme_id", "xero_branding_theme_name", "due_date_int", "due_date_type", "internal_note", "kashflow_tenant_id", "kashflow_pdf", "original_client_id", "xero_status", "snelstart_id", "dbc_id", "dbc_company_id", "creditlinkedtoinvoiceid"] |
Halo Items - API | ODS Dataset which generated from Halo Items | Aug 25, 2022 | Aug 25, 2022 | ["id", "sync_time", "tenant_code", "other_id", "use", "name", "status", "assetgroup_id", "assetgroup_name", "note", "supplier_part_code", "description", "quantity_in_stock", "goodsinunit", "goodsoutunit", "inoutconversion", "baseprice", "supplier_name", "assettype_name", "secondprice", "promptforprice", "sleeveprice", "taxcode", "taxcodeother", "costprice", "accountsid", "margin", "costingmethod", "servicefee", "recovery", "avco", "doesnotneedconsigning", "shaccountsid", "applydiscount", "secondhandprice", "hours", "markupperc", "metertype", "meterlife", "isrecurringitem", "template_id", "recurringprice", "showmobilescanner", "third_party_id", "purchasenominalcode", "purchase_description", "salestaxincluded", "purchasetaxincluded", "taxable", "assetaccountcode", "qbo_quantity", "qboinitial_quantity_date", "xero_tenant_id", "income_account_name", "expense_account_name", "asset_account_name", "qbosku", "qbocategoryid", "qbocategoryname", "autotaskserviceid", "autotaskproductid", "iscontractitem", "dontinvoice", "kashflowid", "kashflow_tenant_id", "linked_item_id", "snelstart_id", "snelstart_department_id", "snelstart_department_name", "maxitemdiscount", "item_default_billing_period", "primaryimageid", "item_group_nominalcode", "item_group_nominalcode_purchase", "recurringcost", "dbc_company_id", "type"] |
Halo Contracts - API | ODS Dataset which generated from Halo Contracts | Aug 25, 2022 | Aug 25, 2022 | ["id", "sync_time", "tenant_code", "other_id", "client_id", "client_name", "ref", "refextra", "start_date", "end_date", "started", "expired", "numberofunitsfree", "billingperiod", "billingdescription", "status", "site_id", "site_name", "sla_id", "periodicinvoicenextdate", "next_invoice_date", "periodchargeamount", "refextra2", "contract_status", "contracttype", "contracttype_name", "cost_calculation", "active"] |
Halo Team - API | ODS Dataset which generated from Halo Team | Aug 26, 2022 | Aug 26, 2022 | ["id", "tenant_code", "other_id", "sync_time", "name", "sequence", "forrequests", "foropps", "forprojects", "ticket_count", "department_id", "department_name", "inactive", "override_column_id", "use"] |
Halo Actions | ODS Dataset which generated from Halo Actions | Aug 26, 2022 | Aug 26, 2022 | ["id", "tenant_code", "sync_time", "other_id", "ticket_id", "outcome", "who", "who_type", "who_imgpath", "who_agentid", "datetime", "note", "replied_to_ticket_id", "replied_to_action_id", "created_from_ticket_id", "created_from_action_id", "action_contract_id", "project_id", "outcome_id", "action_system_id", "timetaken", "timetakendays", "timetakenadjusted", "nonbill_time", "charge_rate", "travel_chargerate", "hidden_from_user", "important", "old_status", "new_status", "new_status_name", "colour", "attachment_count", "unread", "actionby_application_id", "personal_unread", "action_arrival_date", "action_completion_date"] |
Halo Agent - API | ODS Dataset which generated from Halo Agent | Aug 26, 2022 | Aug 26, 2022 | ["id", "tenant_code", "other_id", "sync_time", "name", "team", "is_agent", "isdisabled", "lastlogindate", "email", "ad", "initials", "firstname", "surname", "colour", "exchange_account", "use", "linemanager", "licence_type", "apptsync", "exchange_authorized", "sentinel_authorized", "teams", "departments"] |
Halo Status - API | ODS Dataset which generated from Halo Status | Aug 26, 2022 | Aug 26, 2022 | ["id", "tenant_code", "other_id", "sync_time", "name", "type", "colour", "sequence", "shortname", "slaaction", "ticket_count", "showonquickchange"] |
Halo Supplier - API | ODS Dataset which generated from Halo Supplier | Aug 26, 2022 | Aug 26, 2022 | ["id", "tenant_code", "other_id", "sync_time", "use", "name", "inactive", "toplevel_id", "contact_name", "phone_number", "email_address", "toplevel_name", "emailtemplate_id"] |
Halo Appointment - API | ODS Dataset which generated from Halo Appointment | Aug 26, 2022 | Aug 26, 2022 | ["id", "tenant_code", "other_id", "sync_time", "type", "allday", "colour", "entryid", "is_task", "subject", "user_id", "agent_id", "end_date", "attendees", "changekey", "organizer", "site_name", "canupdate", "agent_name", "is_private", "start_date", "client_name", "cancomplete", "reminder_shown", "complete_status", "recurringmaster", "online_meeting_url", "recurring_master_id", "appointment_type_name"] |
Halo Ticket Type - API | ODS Dataset which generated from Halo Ticket Type | Aug 26, 2022 | Aug 26, 2022 | ["id", "tenant_code", "other_id", "sync_time", "name", "use", "sequence", "default_sla", "group_id", "group_name", "jira_issue_type", "ticket_count", "cancreate", "agentscanselect", "itil_request_type", "allow_attachments", "copy_attachment_stochild", "is_sprint", "enduser_scan_select", "anonymou_scan_select", "kan_banstatus_choice"] |
Halo Tickets - API | ODS Dataset which generated from Halo Tickets | Aug 26, 2022 | Jan 04, 2023 | ["id", "tenant_code", "sync_time", "other_id", "dateoccurred", "summary", "details", "status_id", "tickettype_id", "sla_id", "priority_id", "client_id", "client_name", "site_id", "site_name", "user_id", "user_name", "team", "agent_id", "category1", "category2", "category3", "category4", "estimate", "estimatedays", "parent_id", "child_count", "attachment_count", "flagged", "read", "enduserstatus", "onhold", "respondbydate", "fixbydate", "dateassigned", "excludefromsla", "slaholdtime", "site_timezone", "lastactiondate", "organisation_id", "department_id", "reportedby", "user_email", "emailtolist", "matched_kb_id", "release_id", "release2_id", "release3_id", "lastincomingemail", "workflow_id", "workflow_step", "is_vip", "isimportantcontact", "inactive", "impact", "urgency", "startdate", "starttime", "starttimeslot", "targetdate", "targettime", "targettimeslot", "deadlinedate", "oppvalueadjusted", "cost", "quantity", "projecttimeactual", "projectmoneyactual", "userdef1", "userdef2", "userdef3", "userdef4", "userdef5", "source", "release_important", "releasenotegroup_id", "supplier_status", "appointment_type", "section_timezone", "projectinternaltask", "use", "maximum_restricted_priority", "idsummary", "ticketage", "useful_count", "notuseful_count", "updateservicestatus", "servicestatusnote", "itil_requesttype_id", "closed_in_integration_system", "responsedate", "responsestartdate", "slaresponsestate", "dateclosed", "slaactiondate", "slatimeleft", "nextactivitydate", "datecreated", "slastate", "satisfactionlevel", "satisfactioncomment", "whoresponded", "merged_into_id"] |
Halo Ticket Details | This dataset will show you all of the details for your tickets like type, status, age, etc on tickets where last action date is in the last 240 Days. | Dec 01, 2022 | Jan 15, 2024 | ["ticket_id", "ticket_number", "summary", "id_summary", "details", "status_name", "ticket_type", "agent_name", "agent_email", "last_action_by", "closed_by", "completed_by", "completed_date", "priority_id", "priority_name", "client_id", "client_name", "site_name", "department_id", "department_name", "user_name", "team", "category1", "category2", "category3", "category4", "parent_id", "merged_into_id", "flagged", "read", "date_occurred", "onhold", "respond_by_date", "fix_by_date", "time_to_resolution_min", "time_to_response_min", "date_assigned", "exclude_from_sla", "sla_hold_time", "last_action_date", "hours_taken", "responsedate", "dateclosed", "met_response", "met_resolution", "response_mins", "response_hrs", "resolution_mins", "resolution_hrs", "reported_by", "user_email", "last_incoming_email", "is_vip", "is_important_contact", "inactive", "impact", "urgency", "start_date", "target_date", "opp_value_adjusted", "cost", "quantity", "project_time_actual", "project_money_actual", "project_internal_task", "same_day_closed", "ticket_age_hours", "ticket_age_days", "age_days", "age_days_updated", "age_hours", "update_service_status", "service_status_note", "closed_in_integration_system", "deadline_date", "userdef1", "userdef2", "userdef3", "userdef4", "userdef5", "user_id", "resource_list", "appointment_start", "ticket_use", "tickettype_id", "create_range", "update_range", "createdby_id", "agent_id", "source_name", "mapped_company_name"] |
Halo Opportunity Data | Dataset showing data from all Opportunities linked to their revenue and product cost from quotations | Dec 01, 2022 | Jan 26, 2023 | ["id", "summary", "details", "dateoccurred", "client_id", "client_name", "status_id", "status", "tickettype_id", "ticket_type", "site_id", "site_name", "user_id", "user_name", "team", "department_name", "agent_id", "agent_name", "estimate", "attachment_count", "flagged", "read", "onhold", "respondbydate", "lastactiondate", "fixbydate", "date_closed", "age_days", "stale_days", "oppcontactname", "opptype", "idsummary", "urgency", "has_been_closed", "revenue", "cost", "profit"] |
Halo Project Summary | Dataset showing Halo Project details | Dec 02, 2022 | Dec 06, 2023 | ["project_id", "dateoccurred", "summary", "details", "status_id", "status", "tickettype_id", "ticket_type", "sla_id", "priority_id", "client_id", "client_name", "site_id", "site_name", "user_id", "user_name", "user_email", "team", "department_id", "department_name", "agent_id", "agent_name", "parent", "parent_flag", "child_count", "attachment_count", "flagged", "read", "onhold", "respondbydate", "fixbydate", "dateassigned", "excludefromsla", "reportedby", "startdate", "projecttimebudget", "targetdate", "actual_hours", "use", "idsummary", "age_days", "stale_days"] |
Halo Actions Details | Dataset with details regarding Halo actions and tickets | Dec 03, 2022 | May 08, 2023 | ["time_log_id", "ticket_id", "action_id", "ticket_type", "ticket_summary", "site", "ticket_use", "team", "client", "note", "notes_length", "who", "who_type", "who_agentid", "who_imgpath", "who_email", "department", "new_status", "old_status", "datetime", "outcome_id", "outcome", "action_arrival_date", "action_completion_date", "action_start_date", "replied_to_ticket_id", "replied_to_action_id", "created_from_action_id", "created_from_ticket_id", "time_taken_hrs", "time_taken_min", "time_taken_adjusted_hrs", "nonbill_time_hrs", "charge_rate", "unread", "actionby_application_id", "is_weekday", "hour_start", "hour_end", "ticket_parent", "non_business_hours"] |
Halo Invoice Data | Shows all of your invoice data | Dec 05, 2022 | Sep 08, 2023 | ["id", "sync_time", "tenant_code", "other_id", "use", "client_id", "client_name", "sitenumber", "site_name", "uid", "invoicenumber", "thirdpartyinvoicenumber", "posted", "name", "address1", "address2", "address3", "address4", "address5", "invoice_date", "schedule_date", "dateposted", "last_synced", "last_modified", "notes_1", "cust_order_number", "salesorder_id", "datetype", "percent", "type", "contract_id", "contract_ref", "datesent", "currency", "currency_code", "currency_conversion_rate", "paymentterms", "hideinvoice", "ticket_id", "invoicetype", "datepaid", "paymentstatus", "xeroid", "amountpaid", "amountdue", "emailstatus", "address", "invoicevalue", "pdftemplate_id", "is_recurring_invoice", "recurring_invoice_id", "add_contract_assets", "add_labour", "add_project", "add_travel", "add_mileage", "add_itemsissued", "add_prepay", "add_salesorder", "qboid", "billingcategory", "xero_tenant_id", "xero_branding_theme_id", "xero_branding_theme_name", "due_date_int", "due_date_type", "internal_note", "kashflow_tenant_id", "kashflow_pdf", "original_client_id", "xero_status", "snelstart_id", "dbc_id", "dbc_company_id", "creditlinkedtoinvoiceid", "duedate", "age_invoice", "age_invoice_status", "datepaid_f"] |
Halo Appointment Details | Dataset showing details on appointments | Dec 08, 2022 | Jan 15, 2024 | ["appointment_id", "subject", "appointment_type_name", "ticket_id", "start_date", "end_date", "agent_name", "agent_email", "is_private", "client_name", "complete_status", "recurring_master_id", "organizer", "organizer_name", "attendees", "online_meeting_url", "status", "recurringmaster", "is_task", "allday", "canupdate", "cancomplete", "reminder_shown", "entryid", "username"] |
Halo Contract Profitability Data | This dataset is for the Contract (also known as Agreement) Profitability Data. This dataset shows the detailed monthly price and cost from contracts. | Dec 15, 2022 | Jan 16, 2023 | ["month_year", "invoice_month", "client_name", "contract_name", "contract_id", "contract_type", "billing_period", "contract_start_date", "contract_end_date", "contract_status", "addition_price", "addition_cost", "service_price", "total_billed", "profit", "margin", "target_hours", "effective_rate", "contribution_rate", "labor_cost", "labor_hours", "service_cost", "total_cost"] |
Halo SlaHead | ODS Dataset which generated from Halo SlaHead | Dec 21, 2022 | Dec 21, 2022 | ["id", "tenant_code", "other_id", "sync_time", "name", "workday_id", "hours_are_techs_localtime", "respon_sereset", "autore_lease_option", "response_reset_approval", "auto_release_limit"] |
Halo Workdays - API | ODS Dataset which generated from Halo Workdays | Dec 22, 2022 | Dec 22, 2022 | ["id", "tenant_code", "other_id", "name", "summary", "timezone", "start", "ends", "incmonday", "inctuesday", "incwednesday", "incthursday", "incfriday", "incsaturday", "incsunday", "alldayssame", "endmonday", "endtuesday", "endwednesday", "endthursday", "endfriday", "endsaturday", "endsunday", "startmonday", "starttuesday", "startwednesday", "startthursday", "startfriday", "startsaturday", "startsunday", "sync_time"] |
Halo Charge Rate - API | ODS Dataset which generated from Halo Charge Rate | Jan 13, 2023 | Jan 13, 2023 | ["id", "tenant_code", "other_id", "sync_time", "area", "contract_id", "charge_id", "startdate", "rate", "org", "minimum", "increment", "oohmultiplier", "holidaymultiplier", "weekendmultiplier", "surcharge", "round", "useagentworkinghours", "use_budget_rate", "current_rate", "use_for_travel", "use_for_mileage", "travel_surchargeid", "contractmultiplier", "rateoverride", "override_surcharge"] |
Halo Billing Template - API | ODS Dataset which generated from Halo Billing Template | Jan 16, 2023 | Jan 16, 2023 | ["id", "tenant_code", "other_id", "sync_time", "name", "unmatchedcombinations", "billforrecurringprepayamount", "prepayrecurringcharge", "prepayrecurringhours", "prepayrecurringchargebp", "autotopupthreshhold", "autotopuptoamount", "autotopupcostperhour", "autotopupbyamount", "surchargeid", "numberofunitsfree", "prepayrecurringminimumdeduction", "prepayrecurringminimumdeductiononlyactive", "prepayrecurringautomaticdeduction"] |
Halo Invoice Items | Dataset showing items contributing to the total invoice amount of halo invoices | Jan 16, 2023 | Feb 16, 2023 | ["invoice_id", "other_id", "recurring_invoice_id", "client_name", "name", "item_code", "item_shortdescription", "item_longdescription", "qty_order", "unit_price", "net_amount", "tax_amount", "total_tax", "total_price", "total_discount", "total_net_total", "group_id", "invoice_date", "schedule_date", "paymentstatus", "datepaid", "datesent", "invoicevalue", "amountdue", "amountpaid"] |
Halo Journey - API | ODS Dataset which generated from Halo Journey | Apr 24, 2023 | Apr 24, 2023 | ["id", "tenant_code", "other_id", "unum", "faultid", "actionnumber", "description", "startdate", "enddate", "ihidmileage", "type", "sync_time"] |
Halo Budget Type - API | ODS Dataset which generated from Halo Budget Type | Jul 26, 2023 | Jul 26, 2023 | ["id", "tenant_code", "sync_time", "other_id", "name", "defaultrate"] |
Halo Team Agents - API | ODS Dataset which generated from Halo Team Agents | Aug 08, 2023 | Aug 08, 2023 | ["id", "tenant_code", "other_id", "sync_time", "agent_id", "agent_name", "team_id", "team_name", "department_id", "role_id", "role_name", "no_config_access", "is_manager", "unassigned_access", "otheragent_access", "fortickets", "foropps", "forprojects", "in_section", "namewithinactive"] |
Halo Feedback - API | ODS Dataset which generated from Halo Feedback | Aug 09, 2023 | Aug 09, 2023 | ["id", "tenant_code", "sync_time", "other_id", "ticket_id", "score", "date", "comment", "score_band"] |
Halo Feedback - API | ODS Dataset which generated from Halo Feedback | Aug 09, 2023 | Aug 09, 2023 | ["id", "tenant_code", "sync_time", "other_id", "ticket_id", "score", "date", "comment", "score_band"] |
Halo Feedback - Layered | This is a layered dataset wherein the main layer contains the clients scores and feedback to the agent in the last 14 days while the second layer contains the clients scores and feedback to the agent in the last 120 days. | Aug 22, 2023 | Jan 11, 2024 | ["tenant_code", "sync_time", "feedback_id", "ticket_id", "feedback_score", "feedback_date", "comment", "score_band", "client_name", "agent_name", "reportedby", "user_name", "mapped_company_name"] |
Halo Asset Details | This dataset displays a list of assets and their corresponding details. | Nov 17, 2023 | Dec 17, 2023 | ["id", "inventory_number", "key_field", "key_field2", "key_field3", "client_id", "client_name", "site_id", "site_name", "business_owner_id", "business_owner_cab_id", "technical_owner_id", "technical_owner_cab_id", "assettype_id", "assettype_name", "colour", "icon", "inactive", "supplier_id", "supplier_contract_id", "supplier_sla_id", "supplier_priority_id", "itemstock_id", "item_id", "non_consignable", "reserved_salesorder_id", "reserved_salesorder_line_id", "use", "device_number", "status_id", "third_party_id", "automate_id", "ninjarmm_id", "syncroid", "itglue_url", "defaultsequence", "datto_alternate_id", "snow_id", "auvik_device_id", "auvik_url", "datto_id", "issue_consignment_line_id", "item_name", "ticket_id", "warranty_end", "warranty_start", "labour_warranty_start", "labour_warranty_end", "asset_user", "processor", "ram_memory", "os_service_pack", "last_logged_in_user", "domain", "warranty_status"] |