API Feedback

Using our API? Please let us know if you have any questions or suggestions, as our technical support team will gladly help.

  1. Connect to the Dovico API through Excel Power Query

    It would be incredibly useful to connect to the Dovico API to Excel though its power query tools (data, get data from web) to be able to be able to analyze and visualize live data on Excel. Any ideas?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Use multiple filters

    allow filtering of multiple columns. For example getting Approved time entries for specific Project

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Set Charge Rate for an Employee to Task Assignment?

    Is it possible to set the Employee Change Rate for a Employee to Task Assignment?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. select time entries for employees in a specific Team Name

    I'd like to filter on the Employee Team Name in order to process regional time entries.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Project specific Time Entries not received via the API.

    We have an implementation of the API, using XML responses, that has been in service for a few weeks now. But today we have new behaviour.

    We can receive all the TE's using ...
    "https://api.dovico.com/TimeEntries/?version=5"
    And we can see that project 1070 has TimeEntries.
    But if we use ...
    "https://api.dovico.com/TimeEntries/1070/?version=5"
    we get no Time Entries back.
    Specifically the TimeEntries node has no child nodes.

    This is the same on all Projects.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  7 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Is it possible to import statutory USA/Canada holidays into dovico calendar? It will help to reflect working time and OT on holidays.

    Is it possible to import statutory USA/Canada holidays into dovico calendar? It will help to reflect working time and OT on holidays.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. get lastUpdated, and creation time-stamps for objects from xml API?

    something we could use in searches to get all objects that have changed or been added in the last 25 hrs?

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Extract time entries within a daterange

    I am attempting to extract all time entries within a date range using the API. I am following the instructions on the page/location (http://apideveloper.dovico.com/TimeEntries#Date Range Filter (with Get Time Entries)) but it throws an error of version is not recognised. When I switch the params daterange and version I get daterange is not recognised.

    I have tried to use %20, + and a space to delimit the date but in all cases the Curl failes. Anyone got any ideas what I'm doing wrong?

    curl -H "Authorization: WRAP access_token=""client=xyz&user_token=xyz""" -k https://api.dovico.com/TimeEntries/?daterange=2013-01-01%202013-01-31&version=2

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Token = Admin data access token or Employee App token?

    Their are two types of Data Access Tokens:

    1 - An admin data access token that provides access to all information in the database.
    or
    2 - An employee data access token for apps that provides access to only information that employee has access too.

    So how do you figure out which token is entered?

    >>>>>>>>>>>>>

    The following is some C# code for requesting the User's Employee ID and checking to see if it's the admin token or not.

    The code leverages the .NET common library found here (can just download the dll and reference that directly – don’t need…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Calculate estimated Client Costs

    Estimated client cost is the calculated amount used for billing clients (or for charge back) for tasks or projects.

    For each task assignment, the factors used in calculating estimated client costs are:

    Estimated hours: The estimated number of hours required by an employee to finish the task.

    Task Prorating: A multiplier assigned to the task. Used when you charge clients more (or less) for time spent on specific tasks. This is initially set using the value in the task's prorating field.

    Rate charged: The hourly rate charged (billable rate) for the employee assigned to the task.

    Estimated client cost =…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Calculate estimated Company Costs

    Estimated company cost is the calculated amount used to determine your company's estimated cost to accomplish a task or project.

    For each task assignment, the factors used in calculating estimated company costs are:

    Estimated hours: The estimated number of hours required by an employee to finish the task.

    Rate of wages: The hourly wage rate (pay rate) for the employee assigned to the task.

    Estimated company cost = estimate hours x rate of wages

    More info: http://www.dovico.com/help/dpt3/management_tools/misc_info/client_and_company_costs.htm

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Calculate actual Company Costs

    To figure out Client Costs use the following formula:

    Actual company cost is the calculated amount used to determine your company's cost to accomplish a task or project.

    For each approved time entry, the factors used in calculating company costs are:

    Hours worked: The number of hours worked by an employee on the task.

    Rate of wages: The hourly wage rate (pay rate) for the employee assigned to the task.

    Overtime (OT) wage prorating: An overtime multiplier assigned to the employee's rate of wages value. This multiplier is initially set using the prorating field in the overtime rates view.

    Company…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Use Assignments?

    How do Assignments work?
    I'm wanting to get the estimated hours like the Budgeted Time & Cost screen.

    I can get the projects.
    Then the time entries for the project.
    Then the tasks for each time entry.
    But this only gives time actually entered.

    It looks like assignments are the thing that links project, tasks and employee together because the ItemId can be of many different types. But with only having:
    <GetAssignmentsURI>*</GetAssignmentsURI>
    <GetItemURI>*</GetItemURI>

    I can't see how we are supposed to use these to get the relationships.

    Can anyone help please?

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Curl in Linux format as API Help docs show only Win32 examples.

    Within the API help documentation Curl syntax is based on the win32 version of curl. But the syntax is slightly different in Linux; escape characters for the double quotes in the header change to backslashes instead of double quotes.

    So try this command syntax,

    curl -H "Authorization: WRAP access_token=\"client=ConsumerSecret&user_token=UserToken\"" -k https://api.dovico.com/employees/?version=1

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  General Comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base