Expense Entries (versions 1 and 2)


The page is an archive of the original Expense Entries call released September 2011. It has been replaced by version 6.


The API calls listed below enable a person to view, create, edit, and Delete Expense Entries that they have been given security access to within DOVICO Timesheet or DOVICO Planning and Timesheet.

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



Get all Expense Sheets


GET ExpenseEntries/

Returns a list of all Expense Sheets using pagination. Note: The Date Range Filter, Return Currency and $filter query strings can optionally be included with this request.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read permission to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.

Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/?version=2
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/?version=2" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/?version=2
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/?version=2" -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">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>N</Status>
                    <Title>Training</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <GetExpenseEntryItemsURI>https://api.dovico.com/ExpenseEntries/Sheet/139/?version=2</GetExpenseEntryItemsURI>
                </ExpenseSheet>
                <ExpenseSheet>
                    ...
                </ExpenseSheet>
            </ExpenseSheets>
            <PrevPageURI>https://api.dovico.com/ExpenseEntries/?prev=139&version=2</PrevPageURI>
            <NextPageURI>https://api.dovico.com/ExpenseEntries/?next=170&version=2</NextPageURI>
        </Result>


Fields for Result
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"N",
                    "Title":"Training",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "GetExpenseEntryItemsURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Sheet\/139\/?version=2"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/?prev=139&version=2",
        "NextPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/?next=170&version=2"
        }

Fields
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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




Date Range Filter (with Get Expense Sheets)


GET ExpenseEntries/?daterange={daterange}

Using Date Range Filter: Returns a list of all Expense Sheets, which have expense entries within the requested date range, using pagination.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read permission to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.
Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/?daterange={DateRange}&version=2
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/?daterange=2011-06-01%202011-06-30&version=2" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""

Fields for the URI
  • DateRange (required - two date strings in the format yyyy-MM-dd separated by a space and URI Encoded)

Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/?daterange={DateRange}&version=2
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/?daterange=2011-06-01%202011-06-30&version=2" -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""

Fields for the URI
  • DateRange (required - two date strings in the format yyyy-MM-dd separated by a space and URI Encoded)

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>N</Status>
                    <Title>Training</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <GetExpenseEntryItemsURI>https://api.dovico.com/ExpenseEntries/Sheet/139/?version=2</GetExpenseEntryItemsURI>
                </ExpenseSheet>
                <ExpenseSheet>
                    ...
                </ExpenseSheet>
            </ExpenseSheets>
            <PrevPageURI>https://api.dovico.com/ExpenseEntries/?prev=139&version=2</PrevPageURI>
            <NextPageURI>https://api.dovico.com/ExpenseEntries/?next=170&version=2</NextPageURI>
        </Result>

Fields for Result
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)


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)


NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"N",
                    "Title":"Training",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "GetExpenseEntryItemsURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Sheet\/139\/?version=2"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/?prev=139&version=2",
        "NextPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/?next=170&version=2"
        }

Fields
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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




Return Currency (with Get Expense Sheets)


GET ExpenseEntries/?returncurrency={CurrencyID}

Using Return Currency: For the list of expense entries that are returned, each expense entry's Amount and Fixed Amount value is converted to the requested currency. The Currency and FixedCurrency values are also returned as the requested currency.

Security Check:
The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read permission to 'Approved Expenses' view or Access to the 'Timesheet - Expenses' tool. Multicurrency must be enabled and the specified currency must also be enabled.

Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/{ExpenseEntryID}/?returncurrency={CurrencyID}&version=2
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/355b4188-cafa-40a0-8577-a55a0e98fef3/?returncurrency=159&version=2" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
Fields for the URI
  • ReturnCurrency (required - the currency id that the Amount and Fixed Amount values are to be converted to)
NOTE: - An error will be returned if multicurrency is off
- An error will also be returned if the specified currency id is not enabled

Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/{ExpenseEntryID}/?returncurrency={CurrencyID}version=2
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/355b4188-cafa-40a0-8577-a55a0e98fef3/?returncurrency=159&version=2" -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""

Fields for the URI
  • ReturnCurrency (required - the currency id that the Amount and Fixed Amount values are to be converted to)
NOTE: - An error will be returned if multicurrency is off
- An error will also be returned if the specified currency id is not enabled

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>N</Status>
                    <Title>Training</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>355b4188-cafa-40a0-8577-a55a0e98fef3</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>417.09</Amount>
                            <Currency>
                                <ID>159</ID>
                                <Symbol>EUR €</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/159/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0.00</FixedAmount>
                            <FixedCurrency>
                                <ID>159</ID>
                                <Symbol>EUR €</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/159/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Hotel costs</Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>

Fields for Result
ExpenseSheets (will return zero ExpenseSheet nodes if the requested expense entry does not exist. will return one ExpenseSheet node if the requested expense entry does exist.)


Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing the requested ExpenseEntry node)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).


Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)


Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"N",
                    "Title":"Training",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"355b4188-cafa-40a0-8577-a55a0e98fef3",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"417.09",
                            "Currency":
                            {
                                "ID":"159",
                                "Symbol":"EUR €",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/159\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0.00",
                            "FixedCurrency":
                            {
                                "ID":"159",
                                "Symbol":"EUR €",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/159\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Hotel costs",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "0"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }
Fields
ExpenseSheets (will return zero ExpenseSheet objects if the requested expense entry does not exist. will return one ExpenseSheet object if the requested expense entry does exist.)


Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing the requested ExpenseEntry object)



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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).


Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)


Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)





Get an Expense Entry


GET ExpenseEntries/{sExpenseEntryID}/

Returns the expense entry requested. Note: The Return Currency query string can optionally be included with this request.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read permission to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.

Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/{ExpenseEntryID}/?version=2
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/355b4188-cafa-40a0-8577-a55a0e98fef3/?version=2" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/{ExpenseEntryID}/?version=2
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/355b4188-cafa-40a0-8577-a55a0e98fef3/?version=2" -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">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>N</Status>
                    <Title>Training</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>355b4188-cafa-40a0-8577-a55a0e98fef3</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>496</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Hotel costs</Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>

