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:

1. Click +NEW in the top menu.
2. Click Connection in the menu on the left to open the Select Connector page.
3. In the opened pane, click Everhour.
4. In the Connection Editor page, specify a connection name that will be used to identify the connection.

5. Enter your API Token.

   

6. 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:

1. Sign in to Everhour.
2. Click Settings in the menu on the left.
3. Click My Profile.

4. 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.