Advanced Analytica Advanced Analytica: IBOM
← All connectors
Uptick logo

Source connector

Uptick

Set up Uptick as a source and move its data into your chosen destination.

Version 2.1.6 certified generally available

Uptick

Extract data from Uptick, a field service management platform for the fire protection industry.

Prerequisites

  • Your Uptick workspace URL in the form https://<workspace>.onuptick.com. The connector only connects to onuptick.com workspace hosts. Any other Base URL host fails the connection check for both authentication methods.
  • Credentials for one authentication method below. OAuth 2.0 is recommended. Username and password remains available for existing connections.

Enter the Base URL exactly as https://<workspace>.onuptick.com, using lowercase and no path. This method uses the OAuth 2.0 authorisation-code flow with PKCE. The connector requests only Uptick’s read-only read scope.

On Airbyte Cloud, enable Airbyte’s Uptick app in your Uptick account before authenticating. The Authenticate with Uptick button uses this app. If it isn’t enabled, ask your Uptick administrator to enable it. Enter your Base URL and choose Authenticate with Uptick under Authentication. Click Authenticate, then approve Uptick’s consent page. The connector stores the resulting tokens in your connection’s credentials block.

On self-hosted Airbyte (OSS), first create an OAuth application in Uptick under Control Panel > Uptick API > Create Application. Use your Airbyte instance’s redirect URI https://<airbyte-host>/auth_flow and the authorisation-code grant with PKCE (S256). Then enter your Base URL, choose Authenticate with Uptick and complete the flow.

Username and password

To authenticate, you need an OAuth application and an Uptick user account. The connector uses OAuth 2.0 with the password grant.

  • An OAuth Client ID and Client Secret generated from your Uptick instance.
  • An Uptick user’s email address and password. The connector signs in as this user. The account needs permission to view every resource you want to sync.

To generate OAuth credentials, go to Control Panel > Uptick API in your Uptick instance and select Create Application. Provide a name and save. Uptick generates the Client ID and Client Secret. For step-by-step instructions, see Uptick API - Getting started. Existing connections using the top-level client_id, client_secret, username and password fields continue working. On the first run after upgrading to 2.1.0, the connector copies them under Authentication (credentials). It then saves the migrated config. The original fields remain, so pinning back to 2.0.x continues working.

Your Uptick user account needs read access to each module you want to sync. In practice, task_profitability has required the Intelligence reports permission.

Setup guide

Set up Uptick in Airbyte

  1. In Airbyte, go to Sources and select + New source.
  2. Search for Uptick and select it as the source type.
  3. Enter your Base URL and choose an Authentication method. Then complete the fields from the configuration table below. For Authenticate with Uptick, click Authenticate and approve the consent page. For Username & password, complete client_id, client_secret, username and password. Consider creating a dedicated Uptick service user for the connector. The API token inherits that user’s permissions, keeping access limited to exactly what you sync.
  4. Select Set up source to test the connection.
InputTypeDescriptionDefault Value
base_urlstringRoot URL of your Uptick workspace, for example https://yourcompany.onuptick.com. Required for both authentication methods. The connector strips any scheme, path, or trailing slash and always connects over HTTPS. The host must be <workspace>.onuptick.com, or the connection check fails. For Authenticate with Uptick, enter the host in lowercase.
credentials.auth_typestringoauth2.0 for the OAuth flow, password for the legacy username and password method.
credentials.client_idstringOAuth Client ID generated from Control Panel > Uptick API. Filled automatically by the OAuth flow on Airbyte Cloud.
credentials.client_secretstringOAuth Client Secret generated from Control Panel > Uptick API. Filled automatically by the OAuth flow on Airbyte Cloud.
credentials.refresh_tokenstringRefresh token obtained by authenticating with Uptick. Required for oauth2.0; filled automatically by the OAuth flow.
credentials.usernamestringEmail address for an Uptick user account with API access. Required for password. Synced data is limited to what this user can see in Uptick.
credentials.passwordstringPassword for the Uptick user account. Required for password.
num_workersintegerNumber of concurrent requests. Higher values speed up syncs but increase the chance of Uptick rate limiting. Allowed range 1–10.3
max_requests_per_minuteintegerGlobal request budget shared by all streams and threads. Uptick publishes no numeric limit; 60 is a conservative default. Allowed range 1–600.60