Fields for Result
ExpenseSheets (will return zero ExpenseSheet nodes if the requested expense entry does not exist. will return one ExpenseSheet node if the requested expense entry does exist.)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing the requested ExpenseEntry node)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"N",
                    "Title":"Training",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"355b4188-cafa-40a0-8577-a55a0e98fef3",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"496",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Hotel costs",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "0"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }

Fields
ExpenseSheets (will return zero ExpenseSheet objects if the requested expense entry does not exist. will return one ExpenseSheet object if the requested expense entry does exist.)

Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing the requested ExpenseEntry object)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).


Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)


Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)



Status Filter (with Get Expense Sheets)


GET ExpenseEntries/Status/{sStatus}/

Using Status Filter: Returns a list of all Expense Sheets, that have been entered for the requested Status, using pagination. Note: The Date Range Filter, Return Currency and $filter query strings can optionally be included with this request.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read permission to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.

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

Fields for the URI
*Status (required - available status values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))

Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/Status/{Status}/?version=2
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Status/U/?version=2" -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: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>140</ID>
                    <Employee>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1301</ID>
                        <Name>Development Project: A-212</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1301/?version=2</GetItemURI>
                    </Project>
                    <Status>U</Status>
                    <Title>Smith, John Book Purchase on ACME-Support from Fri Jul 08, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <GetExpenseEntryItemsURI>https://api.dovico.com/ExpenseEntries/Sheet/140/?version=2</GetExpenseEntryItemsURI>
                </ExpenseSheet>
                <ExpenseSheet>
                    ...
                </ExpenseSheet>
            </ExpenseSheets>
            <PrevPageURI>https://api.dovico.com/ExpenseEntries/Status/U/?prev=140&version=2</PrevPageURI>
            <NextPageURI>https://api.dovico.com/ExpenseEntries/Status/U/?next=170&version=2</NextPageURI>
        </Result>

Fields for Result
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"140",
                    "Employee":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1301",
                        "Name":"Development Project: A-212",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1301\/?version=2"
                    },
                    "Status":"U",
                    "Title":"Smith, John Book Purchase on ACME-Support from Fri Jul 08, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "GetExpenseEntryItemsURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Sheet\/140\/?version=2"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Status\/U\/?prev=140&version=2",
        "NextPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Status\/U\/?next=170&version=2"
        }

Fields
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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





Employee Filter (with Get Expense Sheets)


GET ExpenseEntries/Employee/{sEmployeeID}/

Using Employee Filter: Returns a list of all Expense Sheets, that have been entered for the requested Employee, using pagination. Note: The Date Range Filter, Return Currency and $filter query strings can optionally be included with this request.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read permission to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.

Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/Employee/{EmployeeID}/?version=2
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Employee/200/?version=2" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/Employee/{EmployeeID}/?version=2
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Employee/200/?version=2" -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">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>140</ID>
                    <Employee>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1301</ID>
                        <Name>Development Project: A-212</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1301/?version=2</GetItemURI>
                    </Project>
                    <Status>U</Status>
                    <Title>Smith, John Book Purchase on ACME-Support from Fri Jul 08, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <GetExpenseEntryItemsURI>https://api.dovico.com/ExpenseEntries/Sheet/140/?version=2</GetExpenseEntryItemsURI>
                </ExpenseSheet>
                <ExpenseSheet>
                    ...
                </ExpenseSheet>
            </ExpenseSheets>
            <PrevPageURI>https://api.dovico.com/ExpenseEntries/Employee/200/?prev=140&version=2</PrevPageURI>
            <NextPageURI>https://api.dovico.com/ExpenseEntries/Employee/200/?next=170&version=2</NextPageURI>
        </Result>

Fields for Result
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"140",
                    "Employee":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1301",
                        "Name":"Development Project: A-212",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1301\/?version=2"
                    },
                    "Status":"U",
                    "Title":"Smith, John Book Purchase on ACME-Support from Fri Jul 08, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "GetExpenseEntryItemsURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Sheet\/140\/?version=2"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Employee\/200\/?prev=140&version=2",
        "NextPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Employee\/200\/?next=170&version=2"
        }

Fields
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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



Project Filter (with Get Expense Sheets)


GET ExpenseEntries/Project/{sProjectID}/

Using Project Filter: Returns a list of all Expense Sheets, that have been entered for the requested Project, using pagination. Note: The Date Range Filter, Return Currency and $filter query strings can optionally be included with this request.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read permission to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.
Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/Project/{ProjectID}/?version=2
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Project/1301/?version=2" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/Project/{ProjectID}/?version=2
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Project/1301/?version=2" -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">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>140</ID>
                    <Employee>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1301</ID>
                        <Name>Development Project: A-212</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1301/?version=2</GetItemURI>
                    </Project>
                    <Status>U</Status>
                    <Title>Smith, John Book Purchase on ACME-Support from Fri Jul 08, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <GetExpenseEntryItemsURI>https://api.dovico.com/ExpenseEntries/Sheet/140/?version=2</GetExpenseEntryItemsURI>
                </ExpenseSheet>
                <ExpenseSheet>
                    ...
                </ExpenseSheet>
            </ExpenseSheets>
            <PrevPageURI>https://api.dovico.com/ExpenseEntries/Project/1301/?prev=140&version=2</PrevPageURI>
            <NextPageURI>https://api.dovico.com/ExpenseEntries/Project/1301/?next=170&version=2</NextPageURI>
        </Result>

