Method Details for GetInvoicesRaw.
Gets a list of invoices
Parameters
- siteCode String Unique identification for your TimeLog account
- apiID String The API ID
- apiPassword String The API password
- invoiceID Integer ID of specific invoice. Set to 0 to get all invoices
- customerID Integer ID of specific customer. Set to 0 to get all invoices
- status Integer 0 for draft invoice; 1 for booked, checked and overdue invoices; 2 for overdue invoices; 3 for checked invoices; -1 for all invoices
- startDate String Limits result to invoices with invoice date on or later than this date
- endDate String Limits result to invoices with invoice date on or prior to this date
Returns
A list of invoice objects in XML format
Result Example
<?xml version="1.0" encoding="utf-8"?> <tlp:Invoices xmlns:tlp="http://www.timelog.com/XML/Schema/tlp/v4_4" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.timelog.com/XML/Schema/tlp/v4_4 http://www.timelog.com/api/xsd/InvoicesRaw.xsd" > <tlp:Invoice ID="277" GUID="795A4082-66A9-E511-80DA-005056B220E2"> <tlp:InvoiceNumber>2004-0206</tlp:InvoiceNumber> <tlp:Header>Invoice layout</tlp:Header> <tlp:Text></tlp:Text> <tlp:InvoiceDate>2004-12-03T00:00:00</tlp:InvoiceDate> <tlp:DueDate>2004-12-17T00:00:00</tlp:DueDate> <tlp:Amount>39037.5000</tlp:Amount> <tlp:AmountSystemCurrency>245920.6350</tlp:AmountSystemCurrency> <tlp:Status>3</tlp:Status> <tlp:Type>0</tlp:Type> <tlp:CustomerID>333</tlp:CustomerID> <tlp:CustomerName>Microsoft</tlp:CustomerName> <tlp:CustomerNo>03-0376</tlp:CustomerNo> <tlp:CustomerAddress1>Kullerod</tlp:CustomerAddress1> <tlp:CustomerAddress2></tlp:CustomerAddress2> <tlp:CustomerAddress3></tlp:CustomerAddress3> <tlp:CustomerZipCode>N-0032</tlp:CustomerZipCode> <tlp:CustomerCity>HASLE</tlp:CustomerCity> <tlp:CustomerState></tlp:CustomerState> <tlp:CustomerCountry>Norway</tlp:CustomerCountry> <tlp:CustomerCountryID>156</tlp:CustomerCountryID> <tlp:PaymentTermID>1</tlp:PaymentTermID> <tlp:PaymentTermText>Payment terms: 30 days net If you miss a due date interests pursuant to applicable laws are added.</tlp:PaymentTermText> <tlp:CurrencyAbb>USD</tlp:CurrencyAbb> <tlp:CurrencyRate>629.9600</tlp:CurrencyRate> <tlp:DefaultVAT>25.0000</tlp:DefaultVAT> <tlp:AddVAT>1</tlp:AddVAT> <tlp:NetAmount>31230.0000</tlp:NetAmount> <tlp:NetAmountSystemCurrency>196736.5080</tlp:NetAmountSystemCurrency> <tlp:VATIncluded>7807.5000</tlp:VATIncluded> <tlp:VATIncludedSystemCurrency>49184.1270</tlp:VATIncludedSystemCurrency> <tlp:ProjectID>73</tlp:ProjectID> <tlp:ProjectNo>0069</tlp:ProjectNo> <tlp:PurchaseNo></tlp:PurchaseNo> <tlp:ContactFullName></tlp:ContactFullName> <tlp:DepartmentID>1</tlp:DepartmentID> <tlp:DepartmentTree>TimeLog A/S</tlp:DepartmentTree> <tlp:ExternalInvoiceNo></tlp:ExternalInvoiceNo> <tlp:CustomerReference></tlp:CustomerReference> <tlp:ExternalInvoiceStatus>Draft</tlp:ExternalInvoiceStatus> <tlp:RelatesToInvoiceID>276</tlp:RelatesToInvoiceID> <tlp:LegalEntityID>1</tlp:LegalEntityID> <tlp:InvoiceTemplateID>1</tlp:InvoiceTemplateID> <tlp:IsIgnoredWhenTransfer>0</tlp:IsIgnoredWhenTransfer> <tlp:IsReadyForInvoicing>0</tlp:IsReadyForInvoicing> </tlp:Invoice> </tlp:Invoices>
Result Schema
<?xml version="1.0" encoding="utf-8"?> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tlp="http://www.timelog.com/XML/Schema/tlp/v4_4" targetNamespace="http://www.timelog.com/XML/Schema/tlp/v4_4" elementFormDefault="qualified" attributeFormDefault="unqualified"> <xsd:element name="Invoices"> <xsd:complexType> <xsd:sequence> <xsd:element name="Invoice" type="tlp:InvoiceRaw_Type" minOccurs="0" maxOccurs="unbounded" /> </xsd:sequence> </xsd:complexType> <xsd:key name="Invoice_Key"> <xsd:selector xpath=".//tlp:Invoice" /> <xsd:field xpath="@ID" /> </xsd:key> </xsd:element> <xsd:complexType name="InvoiceRaw_Type"> <xsd:sequence> <xsd:element name="InvoiceNumber" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="Header" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="Text" type="xsd:string" minOccurs="0" maxOccurs="1"/> <xsd:element name="InvoiceDate" type="xsd:dateTime" /> <xsd:element name="DueDate" type="xsd:dateTime" minOccurs="0" maxOccurs="1"/> <xsd:element name="Amount" type="xsd:decimal" /> <xsd:element name="AmountSystemCurrency" type="xsd:decimal" /> <xsd:element name="Status" type="xsd:unsignedByte" /> <xsd:element name="Type" type="xsd:unsignedByte" /> <xsd:element name="CustomerID" type="xsd:positiveInteger" /> <xsd:element name="CustomerName" type="xsd:string" /> <xsd:element name="CustomerNo" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerAddress1" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerAddress2" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerAddress3" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerZipCode" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerCity" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerState" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerCountry" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerCountryID" type="xsd:positiveInteger" /> <xsd:element name="PaymentTermID" type="xsd:positiveInteger" /> <xsd:element name="PaymentTermText" type="xsd:string" /> <xsd:element name="CurrencyAbb" type="xsd:string" /> <xsd:element name="CurrencyRate" type="xsd:decimal" /> <xsd:element name="DefaultVAT" type="xsd:decimal" /> <xsd:element name="AddVAT" type="xsd:boolean" /> <xsd:element name="NetAmount" type="xsd:decimal" /> <xsd:element name="NetAmountSystemCurrency" type="xsd:decimal" /> <xsd:element name="VATIncluded" type="xsd:decimal" /> <xsd:element name="VATIncludedSystemCurrency" type="xsd:decimal" /> <xsd:element name="ProjectID" type="xsd:positiveInteger" /> <xsd:element name="ProjectNo" type="xsd:string" /> <xsd:element name="PurchaseNo" type="xsd:string" /> <xsd:element name="ContactFullName" type="xsd:string" /> <xsd:element name="DepartmentID" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1" /> <xsd:element name="DepartmentTree" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="ExternalInvoiceNo" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="CustomerReference" type="xsd:string" minOccurs="0" maxOccurs="1"/> <xsd:element name="ExternalInvoiceStatus" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="RelatesToInvoiceID" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1" /><!-- Voucher reference for invoice --> <xsd:element name="InternalNote" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="LegalEntityID" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1" /> <xsd:element name="InvoiceTemplateID" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1" /> <xsd:element name="IsIgnoredWhenTransfer" type="xsd:boolean" /> <xsd:element name="IsReadyForInvoicing" type="xsd:boolean" /> </xsd:sequence> <xsd:attribute name="ID" type="xsd:positiveInteger" use="required"></xsd:attribute> </xsd:complexType> </xsd:schema>