Supported sync modes

Sync modeSupported
Full Refresh Sync✅
Incremental Sync✅

Every stream except majorservices supports full refresh and incremental sync using the updated cursor. majorservices has no updated timestamp, so it supports full refresh only. Among the JSON:API streams, only those marked ✅ in the Reports deletions column expose a deleted timestamp. For streams marked ❌, incremental sync retains destination rows after they’re deleted in Uptick. Use full refresh for those streams. task_profitability is a generated report without a deleted state, so you can safely sync it incrementally.

Supported streams

The Uptick connector syncs the following streams, grouped by functional area:

Core business entities

  • tasks - Work tasks and maintenance requests, including scheduling, priority and assignment details
  • taskcategories - Categories for organising tasks
  • tasksessions - Time-tracking entries for work performed on tasks
  • rounds - Work rounds for technician scheduling and route management
  • projects - Project management entities for larger initiatives
  • clients - Customer organisations and contact information
  • clientgroups - Client organisation groupings
  • clientcontacts - Contact people associated with clients
  • properties - Physical locations where work is performed
  • propertycontacts - Contact people associated with properties
  • contractors - External service providers and subcontractors
  • users - System users, including technicians and staff
  • servicegroups - Service categories for organising work types

Financial and billing

  • invoices - Customer invoices and billing information
  • invoicelineitems - Individual invoice line items
  • creditnotes - Credit notes for refunds and adjustments
  • creditnotelineitems - Credit note line items
  • billingcards - Billing card information for cost allocation
  • billingcontracts - Recurring billing contracts for ongoing services
  • billingcontractlineitems - Billing contract line items
  • costcentres - Cost centre assignments for financial tracking
  • task_profitability - Task profitability metrics and financial performance data

Purchasing and supply chain

  • purchaseorders - Purchase orders for materials and services
  • purchaseorderlineitems - Individual purchase order items
  • purchaseorderbills - Bills received for purchase orders
  • purchaseorderbilllineitems - Purchase order bill line items
  • purchaseorderdockets - Delivery dockets for purchase orders
  • suppliers - Vendor and supplier information
  • products - Product and materials catalogue

Asset management and inspections

  • assets - Physical assets requiring maintenance and inspection
  • assettypes - Asset type categories and specifications
  • assettypevariants - Asset type variants and configurations
  • routines - Scheduled maintenance and inspection routines
  • routineservices - Routine service configurations for properties and assets
  • routineservicelevels - Service level definitions for routine services
  • routineservicetypes - Routine service types and categories
  • routineserviceleveltypes - Service level type classifications
  • majorservices - Major service records for assets
  • servicetasks - Individual work activities on tasks
  • subtasks - Links programme maintenance routines to tasks
  • remarks - Issues, defects and observations recorded during inspections
  • remarkevents - Events and actions taken on remarks
  • promptquestions - Prompt questions asked while completing service reports
  • promptanswergroups - Prompt answer groupings by service task and section
  • promptanswers - Individual answers to prompt questions
  • appointments - Scheduled appointments for work and inspections

Quality and compliance

  • accreditations - Technician certifications and qualifications
  • accreditationtypes - Certification and accreditation types

Sales

  • servicequotes - Quotes for service work
  • servicequotefixedlineitems - Fixed-price line items in service quotes
  • servicequotedoandchargelineitems - Do-and-charge line items in service quotes
  • servicequoteproductlineitems - Product line items in service quotes
  • defectquotes - Quotes for remedial work on identified defects
  • defectquotelineitems - Line items in defect quotes

Organisation and location

  • branches - Business locations and organisational units

Stream details

