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:
- Sign in to Everhour.
- Click Settings in the left menu.
- Click My Profile.
-
Copy your Api Token under the Application Access section.
Creating Connection
To create a connection, insert the obtained API Token into the corresponding box in the Connection Editor.
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.