Back to Service

Method Details for GetProjectsRaw.

Gets a list of projects

Parameters

  • siteCode String Unique identification for your TimeLog account
  • apiID String The API ID
  • apiPassword String The API password
  • projectID Integer ID of specific project. Set to 0 to get all projects
  • status Integer 0 for inactive projects; 1 for active projects; -2 for all projects
  • customerID Integer ID of specific customer. Set to 0 to get all projects
  • projectManagerID Integer ID of specific employee. Set to 0 to get all projects

Returns

A list of project objects in XML format

Result Example

<?xml version="1.0" encoding="utf-8"?>
<tlp:Projects
	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/ProjectsRaw.xsd" >
  <tlp:Project ID="740" GUID="8a7e790b-deb2-4ed3-a6be-e5dca300b2c8">
    <tlp:Name>Webinar</tlp:Name>
    <tlp:No>P07.0080</tlp:No>
    <tlp:Status>1</tlp:Status>
    <tlp:Department>3</tlp:Department>
    <tlp:OrderedByDepartment>1</tlp:OrderedByDepartment>
    <tlp:ProjectStartDate>2015-03-01</tlp:ProjectStartDate>
    <tlp:ProjectEndDate>2015-09-01</tlp:ProjectEndDate>
    <tlp:ProjectLink>https://oursecret.sharepoint.com/projectpage</tlp:ProjectLink>
    <tlp:Description>This project was confirmed by our CEO</tlp:Description>
    <tlp:CustomerID>1</tlp:CustomerID>
    <tlp:CustomerName>TimeLog ApS</tlp:CustomerName>
    <tlp:CustomerNo>02.0000</tlp:CustomerNo>
    <tlp:PMID>20</tlp:PMID>
    <tlp:PMInitials>PWP</tlp:PMInitials>
    <tlp:PMFullName>Peder Wuth Pedersen</tlp:PMFullName>
    <tlp:AccountManagerID>373</tlp:AccountManagerID>
    <tlp:AccountManagerInitials>JOL</tlp:AccountManagerInitials>
    <tlp:AccountManagerFullName>Jacob Olmfeldt</tlp:AccountManagerFullName>
	<tlp:PartnerID>1178</tlp:PartnerID>
	<tlp:PartnerInitials>BRO</tlp:PartnerInitials>
	<tlp:PartnerFullName>Bryan Rønnex</tlp:PartnerFullName>
    <tlp:ProjectTypeID>16</tlp:ProjectTypeID>
    <tlp:ProjectTypeName>Internal - Support</tlp:ProjectTypeName>
    <tlp:ProjectCategoryID>2</tlp:ProjectCategoryID>
    <tlp:ProjectCategoryName>Project</tlp:ProjectCategoryName>
    <tlp:BudgetAmountFixedPriceTasks>[OBSOLETE from v6.0.5]</tlp:BudgetAmountFixedPriceTasks>
    <tlp:BudgetAmountFixedPriceProject>[OBSOLETE from v6.0.5]</tlp:BudgetAmountFixedPriceProject>
    <tlp:BudgetAmountTimeAndMaterial>[OBSOLETE from v6.0.5 - same value as tlp:BudgetAmount]</tlp:BudgetAmountTimeAndMaterial>
    <tlp:BudgetAmountExpenses>5000</tlp:BudgetAmountExpenses>
    <tlp:BudgetAmountTravel>2750</tlp:BudgetAmountTravel>
    <tlp:BudgetAmountWorkCurrency>100</tlp:BudgetAmountWorkCurrency>
    <tlp:BudgetAmountExpenseCurrency>200</tlp:BudgetAmountExpenseCurrency>
    <tlp:BudgetAmountTravelCurrency>300</tlp:BudgetAmountTravelCurrency>
    <tlp:BudgetHoursFixedPriceTasks>[OBSOLETE from v6.0.5]</tlp:BudgetHoursFixedPriceTasks>
    <tlp:BudgetHoursFixedPriceProject>[OBSOLETE from v6.0.5]</tlp:BudgetHoursFixedPriceProject>
    <tlp:BudgetHoursTimeAndMaterial>[OBSOLETE from v6.0.5 - same value as tlp:BudgetHours]</tlp:BudgetHoursTimeAndMaterial>
    <tlp:BudgetAmount>23000</tlp:BudgetAmount>
    <tlp:BudgetHours>23</tlp:BudgetHours>
    <tlp:CreatedAt>2015-03-18T14:22:40.103</tlp:CreatedAt>
    <tlp:CreatedByEmployeeId>1</tlp:CreatedByEmployeeId>
    <tlp:CreatedBy>AL</tlp:CreatedBy>
    <tlp:LastModifiedAt>2015-03-26T10:35:59.647</tlp:LastModifiedAt>
    <tlp:LastModifiedByEmployeeId>1</tlp:LastModifiedByEmployeeId>
    <tlp:LastModifiedBy>AL</tlp:LastModifiedBy>
    <tlp:ProjectStatusName>Ongoing</tlp:ProjectStatusName>
    <tlp:ContactFullName>Peter Smith</tlp:ContactFullName>
    <tlp:ContactEmail>PS@timelog.com</tlp:ContactEmail>
    <tlp:InternalProject>0</tlp:InternalProject>
    <tlp:PONumber>PO15386</tlp:PONumber>
    <tlp:ProjectStage>Idea</tlp:ProjectStage>
    <tlp:CurrencyISOCode>DKK</tlp:CurrencyISOCode>
    <tlp:CurrencyRate>100.0000</tlp:CurrencyRate>
    <tlp:IsMultiCustomerProject>0</tlp:IsMultiCustomerProject>
    <tlp:LegalEntityID>1</tlp:LegalEntityID>
  </tlp:Project>
