Sheets



Important note about API versions

If you are using Dovico Timesheet version 13 or below, you should use API version 5. If using version 14, use API version 6.


Versions 1 through 6

The API calls listed below enable a person to view and approve or reject Sheets that they have been given security access to within Dovico Timesheet.

Examples are provided using cURL.cURL is a 3rd party tool used for transferring data with URL syntax.


Get all Sheets


GET Sheets/

Returns a list of all sheets using pagination.

Security Check: The user must have Software Access set to 'All' and have Read access to the 'Time and Expense Approval' view.
Example XML request:
 
        URI: https://api.dovico.com/Sheets/?version=6
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/?version=6" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/Sheets/?version=6
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/?version=6" -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>U</Status>
                    <Title>Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
                <Sheet>
                    ...
                </Sheet>
            </Sheets>
            <PrevPageURI>https://api.dovico.com/Sheets/?prev=1754&version=6</PrevPageURI>
            <NextPageURI>https://api.dovico.com/Sheets/?next=1794&version=6</NextPageURI>
        </Result>
Fields for Result
Sheets (will return zero or more Sheet nodes)
PrevPageURI (string. Will be 'N/A' if there is no previous page of data)
NextPageURI (string. Will be 'N/A' if there is no next page of data)


Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)



Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)
NOTE: The URI will be 'N/A'.

Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"U",
                    "Title":"Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/Sheets\/?prev=1754&version=6",
        "NextPageURI":"https:\/\/api.dovico.com\/Sheets\/?next=1794&version=6"
        }
Fields
Sheets (an array containing zero or more Sheet objects)
PrevPageURI (string. Will be 'N/A' if there is no previous page of data)
NextPageURI (string. Will be 'N/A' if there is no next page of data)


Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)
NOTE: The URI will be 'N/A'.


Get a Sheet


GET Sheets/{sSheetID}/

Returns the Sheet requested.

Security Check: The user must have Software Access set to 'All' and have Read access to the 'Time and Expense Approval' view.
Example XML request:
 
        URI: https://api.dovico.com/Sheets/{SheetID}/?version=6
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/1754/?version=6" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/Sheets/{SheetID}/?version=6
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/1754/?version=6" -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>U</Status>
                    <Title>Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
            </Sheets>
        </Result>
Fields for Result
Sheets (will return zero Sheet nodes if the requested item does not exist. Will return one Sheet node if the requested item does exist.)


Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)
NOTE: The URI will be 'N/A'.

Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"U",
                    "Title":"Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                }
            ]
        }

Fields
Sheets (an array that will be empty if the requested item does not exist. Otherwise, if the requested item does exist, the array will return one Sheet object.)

Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)

NOTE: The URI will be 'N/A'.




Employee Filter (with Get Sheets)


GET Sheets/Employee/{sEmployeeID}/

Returns a list of all sheets, for the requested Employee, using pagination.

Security Check: The user must have Software Access set to 'All' and have Read access to the 'Time and Expense Approval' view.
Example XML request:
 
        URI: https://api.dovico.com/Sheets/Employee/{EmployeeID}/?version=6
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/Employee/111/?version=6" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/Sheets/Employee/{EmployeeID}/?version=6
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/Employee/111/?version=6" -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>U</Status>
                    <Title>Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
                <Sheet>
                    ...
                </Sheet>
            </Sheets>
            <PrevPageURI>https://api.dovico.com/Sheets/?prev=1754&version=6</PrevPageURI>
            <NextPageURI>https://api.dovico.com/Sheets/?next=1794&version=6</NextPageURI>
        </Result>

Fields for Result
Sheets (will return zero or more Sheet nodes)
PrevPageURI (string. Will be 'N/A' if there is no previous page of data)
NextPageURI (string. Will be 'N/A' if there is no next page of data)


Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)


NOTE: The URI will be 'N/A'.


Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"U",
                    "Title":"Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/Sheets\/?prev=1754&version=6",
        "NextPageURI":"https:\/\/api.dovico.com\/Sheets\/?next=1794&version=6"
        }


