Raw extractsGetInvoicesRaw

GetInvoicesRaw

Reporting API: Returns invoice headers filtered by invoice, customer, state and invoice date.

APIReporting API (raw extracts)
EndpointPOST https://app{server-number}.timelog.com/{account}/Service.asmx
SOAPActionhttp://www.timelog.com/ws/tlp/v4_4/GetInvoicesRaw
Content-Typetext/xml; charset=utf-8
AuthenticationsiteCode, apiID and apiPassword as the first three parameters. See Authentication
Changes dataNo. Safe to retry.
PagingNo: the whole result comes in one response. Narrow it with the filters.

How it works

Filters: invoiceID, customerID, status and an invoice-date window given as STRINGS. The window compares InvoiceDate as an exact timestamp: an endDate without a time excludes invoices dated later that day, while the line / detail extracts widen to whole days. No caching, no chunking. INVOICE AMOUNTS; attention contact and customer reference are personal data.

Parameters

Each parameter has one label: Required, Conditional (required depending on other values) or Optional. Send them in the order shown.

siteCodestring
Required

Your account's site code, from the Reporting API settings.

apiIDstring
Required

The Reporting API ID, from the Reporting API settings.

apiPasswordstring
Required

The Reporting API password, from the Reporting API settings.

invoiceIDinteger
Required

Invoice id. 0 = no filter.

customerIDinteger
Required

Customer id. 0 = no filter.

statusinteger
Required

Use -1 for no filter. Invoice state. 0 = drafts only; 1 = state >= 1; 2 = state >= 2; 3 = checked; >= 4 = nothing.

startDatestring

Optional. InvoiceDate >= value. Send yyyy-MM-dd.

endDatestring

Optional. Unparseable = no upper limit.

Request

POST /{account}/Service.asmx HTTP/1.1
Host: app{server-number}.timelog.com
Content-Type: text/xml; charset=utf-8
SOAPAction: "http://www.timelog.com/ws/tlp/v4_4/GetInvoicesRaw"

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
               xmlns:tlp="http://www.timelog.com/ws/tlp/v4_4">
  <soap:Body>
    <tlp:GetInvoicesRaw>
      <tlp:siteCode>{siteCode}</tlp:siteCode>
      <tlp:apiID>{apiID}</tlp:apiID>
      <tlp:apiPassword>{apiPassword}</tlp:apiPassword>
      <tlp:invoiceID>0</tlp:invoiceID>
      <tlp:customerID>0</tlp:customerID>
      <tlp:status>-1</tlp:status>
      <tlp:startDate>{startDate}</tlp:startDate>
      <tlp:endDate>{endDate}</tlp:endDate>
    </tlp:GetInvoicesRaw>
  </soap:Body>
</soap:Envelope>
Replace every {…} placeholder with your own value.

Response

The result is an XML document inside GetInvoicesRawResult: a tlp:Invoices root with one tlp:Invoice element per record. Check the response format first: the same slot also carries the empty result and errors.

Order: InvoiceNo ascending.

tlp:InvoiceInvoiceRaw[]

One element per record. Fields without a value are left out of the element, so treat every field as optional.

