Everhour

Everhour is a powerful time-tracking software with hassle-free integrations. It is an easy and accurate time tracker for budgeting, client invoicing, and painless payroll.

Data integration: Skyvia supports importing data to and from Everhour, exporting Everhour data to CSV files, and replicating Everhour data to relational databases.

Backup: Skyvia Backup does not support Everhour.

Query: Skyvia Query supports Everhour.

Establishing Connection

To create a connection to Everhour, you need to enter your API Token.

Getting Credentials

To locate the API Token, perform the following steps:

  1. Sign in to Everhour.
  2. Click Settings in the left menu.
  3. Click My Profile.
  4. Copy your Api Token under the Application Access section.

    Everhour API Token

Creating Connection

To create a connection, insert the obtained API Token into the corresponding box in the Connection Editor.

Connection Editor window

Connector Specifics

Object Peculiarities

Invoices

When performing the Insert operation to the Invoice object, in addition to the client_id field, at least one more field from the available ones must be mapped.

DML Operations Support

Operation Object
INSERT, UPDATE, DELETE Expenses, ExpensesCategories, Invoices, Projects, ProjectSections, ProjectTasks, Schedule, TimeRecords
INSERT, UPDATE Clients

Incremental Replication and Synchronization

Skyvia supports Replication with Incremental Updates for such Everhour objects: Clients, InvoiceItems, Invoices, ProjectTasks, Schedule, TimeRecords, and Users.

Skyvia does not support Synchronization for Everhour.

Stored Procedures

Part of the Everhour functionality is implemented in Skyvia as stored procedures:

  • call UpdateClientBudget(:client_id, :type, :budget, :period, :appliedFrom, :disallowOverbudget, :excludeUnbillableTime, :excludeExpenses,:threshold) — updates the client budget.

    Required parameters:
    client_id — the Id of the client whose budget you update.
    type — budget type, valid values: money or time.
    budget — budget value in cents for money or seconds for time.
    period — budget periodicity, valid values: general, monthly, weekly, daily.
    appliedFrom — the date from which the budget is active in the ‘Y-m-d’ format.

    For example, the command to update the client budget may look like this:
    call UpdateClientBudget(7320280,'money',100,'monthly','2023-4-1',false,false,false,0)

    You can find details about other parameters here

  • call DeleteClientBudget(:clientId) — resets the field values in the Budget block.

  • call UpdateProjectBilling(:project_id, :Billing_Type, :Billing_Fee, :Rate_Type, :Rate_Rate, :Rate_UserRateOverrides, :Rate_UserCostOverrides, :Budget_Type,:Budget_Budget, :Budget_Period, :Budget_AppliedFrom, :Budget_DisallowOverbudget, :Budget_ExcludeUnbillableTime,:Budget_ExcludeExpenses, :Budget_ShowToUsers,:Budget_Threshold) — updates a set of Budget fields in the Projects object.

    Required parameters:
    project_id — the id of the project, which billing you update.
    Billing_Type — project type, valid values: non_billable, hourly, fixed_fee.
    Billing_Fee — project fixed fee in cents. Required only for fixed_fee billing type.
    Rate_Type — rates configuration for billing or budget progress, valid values project_rate, user_rate, user_cost.
    Rate_UserRateOverrides — override user rates in JSON object format where you specify user_Id and rate in cents. Available only for the user_rate type.
    Rate_UserCostOverrides — override user cost rates in JSON object format where you specify user_Id and rate in cents. Available only for the user_cost type.
    Budget_Type — budget type, valid values: money or time.
    Budget_Budget — budget value in cents for money or seconds for time.
    Budget_Period — budget periodicity, valid values: general, monthly, weekly, daily.
    Budget_AppliedFrom — the date from which the budget is active in the ‘Y-m-d’ format.

    For example, the command to update the project billing from May the 1st may look like this:
    call UpdateProjectBilling('ev:179497308508805', 'fixed_fee', 10000, 'user_rate', 10000, '{"1247853":10000}', '{"1247853":10000}', 'money', 10000, 'general', '2023-5-1',false,false,false,true,0)

    You can find details about these and other parameters here

  • call UpdateTaskEstimate(:task_id,:Total,:Type,:Estimate_Users) — updates the field values in the Estimate block In the ProjectTasks object.

  • call DeleteTaskEstimate(:task_id) — resets the field values in the Estimate block In the ProjectTasks object.

You can use a call to the stored procedure, for example, as a text of the command in the ExecuteCommand action in a Target component of a Data Flow, or in Query.

Supported Actions

Skyvia supports all the common actions for Everhour.