Fields for Result
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"140",
                    "Employee":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1301",
                        "Name":"Development Project: A-212",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1301\/?version=2"
                    },
                    "Status":"U",
                    "Title":"Smith, John Book Purchase on ACME-Support from Fri Jul 08, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "GetExpenseEntryItemsURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Sheet\/140\/?version=2"
                },
                {
                    ...
                }
            ],
        "PrevPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Project\/1301\/?prev=140&version=2",
        "NextPageURI":"https:\/\/api.dovico.com\/ExpenseEntries\/Project\/1301\/?next=170&version=2"
        }

Fields
ExpenseSheets (will return zero or more ExpenseSheet 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 ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
GetExpenseEntryItemsURI (string - URI to pull information about the current expense sheet's expense entry items)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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




Get all Expense Entries for the Sheet requested


GET ExpenseEntries/Sheet/{sSheetID}/

Returns a list of all Expense Entries that a part of the requested Sheet.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read permission to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.

Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/?version=2
        Method: GET
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/140/?version=2" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/?version=2
        Method: GET
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/140/?version=2" -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">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>140</ID>
                    <Employee>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1301</ID>
                        <Name>Development Project: A-212</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1301/?version=2</GetItemURI>
                    </Project>
                    <Status>U</Status>
                    <Title>Smith, John Book Purchase on ACME-Support from Fri Jul 08, 2011 to Fri Jul 08, 2011</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>3a5c2f08-981f-4df4-b922-2a3e3f40d68f</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-08</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>59.99</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Needed to buy a book to better understand a particular technology to be better able to help our customers</Description>
                            <Reimbursable>F</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>5c72d8fc-0e88-4e10-8b9d-30275fcf7280</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>1.23</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                        <ExpenseEntry>
                            ...
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>

Fields for Result
ExpenseSheets (will return zero ExpenseSheet nodes if the requested sheet does not exist. will return one ExpenseSheet node if the requested sheet does exist.)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing zero or more ExpenseEntry nodes)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"140",
                    "Employee":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1301",
                        "Name":"Development Project: A-212",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1301\/?version=2"
                    },
                    "Status":"U",
                    "Title":"Smith, John Book Purchase on ACME-Support from Fri Jul 08, 2011 to Fri Jul 08, 2011",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"3a5c2f08-981f-4df4-b922-2a3e3f40d68f",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-08",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"59.99",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Needed to buy a book to better understand a particular technology to be better able to help our customers",
                            "Reimbursable":"F",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"5c72d8fc-0e88-4e10-8b9d-30275fcf7280",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "1.23"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        },
                        {
                            ...
                        }
                    ]
                }
            ]
        }

Fields
ExpenseSheets (will return zero ExpenseSheet objects if the requested sheet does not exist. will return one ExpenseSheet object if the requested sheet does exist.)

Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing zero or more ExpenseEntry objects)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).


Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)




Insert Expense Entries


POST ExpenseEntries/

Creates the Expense Entries specified for an existing Expense Sheet. Expense Entries cannot be added to an Expense Sheet that is Under Review or Approved.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read and Modify permissions to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.
Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/?version=2
        Method: POST
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/?version=2" --request POST -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<ExpenseSheets><ExpenseSheet><ID>139</ID><ExpenseEntries><ExpenseEntry><Date>2011-07-01</Date><Amount>496</Amount><Description>Hotel costs</Description></ExpenseEntry></ExpenseEntries></ExpenseSheet></ExpenseSheets>"
NOTE: An optional query string ('approved=T') can be included in the URI for a POST to allow expense entries to be entered as approved. If this flag is set to 'T', the sheet specified must be Approved but not yet Paid. This flag can only be set to 'T' if the logged in user is the Administrator Data Access Token. Otherwise, an error will be returned.

Fields for ExpenseSheets
*ExpenseSheet (required - at least one ExpenseSheet node is required but more than one can be provided)

Fields for ExpenseSheet
*ID (required - long - the ID of the expense sheet the expense entry is to be added to)
ExpenseEntries (optional - one or more ExpenseEntry items)

Fields for ExpenseEntry
ExpenseCategoryID (optional - long - the ID of the Expense Category associated with the expense entry. This can be set to 0 for None)
  • Date (required - date string in the format yyyy-MM-dd)
PurchaseOrder (optional - string with a maximum length of 50 characters)
ReferenceNumber (optional - string with a maximum length of 50 characters)
Quantity (optional - double in US English format)
CostPerUnit (optional - double in US English format)
Amount (optional - double in US English format)
CurrencyID (optional - long - must be an enabled currency)
Markup (optional - double in US English format)
FixedAmount (optional - double in US English format)
FixedCurrencyID (optional - long - must be an enabled currency)
Tax1 (optional - double in US English format)
Tax2 (optional - double in US English format)
Description (optional - string with a maximum length of 4000 characters)
Reimbursable (optional - string 'T' or 'F')
Billable (optional - string 'T' or 'F')
CustomFields (optional - zero or more CustomField nodes)

Fields for CustomField
*ID (required - Guid - FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF in this case)
*TemplateID (required - long - the ID of the Custom Template that this Custom Field belongs to) Values (optional - zero or more Value nodes)