Stream NamePrimary KeyPaginationSupports Full SyncSupports IncrementalReports deletions
tasksidDefaultPaginator✅✅✅
taskcategoriesidDefaultPaginator✅✅❌
clientsidDefaultPaginator✅✅❌
clientgroupsidDefaultPaginator✅✅❌
propertiesidDefaultPaginator✅✅❌
invoicesidDefaultPaginator✅✅❌
projectsidDefaultPaginator✅✅❌
servicequotesidDefaultPaginator✅✅❌
defectquotesidDefaultPaginator✅✅❌
suppliersidDefaultPaginator✅✅❌
purchaseordersidDefaultPaginator✅✅❌
purchaseorderlineitemsidDefaultPaginator✅✅❌
assetsidDefaultPaginator✅✅✅
routinesidDefaultPaginator✅✅❌
billingcardsidDefaultPaginator✅✅❌
purchaseorderbillsidDefaultPaginator✅✅❌
purchaseorderbilllineitemsidDefaultPaginator✅✅❌
purchaseorderdocketsidDefaultPaginator✅✅❌
invoicelineitemsidDefaultPaginator✅✅❌
usersidDefaultPaginator✅✅❌
servicegroupsidDefaultPaginator✅✅❌
costcentresidDefaultPaginator✅✅❌
accreditationtypesidDefaultPaginator✅✅❌
accreditationsidDefaultPaginator✅✅❌
branchesidDefaultPaginator✅✅❌
creditnotesidDefaultPaginator✅✅✅
creditnotelineitemsidDefaultPaginator✅✅✅
remarksidDefaultPaginator✅✅✅
assettypesidDefaultPaginator✅✅✅
assettypevariantsidDefaultPaginator✅✅✅
productsidDefaultPaginator✅✅✅
roundsidDefaultPaginator✅✅✅
tasksessionsidDefaultPaginator✅✅❌
contractorsidDefaultPaginator✅✅❌
appointmentsidDefaultPaginator✅✅❌
billingcontractsidDefaultPaginator✅✅❌
billingcontractlineitemsidDefaultPaginator✅✅❌
defectquotelineitemsidDefaultPaginator✅✅❌
servicequotefixedlineitemsidDefaultPaginator✅✅❌
servicequotedoandchargelineitemsidDefaultPaginator✅✅❌
servicequoteproductlineitemsidDefaultPaginator✅✅❌
remarkeventsidDefaultPaginator✅✅❌
routineservicesidDefaultPaginator✅✅❌
routineservicelevelsidDefaultPaginator✅✅❌
routineservicetypesidDefaultPaginator✅✅❌
routineserviceleveltypesidDefaultPaginator✅✅❌
servicetasksidDefaultPaginator✅✅✅
subtasksidDefaultPaginator✅✅✅
task_profitabilitytask_idDefaultPaginator✅✅n/a (generated report)
clientcontactsidDefaultPaginator✅✅❌
propertycontactsidDefaultPaginator✅✅❌
promptquestionsidDefaultPaginator✅✅✅
promptanswergroupsidDefaultPaginator✅✅❌
promptanswersidDefaultPaginator✅✅❌
majorservicesidDefaultPaginator✅❌ (no updated timestamp)n/a (full refresh only)

API versions and fields

Every stream except task_profitability reads a pinned Uptick endpoint under /api/v2.16/. The task_profitability stream reads the intelligence report at /api/v2/intelligencereports/profitability_by_task/. This resolves to the minor version that Uptick currently treats as the latest.

Each stream uses Uptick’s sparse fieldsets to request a fixed field list. You receive a curated subset of the endpoint’s available fields, rather than every field. Fields added later appear only after the connector is updated. Uptick keeps roughly three minor API versions live and retires the oldest. Connector releases moving to newer minor versions may add, rename or remove fields. The Uptick API patch notes list the changes in each version.

Attribute values