</tlp:Projects>

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="Projects" >
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element name="Project" type="tlp:ProjectRaw_Type" minOccurs="0" maxOccurs="unbounded" />
      </xsd:sequence>
    </xsd:complexType>
    <xsd:key name="Project_Key">
      <xsd:selector xpath=".//tlp:Project" />
      <xsd:field xpath="@ID" />
    </xsd:key>
  </xsd:element>

  <xsd:complexType name="ProjectRaw_Type">
    <xsd:sequence>
      <xsd:element name="Name" type="xsd:string" />
      <xsd:element name="No" type="xsd:string" minOccurs="0" maxOccurs="1" />
      <xsd:element name="Status" type="xsd:byte" />
      <xsd:element name="Department" type="xsd:positiveInteger" />
      <xsd:element name="OrderedByDepartment" type="xsd:positiveInteger" />
      <xsd:element name="ProjectStartDate" type="xsd:dateTime" />
      <xsd:element name="ProjectEndDate" type="xsd:dateTime" />
      <xsd:element name="Link" type="xsd:string" />
      <xsd:element name="Description" type="xsd:string" />
      <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="PMID" type="xsd:positiveInteger" />
      <xsd:element name="PMInitials" type="xsd:string" />
      <xsd:element name="PMFullName" type="xsd:string" />
      <xsd:element name="AccountManagerID" type="xsd:positiveInteger" />
      <xsd:element name="AccountManagerInitials" type="xsd:string" />
      <xsd:element name="AccountManagerFullName" type="xsd:string" />
      <xsd:element name="PartnerID" type="xsd:positiveInteger" />
      <xsd:element name="PartnerInitials" type="xsd:string" />
      <xsd:element name="PartnerFullName" type="xsd:string" />
      <xsd:element name="ProjectTypeID" type="xsd:positiveInteger" />
      <xsd:element name="ProjectTypeName" type="xsd:string" />
      <xsd:element name="ProjectCategoryID" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1" />
      <xsd:element name="ProjectCategoryName" type="xsd:string" minOccurs="0" maxOccurs="1" />
      <xsd:element name="BudgetAmountFixedPriceTasks" type="xsd:decimal" /><!-- OBSOLETE from v6.0.5 -->
      <xsd:element name="BudgetAmountFixedPriceProject" type="xsd:decimal" /><!-- OBSOLETE from v6.0.5 -->
      <xsd:element name="BudgetAmountTimeAndMaterial" type="xsd:decimal" /><!-- OBSOLETE from v6.0.5 -->
      <xsd:element name="BudgetAmountExpenses" type="xsd:decimal" />
      <xsd:element name="BudgetAmountTravel" type="xsd:decimal" />
      <xsd:element name="BudgetAmountWorkCurrency" type="xsd:decimal" />
      <xsd:element name="BudgetAmountExpenseCurrency" type="xsd:decimal" />
      <xsd:element name="BudgetAmountTravelCurrency" type="xsd:decimal" />
      <xsd:element name="BudgetHoursFixedPriceTasks" type="xsd:decimal" /><!-- OBSOLETE from v6.0.5 -->
      <xsd:element name="BudgetHoursFixedPriceProject" type="xsd:decimal" /><!-- OBSOLETE from v6.0.5 -->
      <xsd:element name="BudgetHoursTimeAndMaterial" type="xsd:decimal" /><!-- OBSOLETE from v6.0.5 -->
      <xsd:element name="BudgetAmount" type="xsd:decimal" />
      <xsd:element name="BudgetHours" type="xsd:decimal" />
      <xsd:element name="ForecastPercent" type="xsd:decimal" />
      <xsd:element name="CreatedAt" type="xsd:dateTime" />
      <xsd:element name="CreatedByEmployeeId" type="xsd:positiveInteger" />
      <xsd:element name="CreatedBy" type="xsd:string" />
      <xsd:element name="LastModifiedAt" type="xsd:dateTime" />
      <xsd:element name="LastModifiedByEmployeeId" type="xsd:positiveInteger" />
      <xsd:element name="LastModifiedBy" type="xsd:string" />
      <xsd:element name="ProjectStatusName" type="xsd:string" />
      <xsd:element name="ContactID" type="xsd:positiveInteger" />
      <xsd:element name="ContactFullName" type="xsd:string" />
      <xsd:element name="ContactEmail" type="xsd:string" />
      <xsd:element name="InternalProject" type="xsd:boolean" />
      <xsd:element name="PONumber" type="xsd:string" />
      <xsd:element name="ProjectStage" type="xsd:string" />
      <xsd:element name="CurrencyISOCode" type="xsd:string" />
      <xsd:element name="CurrencyRate" type="xsd:decimal" />
      <xsd:element name="IsMultiCustomerProject" type="xsd:boolean" />
      <xsd:element name="LegalEntityID" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1" />
    </xsd:sequence>
    <xsd:attribute name="ID" type="xsd:positiveInteger" use="required" />
    <xsd:attribute name="GUID" type="xsd:string" use="required" />
  </xsd:complexType>

</xsd:schema>

Download the XSD