Fields for Value
Value (optional - string, date, or double depending on the Custom Template's type)

Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/?version=2
        Method: POST
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/?version=2" --request POST -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: application/json" --data "[{""ID"":""139"",""ExpenseEntries"":[{""Date"":""2011-07-01"",""Amount"":""496"",""Description"":""Hotel costs""}]}]"
 
 

NOTE: An optional query string ('approved=T') can be included in the URI for a POST to allow expense entries to be entered as approved. If this flag is set to 'T', the sheet specified must be Approved but not yet Paid. This flag can only be set to 'T' if the logged in user is the Administrator Data Access Token. Otherwise, an error will be returned.

Fields
*An array containing at least one ExpenseSheet object (required)

Fields for ExpenseSheet
*ID (required - long - the ID of the expense sheet the expense entry is to be added to)
ExpenseEntries (optional - array of one or more ExpenseEntry objects)

Fields for ExpenseEntry
ExpenseCategoryID (optional - long - the ID of the Expense Category associated with the expense entry. This can be set to 0 for None)
*Date (required - date string in the format yyyy-MM-dd)
PurchaseOrder (optional - string with a maximum length of 50 characters)
ReferenceNumber (optional - string with a maximum length of 50 characters)
Quantity (optional - double in US English format)
CostPerUnit (optional - double in US English format)
Amount (optional - double in US English format)
CurrencyID (optional - long - must be an enabled currency)
Markup (optional - double in US English format)
FixedAmount (optional - double in US English format)
FixedCurrencyID (optional - long - must be an enabled currency)
Tax1 (optional - double in US English format)
Tax2 (optional - double in US English format)
Description (optional - string with a maximum length of 4000 characters)
Reimbursable (optional - string 'T' or 'F')
Billable (optional - string 'T' or 'F')
CustomFields (optional - an array of zero or more CustomField objects)

Fields for CustomField
*ID (required - Guid - FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF in this case)
*TemplateID (required - long - the ID of the Custom Template that this Custom Field belongs to)
Values (optional - zero or more Value objects)


Fields for Value
Value (optional - string, date, or double depending on the Custom Template's type)

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>N</Status>
                    <Title>Training</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>355b4188-cafa-40a0-8577-a55a0e98fef3</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>496</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Hotel costs</Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>

Fields for Result
ExpenseSheets (will return one or more ExpenseSheet nodes)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing zero or more ExpenseEntry nodes)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"N",
                    "Title":"Training",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"355b4188-cafa-40a0-8577-a55a0e98fef3",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"496",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Hotel costs",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "0"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }

Fields
ExpenseSheets (will return one or more ExpenseSheet objects)

Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing zero or more ExpenseEntry objects)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).


Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)




Insert Expense Sheets


POST ExpenseEntries/Sheet/

Creates the Expense Sheets specified.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read and Modify permissions to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.

Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/?version=2
        Method: POST
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/?version=2" --request POST -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<ExpenseSheets><ExpenseSheet><EmployeeID>111</EmployeeID><ManagerID>200</ManagerID><ProjectID>1300</ProjectID><Title>Training</Title><ExpenseEntries><ExpenseEntry><Date>2011-07-01</Date><Amount>496</Amount><Description>Hotel costs</Description><Reimbursable>T</Reimbursable></ExpenseEntry></ExpenseEntries></ExpenseSheet></ExpenseSheets>"

NOTE: An optional query string ('approved=T') can be included in the URI for a POST to allow expense sheet to be entered as approved. This flag can only be set to 'T' if the logged in user is the Administrator Data Access Token. Otherwise, an error will be returned.

Fields for ExpenseSheets
*ExpenseSheet (required - at least one ExpenseSheet node is required but more than one can be provided)

Fields for ExpenseSheet
*EmployeeID (required - long - the ID of the employee that the expense sheet is for)
*ManagerID (required - long - the ID of the employee who is the manager of the expense sheet. This can be set to 0 for unsubmitted sheets)
*ProjectID (required - long - the ID of the project that the expense sheet is for)
*Title (required - string with a maximum length of 200 characters)
Description (optional - string with a maximum length of 250 characters)
ExpenseEntries (optional - zero or more ExpenseEntry items)

Fields for ExpenseEntry
ExpenseCategoryID (optional - long - the ID of the Expense Category associated with the expense entry. This can be set to 0 for None)
*Date (required - date string in the format yyyy-MM-dd)
PurchaseOrder (optional - string with a maximum length of 50 characters)
ReferenceNumber (optional - string with a maximum length of 50 characters)
Quantity (optional - double in US English format)
CostPerUnit (optional - double in US English format)
Amount (optional - double in US English format)
CurrencyID (optional - long - must be an enabled currency)
Markup (optional - double in US English format)
FixedAmount (optional - double in US English format)
FixedCurrencyID (optional - long - must be an enabled currency)
Tax1 (optional - double in US English format)
Tax2 (optional - double in US English format)
Description (optional - string with a maximum length of 4000 characters)
Reimbursable (optional - string 'T' or 'F')
Billable (optional - string 'T' or 'F')
CustomFields (optional - zero or more CustomField nodes)

Fields for CustomField
*ID (required - Guid - FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF in this case)
*TemplateID (required - long - the ID of the Custom Template that this Custom Field belongs to)
Values (optional - zero or more Value nodes)

