Method Details for GetInvoiceLinesRaw.
Gets a list of invoice lines
Parameters
- siteCode String Unique identification for your TimeLog account
- apiID String The API ID
- apiPassword String The API password
- invoiceLineID Integer ID of specific invoiceline. Set to 0 to get all invoices
- customerID Integer ID of specific customer. Set to 0 to get all customers
- projectID Integer ID of specific project. Set to 0 to get all projects
- invoiceID Integer ID of specific invoice. Set to 0 to get 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 line objects in XML format
Result Example
<?xml version="1.0" encoding="utf-8"?> <tlp:InvoiceLines 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/InvoiceLinesRaw.xsd"> <tlp:InvoiceLine ID="1095"> <tlp:InvoiceID>131</tlp:InvoiceID> <tlp:InvoiceNo>2003-0067</tlp:InvoiceNo> <tlp:Date>2003-08-28T00:00:00</tlp:Date> <tlp:Text>Direct mail</tlp:Text> <tlp:Quantity>1.0000</tlp:Quantity> <tlp:Rate>350.0000</tlp:Rate> <tlp:RateSystemCurrency>350.0000</tlp:RateSystemCurrency> <tlp:Amount>350.0000</tlp:Amount> <tlp:AmountSystemCurrency>350.0000</tlp:AmountSystemCurrency> <tlp:ProjectID>77</tlp:ProjectID> <tlp:ProjectName>2003-0008 PPMcentral 1.0</tlp:ProjectName> <tlp:ProjectNo>2003-0008</tlp:ProjectNo> <tlp:VAT>18.0000</tlp:VAT> <tlp:Discount>0.0000</tlp:Discount> <tlp:UnitType>6</tlp:UnitType> <tlp:ProductNo></tlp:ProductNo> </tlp:InvoiceLine> <tlp:InvoiceLine ID="1096"> <tlp:InvoiceID>131</tlp:InvoiceID> <tlp:InvoiceNo>2003-0067</tlp:InvoiceNo> <tlp:Date>2003-08-28T00:00:00</tlp:Date> <tlp:Text>Brochure</tlp:Text> <tlp:Quantity>3.5000</tlp:Quantity> <tlp:Rate>350.0000</tlp:Rate> <tlp:Amount>1225.0000</tlp:Amount> <tlp:ProjectID>77</tlp:ProjectID> <tlp:ProjectName>2003-0008 PPMcentral 1.0</tlp:ProjectName> <tlp:ProjectNo>2003-0008</tlp:ProjectNo> <tlp:VAT>18.0000</tlp:VAT> <tlp:Discount>0.0000</tlp:Discount> <tlp:UnitType>6</tlp:UnitType> <tlp:ProductNo></tlp:ProductNo> </tlp:InvoiceLine> </tlp:InvoiceLines>
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="InvoiceLines" > <xsd:complexType> <xsd:sequence> <xsd:element name="InvoiceLine" type="tlp:InvoiceLineRaw_Type" minOccurs="0" maxOccurs="unbounded" /> </xsd:sequence> </xsd:complexType> <xsd:key name="InvoiceLine_Key"> <xsd:selector xpath=".//tlp:InvoiceLine" /> <xsd:field xpath="@ID" /> </xsd:key> </xsd:element> <xsd:complexType name="InvoiceLineRaw_Type"> <xsd:sequence> <xsd:element name="InvoiceID" type="xsd:positiveInteger" /> <xsd:element name="InvoiceNo" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="Date" type="xsd:dateTime" /> <xsd:element name="Text" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="Quantity" type="xsd:decimal" /> <xsd:element name="Rate" type="xsd:decimal" /> <xsd:element name="RateSystemCurrency" type="xsd:decimal" /> <xsd:element name="Amount" type="xsd:decimal" /> <xsd:element name="AmountSystemCurrency" type="xsd:decimal" /> <xsd:element name="ProjectID" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1" /> <xsd:element name="ProjectName" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="ProjectNo" type="xsd:string" minOccurs="0" maxOccurs="1" /> <xsd:element name="VAT" type="xsd:decimal" minOccurs="0" maxOccurs="1" /> <xsd:element name="Discount" type="xsd:decimal" minOccurs="0" maxOccurs="1" /> <xsd:element name="UnitType" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1" /> <xsd:element name="ProductNo" type="xsd:string" minOccurs="0" maxOccurs="1" /> </xsd:sequence> <xsd:attribute name="ID" type="xsd:positiveInteger" use="required"></xsd:attribute> </xsd:complexType> </xsd:schema>