Example response

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

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Body>
    <GetInvoicesRawResponse xmlns="http://www.timelog.com/ws/tlp/v4_4">
      <GetInvoicesRawResult>
        <tlp:Invoices xmlns:tlp="http://www.timelog.com/XML/Schema/tlp/v5_0">
          <tlp:Invoice ID="1001" GUID="3F2504E0-4F89-41D3-9A0C-0305E82C3312">
            <tlp:InvoiceNo>1001</tlp:InvoiceNo>
            <tlp:Header>Example text</tlp:Header>
            <tlp:Text>Example text</tlp:Text>
            <tlp:InvoiceDate>2026-10-01T00:00:00</tlp:InvoiceDate>
            <tlp:DueDate>2026-10-01T00:00:00</tlp:DueDate>
            <tlp:Amount>950.0000</tlp:Amount>
            <tlp:AmountSystemCurrency>950.0000</tlp:AmountSystemCurrency>
            <tlp:Status>1</tlp:Status>
            <tlp:Type>0</tlp:Type>
            <tlp:CustomerID>12</tlp:CustomerID>
            <tlp:CustomerName>Example Customer A/S</tlp:CustomerName>
            <tlp:CustomerNo>1001</tlp:CustomerNo>
            <tlp:CustomerAddress1>Example text</tlp:CustomerAddress1>
            <tlp:CustomerAddress2>Example text</tlp:CustomerAddress2>
            <tlp:CustomerAddress3>Example text</tlp:CustomerAddress3>
            <tlp:CustomerZipCode>1000</tlp:CustomerZipCode>
            <tlp:CustomerCity>Copenhagen</tlp:CustomerCity>
            <tlp:CustomerState>Example text</tlp:CustomerState>
            <tlp:CustomerCountry>Example text</tlp:CustomerCountry>
            <tlp:CustomerCountryID>12</tlp:CustomerCountryID>
            <tlp:PaymentTermID>12</tlp:PaymentTermID>
            <tlp:PaymentTermText>Example text</tlp:PaymentTermText>
            <tlp:CurrencyAbb>DKK</tlp:CurrencyAbb>
            <tlp:CurrencyRate>950.0000</tlp:CurrencyRate>
            <tlp:DefaultVAT>0.0000</tlp:DefaultVAT>
            <tlp:AddVAT>0</tlp:AddVAT>
            <tlp:NetAmount>950.0000</tlp:NetAmount>
            <tlp:NetAmountSystemCurrency>950.0000</tlp:NetAmountSystemCurrency>
            <tlp:VATIncluded>0.0000</tlp:VATIncluded>
            <tlp:VATIncludedSystemCurrency>0.0000</tlp:VATIncludedSystemCurrency>
            <tlp:ProjectID>12</tlp:ProjectID>
            <tlp:ProjectNo>1001</tlp:ProjectNo>
            <tlp:PurchaseNo>1001</tlp:PurchaseNo>
            <tlp:ContactFullName>Anna Example</tlp:ContactFullName>
            <tlp:DepartmentID>12</tlp:DepartmentID>
            <tlp:DepartmentTree>Example text</tlp:DepartmentTree>
            <tlp:ExternalInvoiceNo>1001</tlp:ExternalInvoiceNo>
            <tlp:CustomerReference>Example text</tlp:CustomerReference>
            <tlp:ExternalInvoiceStatus>Example text</tlp:ExternalInvoiceStatus>
            <tlp:RelatesToInvoiceID>12</tlp:RelatesToInvoiceID>
            <tlp:InternalNote>Example text</tlp:InternalNote>
            <tlp:LegalEntityID>12</tlp:LegalEntityID>
            <tlp:InvoiceTemplateID>12</tlp:InvoiceTemplateID>
            <tlp:IsIgnoredWhenTransfer>0</tlp:IsIgnoredWhenTransfer>
            <tlp:IsReadyForInvoicing>0</tlp:IsReadyForInvoicing>
          </tlp:Invoice>
        </tlp:Invoices>
      </GetInvoicesRawResult>
    </GetInvoicesRawResponse>
  </soap:Body>
</soap:Envelope>

Example error

Wrong credentials, or a call over plain HTTP:

HTTP/1.1 401 Unauthorized
Content-Type: text/xml; charset=utf-8

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Body>
    <GetInvoicesRawResponse xmlns="http://www.timelog.com/ws/tlp/v4_4">
      <GetInvoicesRawResult>
        <tlp:Errors xmlns:tlp="http://www.timelog.com/XML/Schema/tlp/v4_4">
          <tlp:Error>Access denied. Check siteCode, apiID, apiPassword and SSL settings</tlp:Error>
        </tlp:Errors>
      </GetInvoicesRawResult>
    </GetInvoicesRawResponse>
  </soap:Body>
</soap:Envelope>
Data and No rows are illustrative examples: the format follows the service's documented output, with made-up values (only one record shown). Access denied was recorded from a real call with wrong credentials (to GetCustomersShortList; every data method answers the same way).

Errors

The errors every method can return (access denied, operation failed, invalid request) are listed once in Responses and errors.

This method has no errors of its own beyond the shared ones.