Uptick returns each record as a JSON:API object containing an attributes block. The connector copies every attribute unchanged to the record’s top level. It also keeps the original attributes object, relationships object and resource type. From version 2.1.2, every JSON:API stream declares attributes and relationships as nullable objects in its schema. Every stream except accreditationtypes, billingcontracts, billingcontractlineitems, products and promptquestions also declares type. Destinations that create typed columns therefore add these columns. Monetary and other decimal fields arrive as strings, preserving the precision Uptick sends, such as "10.00". The exception is servicequotes.product_subtotal, which Uptick returns as a JSON number. From version 2.0.0, the connector declares it as a number. Attributes returned by Uptick as null arrive as null in your destination. Uptick returns an empty string (""), rather than null, for unset email fields such as users.email and clients.contact_email. It also does this for tasks.workorder_url. Filter for both values when finding missing emails or URLs.

Before version 1.2.0, the connector passed each attribute through a template. This reformatted decimal strings, so "10.00" became "10.0", and converted null to the string "None". If you filter or join these fields downstream, check both representations in data synced before your upgrade.

Relationship fields

Uptick returns related records in a JSON:API relationships object. The connector flattens each relationship into a scalar <relationship>_id column. Examples include client_id on clientcontacts and property_id on propertycontacts. Use these columns to join streams in your destination.

Prompt data spans three streams. Uptick reworked its prompt model in API v2.15, so use these joins:

  • promptanswers.answergroup_id joins promptanswergroups.id, and promptanswers.question_id joins promptquestions.id.
  • promptanswergroups.servicetask_id and promptanswergroups.task_id link answer groups to the service task or task where the answers were recorded.
  • promptquestions.section_id and promptanswergroups.section_id reference Uptick prompt sections. The connector doesn’t sync prompt sections. You can’t resolve these IDs to section names using synced data alone.

Incremental sync

For supported streams, the connector uses each record’s updated timestamp as the incremental sync cursor. It uses the Uptick API’s updatedsince filter to fetch only records changed since the previous sync. Streams supporting full refresh only are read in full during every sync.

Before version 2.0.0, the servicegroups and accreditationtypes endpoints ignored the updatedsince filter. The connector therefore read both tables fully during every sync, then applied the cursor filter itself. Uptick now applies the filter to these endpoints. From version 2.0.0, incremental syncs for these streams fetch only changed rows.

The majorservices endpoint has no updated timestamp, so it has no cursor for incremental sync. From version 2.0.0, the connector offers this stream in full refresh mode only.

Airbyte’s UI still offers incremental sync for streams marked ❌ under Reports deletions. This is because the connector defines the updated cursor for every stream except majorservices. Don’t use incremental sync for those streams. Their Uptick endpoints don’t report deletions, so deleted Uptick records remain in your destination. Sync them with Full Refresh | Overwrite instead.

Data type map

Connector schema typeAirbyte type
stringstring
integerinteger
numbernumber
decimalstring (airbyte_type decimal)
booleanboolean
datestring (format date)
datetimestring (format date-time, airbyte_type timestamp_with_timezone)
objectobject
arrayarray

Limitations and troubleshooting

Permission errors (403)

The sync fails with HTTP 403: Uptick user lacks permission for the requested endpoint. if the Uptick user account lacks permission for an endpoint. Uptick doesn’t publish permissions for each endpoint. In production, this error has occurred on task_profitability and was resolved by granting the Intelligence reports permission. It has also occurred on billingcontractlineitems. The connector reports a configuration error instead of retrying. Grant the missing module permission in Uptick or deselect the stream.

403 Access denied … required licenses (FIELD, DESK, CONTRACTOR) after logging in during “Authenticate with Uptick”. The Uptick user you signed in with has no licence in that workspace. Ask your Uptick administrator to grant a licence, such as DESK, or use username/password authentication instead.

Authentication errors

Uptick rejects an incorrect username or password with invalid_grant. It rejects an incorrect client ID or client secret with invalid_client. The connector reports these as a configuration error without retrying: Refresh token was rejected by the OAuth provider (invalid, expired, or already used). Re-authenticate this source's credentials in its connection settings. Provider error: invalid_grant (or invalid_client). For connections using Authenticate with Uptick, re-authenticate to refresh the stored tokens. For username and password connections, check all four credential fields in the source configuration. Confirm that the OAuth application still exists under Control Panel > Uptick API.