Fields
Sheets (an array containing zero or more Sheet objects)
PrevPageURI (string. Will be 'N/A' if there is no previous page of data)
NextPageURI (string. Will be 'N/A' if there is no next page of data)


Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)


NOTE: The URI will be 'N/A'



Manager Filter (with Get Sheets)


GET Sheets/Manager/{sManagerID}/

Returns a list of all sheets, for the requested Manager, using pagination.

Security Check: The user must have Software Access set to 'All' and have Read access to the 'Time and Expense Approval' view.

Example XML request:
 
        URI: https://api.dovico.com/Sheets/Manager/{ManagerID}/?version=6
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/Manager/200/?version=6" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/Sheets/Manager/{ManagerID}/?version=6
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/Manager/200/?version=6" -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>U</Status>
                    <Title>Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
                <Sheet>
                    ...
                </Sheet>
            </Sheets>
            <PrevPageURI>https://api.dovico.com/Sheets/?prev=1754&version=6</PrevPageURI>
            <NextPageURI>https://api.dovico.com/Sheets/?next=1794&version=6</NextPageURI>
        </Result>

Fields for Result
Sheets (will return zero or more Sheet nodes)
PrevPageURI (string. Will be 'N/A' if there is no previous page of data)
NextPageURI (string. Will be 'N/A' if there is no next page of data)


Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)

NOTE: The URI will be 'N/A'.


Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"U",
                    "Title":"Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/Sheets\/?prev=1754&version=6",
        "NextPageURI":"https:\/\/api.dovico.com\/Sheets\/?next=1794&version=6"
        }

Fields
Sheets (an array containing zero or more Sheet objects)
PrevPageURI (string. Will be 'N/A' if there is no previous page of data)
NextPageURI (string. Will be 'N/A' if there is no next page of data)


Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)


NOTE: The URI will be 'N/A'.




Status Filter (with Get Sheets)


GET Sheets/Status/{sStatus}/

Returns a list of all sheets, for the requested Status, using pagination.

Security Check: The user must have Software Access set to 'All' and have Read access to the 'Time and Expense Approval' view

Example XML request:
 
        URI: https://api.dovico.com/Sheets/Status/{Status}/?version=6
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/Status/U/?version=6" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
Fields for the URI
  • Status (required - available status values are: R (rejected entries) and U (under review entries)

Example JSON request:
 
        URI: https://api.dovico.com/Sheets/Status/{Status}/?version=6
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/Status/U/?version=6" -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""

Fields for the URI
*Status (required - available status values are: R (rejected entries) and U (under review entries))


Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>U</Status>
                    <Title>Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
                <Sheet>
                    ...
                </Sheet>
            </Sheets>
            <PrevPageURI>https://api.dovico.com/Sheets/?prev=1754&version=6</PrevPageURI>
            <NextPageURI>https://api.dovico.com/Sheets/?next=1794&version=6</NextPageURI>
        </Result>

Fields for Result
Sheets (will return zero or more Sheet nodes)
PrevPageURI (string. Will be 'N/A' if there is no previous page of data)
NextPageURI (string. Will be 'N/A' if there is no next page of data)


Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)


NOTE: The URI will be 'N/A'.


Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"U",
                    "Title":"Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/Sheets\/?prev=1754&version=6",
        "NextPageURI":"https:\/\/api.dovico.com\/Sheets\/?next=1794&version=6"
        }
Fields
Sheets (an array containing zero or more Sheet objects)
PrevPageURI (string. Will be 'N/A' if there is no previous page of data)
NextPageURI (string. Will be 'N/A' if there is no next page of data)


Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)
NOTE: The URI will be 'N/A'.



Approve a sheet


POST Sheets/{sSheetID}/Approve/

Approves the specified sheet

Security Check: The user must have Software Access set to 'All' and have Read and Modify permissions to the 'Time and Expense Approval' view.
Example XML request:
 
        URI: https://api.dovico.com/Sheets/{SheetID}/Approve/?version=6
        Method: POST
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/1754/Approve/?version=6" --request POST -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<ApproveSheet></ApproveSheet>"
Fields for the URI
  • SheetID (required - long - the ID of the sheet that is to be approved)
