Back to Service

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>

Download the XSD