Get Expense Sheets

Returns an api_GetExpenseSheetsResult array of expenses and related information based on a date range, clients and or usernames of employees.

Request

URL	https://vorexlogin.com/GetExpenseSheets

Type	Params	Values
HEAD	WSUserCredentials	Object
PARAM	dateFrom	dateTime
PARAM	dateTo	dateTime
PARAM	clientNames	string
PARAM	userNames	string
PARAM	outputMessage	OUTPUT String

WSUserCredentials - A custom authentication SOAP header object consisting of:
- UserName
- Password
- CompanyName
clientNames - Specify the clients(s) value(s) by which to filter expenses based on. For multiple clients you have to separate by Comma (,). If Null or Empty ("") this will be ignored.
dateFrom - Specify the earliest expense sheet date. If Null this will be ignored.
dateTo - Specify the latest expense sheet date. If Null this will be ignored.
userNames - Specify the employee username(s) value(s) by which to filter expenses based on. For multiple usernames you have to separate by Comma (,). If Null or Empty ("") this will be ignored.

Example Request

POST /WS/OpenAPI.asmx HTTP/1.1
Host: vorexlogin.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "https://vorexlogin.com/GetExpenseSheets"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <WSUserCredentials xmlns="https://vorexlogin.com/">
      <UserName>string</UserName>
      <Password>string</Password>
      <CompanyName>string</CompanyName>
    </WSUserCredentials>
  </soap:Header>
  <soap:Body>
    <GetExpenseSheets xmlns="https://vorexlogin.com/">
      <dateFrom>dateTime</dateFrom>
      <dateTo>dateTime</dateTo>
      <clientNames>string</clientNames>
      <userNames>string</userNames>
    </GetExpenseSheets>
  </soap:Body>
</soap:Envelope>

Response

Status

Response

Success

GetExpenseSheetsResult:

Array of api_GetExpensesheetResult:
- pkExpenseEntryId (int)
- ExpenseSheetId (int)
- EmployeeName (string)
- ExpenseName (string)
- Client (string)
- Project_Ticket (string)
- ExpenseDate (dateTime)
- ExpenseType(string)
- Billable (boolean)
- Notes (string)
- Amount (decimal)

outputMessage:

Empty String

Failure

GetExpenseSheetsResult:

Returns Null

outputMessage:

"An Error has Occurred while processing the request."

Example Response

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetExpenseSheetsResponse xmlns="https://vorexlogin.com/">
      <GetExpenseSheetsResult>
        <api_GetExpensesheetResult>
          <pkExpenseEntryId>int</pkExpenseEntryId>
          <ExpenseSheetId>int</ExpenseSheetId>
          <EmployeeName>string</EmployeeName>
          <ExpenseName>string</ExpenseName>
          <Client>string</Client>
          <Project_Ticket>string</Project_Ticket>
          <ExpenseDate>dateTime</ExpenseDate>
          <ExpenseType>string</ExpenseType>
          <Billable>boolean</Billable>
          <Reimbursable>boolean</Reimbursable>
          <Notes>string</Notes>
          <Amount>decimal</Amount>
        </api_GetExpensesheetResult>

 </GetExpenseSheetsResult>
      <outputMessage>string</outputMessage>
    </GetExpenseSheetsResponse>
  </soap:Body>
</soap:Envelope>