Fields for Value
Value (optional - string, date, or double depending on the Custom Template's type)

Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/?version=2
        Method: POST
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/?version=2" --request POST -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: application/json" --data "[{""EmployeeID"":""111"",""ManagerID"":""200"",""ProjectID"":""1300"",""Title"":""Training"",""ExpenseEntries"":[{""Date"":""2011-07-01"",""Amount"":""496"",""Description"":""Hotel costs"",""Reimbursable"":""T""}]}]"

NOTE: An optional query string ('approved=T') can be included in the URI for a POST to allow expense sheet to be entered as approved. This flag can only be set to 'T' if the logged in user is the Administrator Data Access Token. Otherwise, an error will be returned.


Fields
*An array containing at least one ExpenseSheet object (required)


Fields for ExpenseSheet
*EmployeeID (required - long - the ID of the employee that the expense sheet is for)
*ManagerID (required - long - the ID of the employee who is the manager of the expense sheet. This can be set to 0 for unsubmitted sheets)
*ProjectID (required - long - the ID of the project that the expense sheet is for)
*Title (required - string with a maximum length of 200 characters)
Description (optional - string with a maximum length of 250 characters)
ExpenseEntries (optional - an array of zero or more ExpenseEntry objects)


Fields for ExpenseEntry
ExpenseCategoryID (optional - long - the ID of the Expense Category associated with the expense entry. This can be set to 0 for None)
*Date (required - date string in the format yyyy-MM-dd)
PurchaseOrder (optional - string with a maximum length of 50 characters)
ReferenceNumber (optional - string with a maximum length of 50 characters)
Quantity (optional - double in US English format)
CostPerUnit (optional - double in US English format)
Amount (optional - double in US English format)
CurrencyID (optional - long - must be an enabled currency)
Markup (optional - double in US English format)
FixedAmount (optional - double in US English format)
FixedCurrencyID (optional - long - must be an enabled currency)
Tax1 (optional - double in US English format)
Tax2 (optional - double in US English format)
Description (optional - string with a maximum length of 4000 characters)
Reimbursable (optional - string 'T' or 'F')
Billable (optional - string 'T' or 'F')
CustomFields (optional - an array of zero or more CustomField objects)


Fields for CustomField
*ID (required - Guid - FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF in this case)
*TemplateID (required - long - the ID of the Custom Template that this Custom Field belongs to)
Values (optional - zero or more Value objects)

Fields for Value
Value (optional - string, date, or double depending on the Custom Template's type)

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>N</Status>
                    <Title>Training</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>355b4188-cafa-40a0-8577-a55a0e98fef3</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>496</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Hotel costs</Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>

Fields for Result
ExpenseSheets (will return one or more ExpenseSheet nodes)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing zero or more ExpenseEntry nodes)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"N",
                    "Title":"Training",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"355b4188-cafa-40a0-8577-a55a0e98fef3",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"496",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Hotel costs",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "1.23"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }

Fields
ExpenseSheets (will return one or more ExpenseSheet objects)

Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing zero or more ExpenseEntry objects)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).


Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)


Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)



Submit an Expense Sheet


POST ExpenseEntries/Sheet/{sSheetID}/Submit/

Submits the Expense Sheet specified.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read and Modify permissions to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.
Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/Submit/?version=2
        Method: POST
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/139/Submit/?version=2" --request POST -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<ExpenseSheet></ExpenseSheet>"
 

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

Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/Submit/?version=2
        Method: POST
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/139/Submit/?version=2" --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 submitted)

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>U</Status>
                    <Title>Smith, John Book Training on Development Project: A-211 from Fri Jul 01, 2011 to Fri Jul 01, 2011</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>355b4188-cafa-40a0-8577-a55a0e98fef3</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>496</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Hotel costs</Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>

Fields for Result
ExpenseSheets (will return zero ExpenseSheet nodes if the requested sheet does not exist. will return one ExpenseSheet node if the requested sheet does exist.)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing zero or more ExpenseEntry nodes)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"U",
                    "Title":"Smith, John Book Training on Development Project: A-211 from Fri Jul 01, 2011 to Fri Jul 01, 2011",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"355b4188-cafa-40a0-8577-a55a0e98fef3",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"496",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Hotel costs",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "0"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }

Fields for Result
ExpenseSheets (will return zero ExpenseSheet objects if the requested sheet does not exist. will return one ExpenseSheet object if the requested sheet does exist.)


Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing zero or more ExpenseEntry objects)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)



Approve an Expense Sheet


POST ExpenseEntries/Sheet/{sSheetID}/Approve/

Approves the Expense Sheet specified

Security Check: The user must have Software Access set to 'All', have Read and Modify permissions to the 'Time and Expense Approval' view, and have Read access to 'Approved Expenses'.
Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/Approve/?version=2
        Method: POST
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheets/139/Approve/?version=2" --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/ExpenseEntries/Sheet/{SheetID}/Approve/?version=2
        Method: POST
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/139/Approve/?version=2" --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">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>0</ID>
                        <Name></Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>A</Status>
                    <Title>Smith, John Book Training on Development Project: A-211 from Fri Jul 01, 2011 to Fri Jul 01, 2011</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver>Approved by Young, Christie on 7/5/2011</Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>355b4188-cafa-40a0-8577-a55a0e98fef3</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>496</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Hotel costs</Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>


Fields for Result
ExpenseSheets (will return zero ExpenseSheet nodes if the requested sheet does not exist. will return one ExpenseSheet node if the requested sheet does exist.)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing zero or more ExpenseEntry nodes)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"0",
                        "Name":"",
                        "GetItemURI":"N\/A"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"A",
                    "Title":"Smith, John Book Training on Development Project: A-211 from Fri Jul 01, 2011 to Fri Jul 01, 2011",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"Approved by Young, Christie on 7/5/2011",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"355b4188-cafa-40a0-8577-a55a0e98fef3",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"496",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Hotel costs",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "0"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }

Fields for Result
ExpenseSheets (will return zero ExpenseSheet objects if the requested sheet does not exist. will return one ExpenseSheet object if the requested sheet does exist.)

Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing zero or more ExpenseEntry objects)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)




Reject an Expense Sheet


POST ExpenseEntries/Sheet/{sSheetID}/Reject/

Rejects the Expense Sheet specified

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

Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/Reject/?version=2
        Method: POST
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/139/Reject/?version=2" --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 expense 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/ExpenseEntries/Sheet/{SheetID}/Reject/?version=2
        Method: POST
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/139/Reject/?version=2" --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 expense entries"" }"

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">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>R</Status>
                    <Title>Smith, John Book Training on Development Project: A-211 from Fri Jul 01, 2011 to Fri Jul 01, 2011</Title>
                    <Description>Please provide descriptions with your expense entries</Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver></Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>355b4188-cafa-40a0-8577-a55a0e98fef3</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>496</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description></Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>


Fields for Result
ExpenseSheets (will return zero ExpenseSheet nodes if the requested sheet does not exist. will return one ExpenseSheet node if the requested sheet does exist.)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing zero or more ExpenseEntry nodes)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"R",
                    "Title":"Smith, John Book Training on Development Project: A-211 from Fri Jul 01, 2011 to Fri Jul 01, 2011",
                    "Description":"Please provide descriptions with your expense entries",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"355b4188-cafa-40a0-8577-a55a0e98fef3",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"496",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "0"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }

Fields for Result
ExpenseSheets (will return zero ExpenseSheet objects if the requested sheet does not exist. will return one ExpenseSheet object if the requested sheet does exist.)

Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing zero or more ExpenseEntry objects)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)





Update an Expense Entry


PUT ExpenseEntries/{sExpenseEntryID}/

Updates the Expense Entry specified.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read and Modify permissions to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.
Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/{ExpenseEntryID}/?version=2
        Method: PUT
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/153/?version=2" --request PUT -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<ExpenseEntry><Amount>496</Amount></ExpenseEntry>"

Fields for ExpenseEntry
ExpenseCategoryID (optional - long - the ID of the Expense Category associated with the expense entry. This can be set to 0 for None)
Date (optional - date string in the format yyyy-MM-dd)
PurchaseOrder (optional - string with a maximum length of 50 characters)
ReferenceNumber (optional - string with a maximum length of 50 characters)
Quantity (optional - double in US English format)
CostPerUnit (optional - double in US English format)
Amount (optional - double in US English format)
CurrencyID (optional - long - must be an enabled currency)
Markup (optional - double in US English format)
FixedAmount (optional - double in US English format)
FixedCurrencyID (optional - long - must be an enabled currency)
Tax1 (optional - double in US English format)
Tax2 (optional - double in US English format)
Description (optional - string with a maximum length of 4000 characters)
Reimbursable (optional - string 'T' or 'F')
Billable (optional - string 'T' or 'F')
Archive (optional - string 'T' or 'F')
Integrate (optional - string of encoded XML. If specified, only one element is permitted but the element can contain child elements. Do not include a root INT element.)
DeleteIntegrateElement (optional - string containing the name of the element to be removed from the Integrate field)
CustomFields (optional - zero or more CustomField nodes)

NOTE:
- All fields are optional but at least one must be specified
- The Archive and Integrate values are ignored if updating an unapproved expense entry
- If XML is provided for the Integrate field, the XML needs to be encoded. For example, < characters need to be replaced with &lt;

WARNING: The Integrate field is used by several of DOVICO Software's integration solutions. If this field contains a value, do not overwrite the value with a new value unless you intend for this record to no longer work with the solution(s) it was integrated with.

Fields for CustomField
*ID (required - long/Guid - specify a long if the expense entry being manipulated is an approved expense entry. specify the guid if the expense entry being manipulated is not yet approved.)
*TemplateID (required - long - the ID of the Custom Template that this Custom Field belongs to)
Values (optional - zero or more Value nodes)

Fields for Value
Value (optional - string, date, or double depending on the Custom Template's type)

Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/{ExpenseEntryID}/?version=2
        Method: PUT
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/153/?version=2" --request PUT -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: application/json" --data "{""Amount"":""496""}"

Fields for ExpenseEntry
ExpenseCategoryID (optional - long - the ID of the Expense Category associated with the expense entry. This can be set to 0 for None)
Date (optional - date string in the format yyyy-MM-dd)
PurchaseOrder (optional - string with a maximum length of 50 characters)
ReferenceNumber (optional - string with a maximum length of 50 characters)
Quantity (optional - double in US English format)
CostPerUnit (optional - double in US English format)
Amount (optional - double in US English format)
CurrencyID (optional - long - must be an enabled currency)
Markup (optional - double in US English format)
FixedAmount (optional - double in US English format)
FixedCurrencyID (optional - long - must be an enabled currency)
Tax1 (optional - double in US English format)
Tax2 (optional - double in US English format)
Description (optional - string with a maximum length of 4000 characters)
Reimbursable (optional - string 'T' or 'F')
Billable (optional - string 'T' or 'F')
Archive (optional - string 'T' or 'F')
Integrate (optional - string of XML. If specified, only one element is permitted but the element can contain child elements. Do not include a root INT element.)
DeleteIntegrateElement (optional - string containing the name of the element to be removed from the Integrate field)
CustomFields (optional - an array of zero or more CustomField objects)

NOTE: - All fields are optional but at least one must be specified
- The Archive and Integrate values are ignored if updating an unapproved expense entry

WARNING: The Integrate field is used by several of DOVICO Software's integration solutions. If this field contains a value, do not overwrite the value with a new value unless you intend for this record to no longer work with the solution(s) it was integrated with.

Fields for CustomField
*ID (required - long/Guid - specify a long if the expense entry being manipulated is an approved expense entry. specify the guid if the expense entry being manipulated is not yet approved.)
*TemplateID (required - long - the ID of the Custom Template that this Custom Field belongs to)
Values (optional - zero or more Value objects)

Fields for Value
Value (optional - string, date, or double depending on the Custom Template's type)

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>0</ID>
                        <Name></Name>
                        <GetItemURI>N/A</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>A</Status>
                    <Title>Smith, John Training on Development Project: A-211 from Fri Jul 01, 2011 to Fri Jul 01, 2011</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver>Approved by Smith, John on 7/21/2011</Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>153</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>496</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Hotel costs</Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>

Fields for Result
ExpenseSheets (will return one ExpenseSheet node)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing the ExpenseEntry node updated)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)
Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"0",
                        "Name":"",
                        "GetItemURI":"N\/A"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"A",
                    "Title":"Smith, John Training on Development Project: A-211 from Fri Jul 01, 2011 to Fri Jul 01, 2011",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"Approved by Smith, John on 7/21/2011",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"153",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"496",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Hotel costs",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "0"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }

Fields
ExpenseSheets (will return one ExpenseSheet object)

Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing the ExpenseEntry object updated)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).


Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)




Update an Expense Sheet


PUT ExpenseEntries/Sheet/{sSheetID}/

