List Expenses

Overview
Retrieve expense List of the client

URL Format
https://{domain}.mobiwork.com/api/rest/{clientId}/{versionNumber}/expense/list.html?token=XXXXXXXX&userId={userId}

Arguments

clientId required	MobiWork assigned unique ID of the company
versionNumber required	Version number of MobiWork API SDK release. Current version is: 10.0.78
token required	Part of URL as a request parameter and is required in every call to verify access to API calls
userId optional	If provided, this User ID will be taken as a logged in user

Filter or Search Criteria

description	By expense description
status	By status of expense
externalId	By external ID of expense
category	By cateogry of expense
createdDateFrom	By created date of expense
createdDateTo	By created date of expense
dueDateFrom	By due date of expense
dueDateTo	By due date of expense

Return
Returns a list of expense Object(s) if valid arguments and search criteria are provided. If no search criteria is provided the list of a maximum 200 expenses will be returned. Returns an error if not a valid request

Request Body XSD

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
  <xs:element name="request">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="description"/>
        <xs:element ref="status"/>
        <xs:element ref="category"/>
        <xs:element ref="createdDateFrom"/>
        <xs:element ref="externalId"/>
        <xs:element ref="createdDateTo"/>
        <xs:element ref="dueDateFrom"/>
        <xs:element ref="dueDateTo"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="description" type="xs:NCName" minOccurs="0"/>
  <xs:element name="status" type="xs:NCName" minOccurs="0"/>
  <xs:element name="category" type="xs:string" minOccurs="0"/>
  <xs:element name="createdDateFrom" type="xs:string" minOccurs="0"/>
  <xs:element name="externalId" type="xs:integer" minOccurs="0"/>
  <xs:element name="createdDateTo" type="xs:string" minOccurs="0"/>
  <xs:element name="dueDateFrom" type="xs:string" minOccurs="0"/>
  <xs:element name="dueDateTo" type="xs:string" minOccurs="0"/>
</xs:schema>

Response Body XSD

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
  <xs:element name="response">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="expenseList"/>
      </xs:sequence>
      <xs:attribute name="statusCode" use="required" type="xs:integer"/>
      <xs:attribute name="version" use="required" type="xs:NMTOKEN"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="expenseList">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="totalAvailableCount"/>
        <xs:element ref="count"/>
        <xs:element maxOccurs="unbounded" ref="expense"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="totalAvailableCount" type="xs:integer"/>
  <xs:element name="count" type="xs:integer"/>
  <xs:element name="expense">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="customStatusName"/>
        <xs:element ref="amount"/>
        <xs:element ref="categoryName"/>
        <xs:element ref="createdById"/>
        <xs:element ref="createdByName"/>
        <xs:element ref="createdDate"/>
        <xs:element ref="entityId"/>
        <xs:element ref="entityName"/>
        <xs:element ref="entityReferenceId"/>
        <xs:element ref="entityReferenceName"/>
        <xs:element ref="entityType"/>
        <xs:element ref="expenseId"/>
        <xs:element ref="externalId"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="customStatusName" type="xs:NCName"/>
  <xs:element name="amount" type="xs:decimal"/>
  <xs:element name="categoryName" type="xs:string"/>
  <xs:element name="createdById" type="xs:integer"/>
  <xs:element name="createdByName" type="xs:string"/>
  <xs:element name="createdDate" type="xs:string"/>
  <xs:element name="entityId" type="xs:integer"/>
  <xs:element name="entityName">
    <xs:complexType/>
  </xs:element>
  <xs:element name="entityReferenceId" type="xs:integer"/>
  <xs:element name="entityReferenceName">
    <xs:complexType/>
  </xs:element>
  <xs:element name="entityType" type="xs:NCName"/>
  <xs:element name="expenseId" type="xs:integer"/>
  <xs:element name="externalId">
    <xs:complexType/>
  </xs:element>
</xs:schema>

Curl Example

HTTP Method:	POST
Request:	curl -k -X POST "https://www.mobiwork.com/api/rest/12014/5.0.141/expense/list.html?token=COJL8X2FKSLMMRTYCH2B" --header 'content-type: application/xml' --data'<request><status>Status 1</status></request>'
Response:	<?xml version="1.0" encoding="UTF-8" ?> <response version="5.0.141" statusCode="1"> <expenseList> <expense> <customStatusName></customStatusName> <amount></amount> <categoryName>1</categoryName> <createdById>123</createdById> <createdByName></createdByName> <createdDate>Mon Sep 26 06:35:29 EDT 2018</createdDate> <entityId></entityId> <entityName>Name</entityName> <entityReferenceId>160</entityReferenceId> <entityReferenceName></entityReferenceName> <entityType>Type</entityType> <expenseId>10</expenseId> <externalId>33445</externalId> </expense> </expenseList> </response>