Example JSON request:
 
        URI: https://api.dovico.com/Sheets/{SheetID}/Approve/?version=6
        Method: POST
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/1754/Approve/?version=6" --request POST -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: application/json" --data "{}"
Fields for the URI
  • SheetID (required - long - the ID of the sheet that is to be approved)

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>U</Status>
                    <Title>Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
            </Sheets>
        </Result>

Fields for Result
Sheets (will return zero Sheet nodes if the requested item does not exist. Will return one Sheet node if the requested item does exist.)
Note: If there are no more approving managers for the sheet's workflow, an empty Sheet node will be returned since approved time does not have a sheet associated with it.

Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)

Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)

Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)

Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)

NOTE: The URI will be 'N/A'.

Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"U",
                    "Title":"Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                }
            ]
        }

Fields
Sheets (an array that will be empty if the requested item does not exist. Otherwise, if the requested item does exist, the array will return one Sheet object.)
Note: If there are no more approving managers for the sheet's workflow, an empty array will be returned since approved time does not have a sheet associated with it.

Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)

Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)

Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)

Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)

NOTE: The URI will be 'N/A'.



Reject a sheet


POST Sheets/{sSheetID}/Reject/
Rejects the specified sheet

Security Check: The user must have Software Access set to 'All' and have Read and Modify permissions to the 'Time and Expense Approval' view.

Example XML request:
 
        URI: https://api.dovico.com/Sheets/{SheetID}/Reject/?version=6
        Method: POST
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/1754/Reject/?version=6" --request POST -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<RejectSheet><RejectedReason>Please provide descriptions with your time entries</RejectedReason></RejectSheet>"
Fields for the URI
*SheetID (required - long - the ID of the sheet that is to be rejected)


Fields for the RejectSheet node
*RejectedReason (required - string - the reason why the sheet is being rejected)
Example JSON request:
 
        URI: https://api.dovico.com/Sheets/{SheetID}/Reject/?version=6
        Method: POST
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/1754/Reject/?version=6" --request POST -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: application/json" --data "{ ""RejectedReason"": ""Please provide descriptions with your time entries"" }"
Fields for the URI
*SheetID (required - long - the ID of the sheet that is to be rejected)


Fields for the message object
*RejectedReason (required - string - the reason why the sheet is being rejected)
Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>R</Status>
                    <Title>Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011</Title>
                    <Description>Please provide descriptions with your time entries</Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
            </Sheets>
        </Result>
Fields for Result
Sheets (will return zero Sheet nodes if the requested item does not exist. Will return one Sheet node if the requested item does exist.)


Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)



Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)


NOTE: The URI will be 'N/A'.
Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"R",
                    "Title":"Smith, John from Mon Jul 04, 2011 to Fri Jul 08, 2011",
                    "Description":"Please provide descriptions with your time entries",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                }
            ]
        }

Fields
Sheets (an array that will be empty if the requested item does not exist. Otherwise, if the requested item does exist, the array will return one Sheet object.)


Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)

NOTE: The URI will be 'N/A'.



Update sheets (bulk)


PUT Sheets/

Updates the Sheets specified

Security Check:
The user must have Software Access set to 'All' and have Read and Modify permissions to the 'Time and Expense Approval' view.

Example XML request:
 
        URI: https://api.dovico.com/Sheets/?version=6
        Method: PUT
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/?version=6" --request PUT -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<Sheets><UpdateSheet><ID>1754</ID><Title>A new title</Title></UpdateSheet></Sheets>"
 
Fields for Sheets
*UpdateSheet (required - at least one UpdateSheet node is required but more than one can be provided)


Fields for UpdateSheet
*ID (required - long - the ID of the sheet record to update)
Title (optional - string with a maximum length of 200 characters)
Description (optional - string with a maximum length of 250 characters)

Example JSON request:
 
        URI: https://api.dovico.com/Sheets/?version=6
        Method: PUT
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/?version=6" --request PUT -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: application/json" --data "[{""ID"":""1754"",""Title"":""A new title""}]"
 
Fields
*An array containing at least one UpdateSheet object (required)