Updates the Expense Sheet specified.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Read and Modify permissions to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.
Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/?version=2
        Method: PUT
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/139/?version=2" --request PUT -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: text/xml" --data "<ExpenseSheet><EmployeeID>111</EmployeeID><ManagerID>200</ManagerID><ProjectID>1300</ProjectID><Title>Training</Title></ExpenseSheet>"

Fields for ExpenseSheet
EmployeeID (optional - long - the ID of the employee that the expense sheet is for)
ManagerID (optional - long - the ID of the employee who is the manager of the expense sheet. This can be set to 0 for unsubmitted sheets)
ProjectID (optional - long - the ID of the project that the expense sheet is for)
Title (optional - string with a maximum length of 200 characters)
Description (optional - string with a maximum length of 250 characters)
CheckDate (optional - date string in the format yyyy-MM-dd)
CheckNumber (optional - string with a maximum length of 25 characters)

NOTE:
- All fields are optional but at least one must be specified
- CheckDate and CheckNumber can only be updated if the sheet is Paid (sheet status is P)

Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/?version=2
        Method: PUT
        Accept: application/json
        Content-Type: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/Sheet/139/?version=2" --request PUT -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593""" -H "Content-Type: application/json" --data "{""EmployeeID"":""111"",""ManagerID"":""200"",""ProjectID"":""1300"",""Title"":""Training""}"

Fields for ExpenseSheet
EmployeeID (optional - long - the ID of the employee that the expense sheet is for)
ManagerID (optional - long - the ID of the employee who is the manager of the expense sheet. This can be set to 0 for unsubmitted sheets)
ProjectID (optional - long - the ID of the project that the expense sheet is for)
Title (optional - string with a maximum length of 200 characters)
Description (optional - string with a maximum length of 250 characters)
CheckDate (optional - date string in the format yyyy-MM-dd)
CheckNumber (optional - string with a maximum length of 25 characters)

NOTE: - All fields are optional but at least one must be specified
- CheckDate and CheckNumber can only be updated if the sheet is Paid (sheet status is P)

Example XML response:
 
        <Result xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ExpenseSheets>
                <ExpenseSheet>
                    <ID>139</ID>
                    <Employee>
                        <ID>111</ID>
                        <Name>Smith, John</Name>
                        <GetItemURI>https://api.dovico.com/Employees/111/?version=2</GetItemURI>
                    </Employee>
                    <Manager>
                        <ID>200</ID>
                        <Name>Young, Christie</Name>
                        <GetItemURI>https://api.dovico.com/Employees/200/?version=2</GetItemURI>
                    </Manager>
                    <Project>
                        <ID>1300</ID>
                        <Name>Development Project: A-211</Name>
                        <GetItemURI>https://api.dovico.com/Projects/1300/?version=2</GetItemURI>
                    </Project>
                    <Status>A</Status>
                    <Title>Training</Title>
                    <Description></Description>
                    <Reimbursed>F</Reimbursed>
                    <CheckDate>1900-01-01</CheckDate>
                    <CheckNumber></CheckNumber>
                    <Approver>Approved by Smith, John on 7/21/2011</Approver>
                    <ExpenseEntries>
                        <ExpenseEntry>
                            <ID>153</ID>
                            <ExpenseCategory>
                                <ID>0</ID>
                                <Name></Name>
                                <GetItemURI>N/A</GetItemURI>
                            </ExpenseCategory>
                            <Date>2011-07-01</Date>
                            <PurchaseOrder></PurchaseOrder>
                            <ReferenceNumber></ReferenceNumber>
                            <Quantity>0</Quantity>
                            <CostPerUnit>0</CostPerUnit>
                            <Amount>496</Amount>
                            <Currency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </Currency>
                            <Markup>-100</Markup>
                            <FixedAmount>0</FixedAmount>
                            <FixedCurrency>
                                <ID>280</ID>
                                <Symbol>USD $</Symbol>
                                <GetItemURI>https://api.dovico.com/Currencies/280/?version=2</GetItemURI>
                            </FixedCurrency>
                            <Tax1>0</Tax1>
                            <Tax2>0</Tax2>
                            <Description>Hotel costs</Description>
                            <Reimbursable>T</Reimbursable>
                            <Billable>F</Billable>
                            <AttachmentName></AttachmentName>
                            <Archive>F</Archive>
                            <Integrate></Integrate>
                            <CustomFields>
                                <CustomField>
                                    <ID>40ab9eb9-1f3e-4e8b-ae4e-ff4499018751</ID>
                                    <TemplateID>116</TemplateID>
                                    <Name>numeric for expense</Name>
                                    <Values>
                                        <Value>0</Value>
                                    </Values>
                                    <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/116/?version=2</GetCustomTemplateURI>
                                </CustomField>
                            </CustomFields>
                        </ExpenseEntry>
                    </ExpenseEntries>
                </ExpenseSheet>
            </ExpenseSheets>
        </Result>

Fields for Result
ExpenseSheets (will return one ExpenseSheet node)

Fields for ExpenseSheet
ID (long)
Employee (node containing information about the Employee the expense sheet is for)
Manager (node containing information about the Employee who is the manager of the expense sheet)
Project (node containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (node containing zero or more ExpenseEntry nodes)

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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).

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

Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (node containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (node containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (node containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField nodes)

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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).

Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)

Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value nodes)
GetCustomTemplateURI (string - URI to pull information about this custom template)

