Everhour
Everhour is the 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.
Everhour-Specific Features and Limitations
Skyvia has the following limitations for Everhour:
-
In the Data Integration product, Everhour connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Everhour in your package.
- Skyvia supports DML operations for such Everhour objects:
- INSERT, UPDATE, DELETE: Expenses, ExpensesCategories, Invoices, Projects, ProjectSections, ProjectTasks, Schedule, TimeRecords.
- INSERT, UPDATE: Clients.
-
Skyvia supports Replication with Incremental Updates for such Everhour objects: Clients, InvoiceItems, Invoices, ProjectTasks, Schedule, TimeRecords, Users.
-
Skyvia does not support Synchronization for Everhour.
-
In the Clients object, you can use the following procedures to update a range of Budget fields:
-
Updating the field values in the Budget block:
call UpdateClientBudget(:client_id,:type,:budget,:period,:appliedFrom,:disallowOverbudget,:excludeUnbillableTime,:excludeExpenses,:threshold,:progress)
-
Resetting the field values in the Budget block:
call DeleteClientBudget(:clientId)
-
-
Invoices object. 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.
-
In the Projects object, you can use the following stored procedure to update a set of Budget fields:
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)
-
In the ProjectTasks object, you can use the following stored procedures to update a set of the Estimate fields:
-
Updating the field values in the Estimate block:
call UpdateTaskEstimate(:task_id,:Total,:Type,:Estimate_Users)
-
Resetting the field values in the Estimate block:
call DeleteTaskEstimate(:task_id)
-
Everhour Connections
To create a connection to Everhour, you simply need to enter your API Key. To start creating a connection, follow the below steps:
- Click +NEW in the top menu.
- Click Connection in the menu on the left to open the Select Connector page.
- In the opened pane, click Everhour.
- In the Connection Editor page, specify a connection name that will be used to identify the connection.
-
Enter your API Token.
-
Use the Test Connection button to make sure that the connection is successful and then click Create Connection.
API Token — REST API key used for connecting to Everhour.
How to Find an API Token
The API Token can be found in your Everhour account. For this, perform the following steps:
- Sign in to Everhour.
- Click Settings in the menu on the left.
- Click My Profile.
-
Copy your Api Token under the Application Access section.
Supported Actions and Actions Specifics
Everhour connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
- Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.