Fields for UpdateSheet
*ID (required - long - the ID of the sheet record to update)
Title (optional - string with a maximum length of 200 characters)
Description (optional - string with a maximum length of 250 characters)

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>U</Status>
                    <Title>A new title</Title>
                    <Description></Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
            </Sheets>
        </Result>
Fields for Result
Sheets (will return zero Sheet nodes if the requested item does not exist. Will return one Sheet node if the requested item does exist.)


Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)

NOTE: The URI will be 'N/A'.
Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"U",
                    "Title":"A new title",
                    "Description":"",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                }
            ]
        }

Fields
Sheets (an array that will be empty if the requested item does not exist. Otherwise, if the requested item does exist, the array will return one Sheet object.)


Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)

NOTE: The URI will be 'N/A'.




Update a sheet


PUT Sheets/{sSheetID}/

Updates the specified sheet

Security Check: The user must have Software Access set to 'All' and have Read and Modify permissions to the 'Time and Expense Approval' view.
Example XML request:
 
        URI: https://api.dovico.com/Sheets/{SheetID}/?version=6
        Method: PUT
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/1754/?version=6" --request PUT -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<UpdateSheet><Title>A new title</Title></UpdateSheet>"

Fields for the URI
*SheetID (required - long - the ID of the sheet that is to be updated)


Fields for the UpdateSheet node
Title (optional - string with a maximum length of 200 characters)
Description (optional - string with a maximum length of 250 characters)
NOTE: All fields are optional but at least one must be specified

Example JSON request:
 
        URI: https://api.dovico.com/Sheets/{SheetID}/?version=6
        Method: PUT
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/Sheets/1754/?version=6" --request PUT -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: application/json" --data "{ ""Title"": ""A new title"" }"
 

Fields for the URI
*SheetID (required - long - the ID of the sheet that is to be rejected)


Fields for the message object
Title (optional - string with a maximum length of 200 characters)
Description (optional - string with a maximum length of 250 characters)
NOTE: All fields are optional but at least one must be specified


Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <Sheets>
                <Sheet>
                    <ID>1754</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=6</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=6</GetItemURI>
                    </Manager>
                    <Workflow>
                        <ID>102</ID>
                        <Name>Programmers</Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Workflow>
                    <Status>U</Status>
                    <Title>A new title</Title>
                    <Description></Description>
                    <FromDate>2011-07-04</FromDate>
                    <ToDate>2011-07-08</ToDate>
                </Sheet>
            </Sheets>
        </Result>

Fields for Result
Sheets (will return zero Sheet nodes if the requested item does not exist. Will return one Sheet node if the requested item does exist.)

Fields for Sheet
ID (long)
Employee (node containing information about the Employee the sheet is for)
Manager (node containing information about the Employee who is the manager of the sheet)
Workflow (node containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)


Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)


Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)
NOTE: The URI will be 'N/A'.

Example JSON response:
 
        {
        "Sheets":
            [
                {
                    "ID":"1754",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=6"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=6"
                    },
                    "Workflow":
                    {
                        "ID":"102",
                        "Name":"Programmers",
                        "GetItemURI":"N\/A"
                    },
                    "Status":"U",
                    "Title":"A new title",
                    "Description":"",
                    "FromDate":"2011-07-04",
                    "ToDate":"2011-07-08"
                }
            ]
        }

Fields
Sheets (an array that will be empty if the requested item does not exist. Otherwise, if the requested item does exist, the array will return one Sheet object.)


Fields for Sheet
ID (long)
Employee (an object containing information about the Employee the sheet is for)
Manager (an object containing information about the Employee who is the manager of the sheet)
Workflow (an object containing information about the Workflow this sheet is a part of)
Status (string - the status of the sheet. possible values are: U (under review), or R (rejected))
Title (string)
Description (string)
FromDate (string - in the format yyyy-MM-dd)
ToDate (string - in the format yyyy-MM-dd)

Fields for Employee
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current employee item)

Fields for Manager
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the current manager item)


Fields for Workflow
ID (long)
Name (string)
GetItemURI (string - URI to pull information about the Workflow)
NOTE: The URI will be 'N/A'.