Fields for CustomField's Values node
Value (string, date, or double - based on the custom template's type)

Example JSON response:
 
        {
        "ExpenseSheets":
            [
                {
                    "ID":"139",
                    "Employee":
                    {
                        "ID":"111",
                        "Name":"Smith, John",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/111\/?version=2"
                    },
                    "Manager":
                    {
                        "ID":"200",
                        "Name":"Young, Christie",
                        "GetItemURI":"https:\/\/api.dovico.com\/Employees\/200\/?version=2"
                    },
                    "Project":
                    {
                        "ID":"1300",
                        "Name":"Development Project: A-211",
                        "GetItemURI":"https:\/\/api.dovico.com\/Projects\/1300\/?version=2"
                    },
                    "Status":"A",
                     "Title":"Training",
                    "Description":"",
                    "Reimbursed":"F",
                    "CheckDate":"1900-01-01",
                    "CheckNumber":"",
                    "Approver":"Approved by Smith, John on 7/21/2011",
                    "ExpenseEntries":
                    [
                        {
                            "ID":"153",
                            "ExpenseCategory":
                            {
                                "ID":"0",
                                "Name":"",
                                "GetItemURI":"N\/A"
                            },
                            "Date":"2011-07-01",
                            "PurchaseOrder":"",
                            "ReferenceNumber":"",
                            "Quantity":"0",
                            "CostPerUnit":"0",
                            "Amount":"496",
                            "Currency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Markup":"-100",
                            "FixedAmount":"0",
                            "FixedCurrency":
                            {
                                "ID":"280",
                                "Symbol":"USD $",
                                "GetItemURI":"https:\/\/api.dovico.com\/Currencies\/280\/?version=2"
                            },
                            "Tax1":"0",
                            "Tax2":"0",
                            "Description":"Hotel costs",
                            "Reimbursable":"T",
                            "Billable":"F",
                            "AttachmentName":"",
                            "Archive":"F",
                            "Integrate":"",
                            "CustomFields":
                            [
                                {
                                    "ID":"40ab9eb9-1f3e-4e8b-ae4e-ff4499018751",
                                    "TemplateID":"116",
                                    "Name":"numeric for expense",
                                    "Values":
                                    [
                                        "0"
                                    ],
                                    "GetCustomTemplateURI":"https:\/\/api.dovico.com\/CustomFieldTemplates\/116\/?version=2"
                                }
                            ]
                        }
                    ]
                }
            ]
        }

Fields
ExpenseSheets (will return one ExpenseSheet object)


Fields for ExpenseSheet
ID (long)
Employee (object containing information about the Employee the expense sheet is for)
Manager (object containing information about the Employee who is the manager of the expense sheet)
Project (object containing information about the Project the expense sheet is for)
Status (string - the status of the sheet. possible values are: A (approved - to be reimbursed), P (approved - reimbursed/paid), N (not submitted), U (under review), or R (rejected))
Title (string)
Description (string)
Reimbursed (string - 'T' or 'F')
CheckDate (string - in the format yyyy-MM-dd)
CheckNumber (string)
Approver (string)
ExpenseEntries (array containing zero or more ExpenseEntry objects)


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)

NOTE: The URI field will be set to 'N/A' if the expense sheet has no manager assigned (0 ID).


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


Fields for ExpenseEntry
ID (long or Guid - If the Sheet has a status of A (approved - to be reimbursed) or P (approved - reimbursed/paid) then the ID is a long. Otherwise, it's a guid.)
ExpenseCategory (object containing information about the Expense Category this expense entry has selected)
Date (string - in the format yyyy-MM-dd)
PurchaseOrder (string)
ReferenceNumber (string)
Quantity (double - US English format)
CostPerUnit (double - US English format)
Amount (double - US English format)
Currency (object containing information about the Currency this expense entry has selected)
Markup (double - US English format)
FixedAmount (double - US English format)
FixedCurrency (object containing information about the Fixed Currency this expense entry has selected)
Tax1 (double - US English format)
Tax2 (double - US English format)
Description (string)
Reimbursable (string - 'T' or 'F')
Billable (string - 'T' or 'F')
AttachmentName (string)
Archive (string - 'T' or 'F')
Integrate (string of XML)
CustomFields (will return zero or more CustomField objects)


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

NOTE: The URI field will be set to 'N/A' if the expense entry has no expense category assigned (0 ID).


Fields for Currency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for FixedCurrency
ID (long)
Symbol (string)
GetItemURI (string - URI to pull information about the currency)


Fields for CustomField
ID (long/Guid - a long if the expense entry is approved (status is A or P). A Guid if the expense entry is not yet approved.)
TemplateID (long)
Name (string)
Values (will return one or more Value objects)
GetCustomTemplateURI (string - URI to pull information about this custom template)


Fields for CustomField's Values object
Value (string, date, or double - based on the custom template's type)





Delete an Expense Entry


DELETE ExpenseEntries/{sExpenseEntryID}/

Deletes the Expense Entry specified.

Security Check: The user must have Software Access set to 'All' or 'Time and Expense Entry only' and have Delete permissions to 'Approved Expenses' or Access to the 'Timesheet - Expenses' tool.

Example XML request:
 
        URI: https://api.dovico.com/ExpenseEntries/{ExpenseEntryID}/?version=2
        Method: DELETE
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/355b4188-cafa-40a0-8577-a55a0e98fef3/?version=2" --request DELETE -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example JSON request:
 
        URI: https://api.dovico.com/ExpenseEntries/{ExpenseEntryID}/?version=2
        Method: DELETE
        Accept: application/json
 
        Sample request syntax using Win32 cURL:
        curl -k "https://api.dovico.com/ExpenseEntries/355b4188-cafa-40a0-8577-a55a0e98fef3/?version=2" --request DELETE -H "Accept: application/json" -H "Authorization: WRAP access_token=""client=36bb7f2f29474d88bf35c4a89cdcfb34.593&user_token=e7d1e55015ee4ecebe5298cb439344fd.593"""
 
 
Example XML response:
 
        [Nothing is returned]
 
        NOTE: If the expense entry that was deleted is the last one for that expense sheet, the sheet will be deleted too.
 
 
Example JSON response:
 
        [Nothing is returned]
 
        NOTE: If the expense entry that was deleted is the last one for that expense sheet, the sheet will be deleted too.