Uptick access tokens can expire or be revoked during a long sync. If a stream request returns 401 mid-sync, the connector refreshes the token once and retries. If Uptick rejects the refresh, the sync fails with the same configuration error. This can happen if the password changes during the sync. If the retried request still returns 401, it fails with configuration error Refreshed OAuth access token is rejected by the API. Update the credentials and run the sync again.

Base URL errors

From version 2.1.2, the connection check rejects a Base URL whose host isn’t <workspace>.onuptick.com. This validation applies to both authentication methods and happens before any request is sent. The check returns a JSON schema validation error saying that the URL does not match the onuptick.com pattern. Earlier versions didn’t restrict the host for Username & password. Connections using that method with another host, such as a tunnel or localhost, now fail. Set the Base URL to your https://<workspace>.onuptick.com address.

Enter the host in lowercase. For Authenticate with Uptick, the host is also case-sensitive. A Base URL containing uppercase letters, such as https://MyCompany.onuptick.com, fails the check. The message contains base_url-must-be-https-workspace.onuptick.com, and the connector doesn’t send your OAuth credentials to that host.

A misspelled workspace name, such as https://typo.onuptick.com, passes this check. It then fails with a DNS or connection error.

Deleted records

Streams marked ❌ under Reports deletions in the table above don’t report deletions. Records deleted in Uptick therefore stay in your destination until you run a Full Refresh | Overwrite sync. Full Refresh | Append doesn’t remove rows. The 12 JSON:API streams marked ✅ expose a deleted timestamp on deleted records. task_profitability is a generated report and has no deleted state.

Rate limits

Uptick enforces rate limits and reasonable-use guidelines on its API, but doesn’t publish a numeric limit. Uptick states it can revoke API access without notice when applications violate these limits. Increase the connector’s request rate cautiously.

Every stream except task_profitability uses Uptick’s cursor pagination and requests 1,000 records per page. A stream therefore needs roughly one request per 1,000 records. With the default budget of 60 requests per minute, a sync reads about 60,000 records per minute across all streams.

Two settings control how quickly the connector reads from Uptick:

  • max_requests_per_minute sets one request budget shared by all streams and threads (allowed range 1–600). The default of 60 requests per minute is a conservative value chosen by Airbyte. It sets the throughput ceiling for the whole sync. Large workspaces with millions of records may sync more slowly than before version 1.3.0. If Uptick confirms your workspace can tolerate more traffic, increase this value. If Uptick returns HTTP 429 responses, reduce it.
  • num_workers sets how many requests run simultaneously. The default is 3, and the maximum is 10. Every request still counts against max_requests_per_minute. Adding workers only speeds up a sync when slow API responses prevent the connector from using its full per-minute budget.

When Uptick throttles a request and returns a Retry-After header, the connector waits for the indicated time before retrying. If the header specifies 30 minutes or longer, the connector doesn’t wait. Instead, it fails the stream with a rate-limit error. Without a Retry-After header, the connector backs off exponentially. It retries a failed request up to five times.

To reduce API usage, sync only the streams you need. Schedule syncs no more often than your reporting requires.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
2.1.62026-11-1091768Update dependencies
2.1.52026-11-0390817Update dependencies
2.1.42026-10-2790093Update dependencies
2.1.32026-10-2289668Promote connector to certified support level.
2.1.22026-10-2289616Request 1,000 records per page; declare attributes, relationships, type, invoicelineitems.subtotal, and properties.address.place_id in stream schemas; accept date-only cursor state; reject a Base URL outside onuptick.com on check; stop validating email fields and tasks.workorder_url as email and uri formats because Uptick returns "" when they’re unset; update the base image and vendor docs links
2.1.12026-10-2189505Reject an empty or whitespace-only base_url and remove unused legacy config fields
2.1.02026-10-2087436Add OAuth 2.0 authorization-code (PKCE) authentication with the read-only scope
2.0.12026-10-2089415Update dependencies
2.0.02026-10-1688925Upgrade the Uptick API to v2.16, correct the types of object and numeric fields, make majorservices full refresh only, filter servicegroups and accreditationtypes server-side, and add product_id to invoicelineitems
1.3.32026-10-1388821Update dependencies
1.3.22026-10-0688063Update dependencies
1.3.12026-09-2987373Update dependencies
1.3.02026-09-2886356Add a configurable request budget (default 60/min), refresh expired tokens mid-sync, and normalize base_url
1.2.12026-09-2286843Update dependencies
1.2.02026-09-2186363Emit attribute values verbatim and filter servicegroups and accreditationtypes incrementally
1.1.32026-09-1586280Update dependencies
1.1.22026-09-0885702Update dependencies
1.1.12026-08-1884790Update dependencies
1.1.02026-08-1283710Add 6 new streams (clientcontacts, propertycontacts, promptquestions, promptanswergroups, promptanswers, majorservices), add fields to the clients, properties, invoices, defectquotes, servicequotes, users, and purchaseorders streams, and make relationship field extraction null-safe
1.0.32026-08-1184162Update dependencies
1.0.22026-08-0483652Update dependencies
1.0.12026-07-2883098Update dependencies
1.0.02026-07-2173740Upgrade the Uptick API to v2.15 and remove deprecated fields from the branches, defectquotelineitems, servicetasks, and tasksessions streams
0.5.162026-07-2182628Update dependencies
0.5.152026-07-1481991Update dependencies
0.5.142026-06-3081268Update dependencies
0.5.132026-06-2380682Update dependencies
0.5.122026-06-1680076Update dependencies
0.5.112026-06-0979539Update dependencies
0.5.102026-06-0279025Update dependencies
0.5.92026-04-2877504Update dependencies
0.5.82026-04-2176809Update dependencies
0.5.72026-03-3175703Update dependencies
0.5.62026-03-1775044Update dependencies
0.5.52026-03-1074493Update dependencies
0.5.42026-02-2473926Update dependencies
0.5.32026-02-2372302Add fields to defectquotes and projects streams
0.5.22026-02-1773433Update dependencies
0.5.12026-02-1073007Update dependencies
0.5.02026-01-2271122Add invoice_id to invoicelineitems, and add 6 new streams: servicetasks, routineservices, routineservicelevels, routineservicetypes, routineserviceleveltypes, subtasks
0.4.32026-01-2072056Update dependencies
0.4.22026-01-1471437Update dependencies
0.4.12025-12-1870713Update dependencies
0.4.02025-12-1068194Remove expensive calculation fields from tasksessions, add more streams, including task profitability
0.3.92025-11-2570176Update dependencies
0.3.82025-11-1869684Update dependencies
0.3.72025-10-2968880Update dependencies
0.3.62025-10-2168365Update dependencies
0.3.52025-10-1767585Remove projectsectiontask and add more incremental sync streams
0.3.42025-10-1467855Update dependencies
0.3.32025-10-0767515Update dependencies
0.3.22025-10-0367020Remove start_date, include more task fields
0.3.12025-09-3066839Update dependencies
0.3.02025-09-2566410Add more streams
0.2.42025-09-2466598Update dependencies
0.2.32025-09-0965733Update dependencies
0.2.22025-09-0765534Add extra_fields to property stream
0.2.12025-08-2465445Update dependencies
0.2.02025-08-22Update task profitability stream to use start_date parameter
0.0.112025-08-2165061Add users and task profitability streams
0.0.102025-08-1564942Fix docker image entrypoint for platform syncs
0.0.92025-08-1464170adds cursor pagination, incremental sync and rate limiting
0.0.82025-08-1064845Update dependencies
0.0.72025-08-0264403Update dependencies
0.0.62025-07-2664055Update dependencies
0.0.52025-07-2063685Update dependencies
0.0.42025-07-1263165Update dependencies
0.0.32025-07-0562739Update dependencies
0.0.22025-06-2862220Update dependencies
0.0.12025-06-10Initial release by @sajarin via Connector Builder
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.