Skip to main content
Skip table of contents

CRM Web Timesheet

URL

Verbs

Function

/CRMWebInputTimesheet/<employee>

GET

Query a list of web timesheets for an employee

/CRMWebInputTimesheet/<employee>/<weekending>

GET

Query a single web timesheet for an employee

/CRMWebInputTimesheet/<employee>

POST

Create a new web timesheet for an employee

/CRMWebInputTimesheet/<employee>/<weekending>

POST

Update an existing web timesheet for an employee

  • Note that currently only detailed timesheet lines are supported for POST calls

Supported modifiers

Query String

Definition

Sample
modifiedSinceReturn web timesheets modified since a particular date and timemodifiedSince=2013-02-28T16:45:00
treeName and treeBranchReturn a web timesheets assigned to a nominated branch of a nominated treetreeName=Colour-AUS&treeBranch=Blue
statusReturn a list of web timesheets for a particular statusstatus=Active

Security Linked Menu

Menu Item
Located
Timesheet EntryData Entry / Job Cost

Sample XML Response for detailed line items

<?xml version="1.0" encoding="UTF-8"?>
<CRMWebInputTimesheet>
    <Edition>3</Edition>
    <OidString>6283.48</OidString>
    <WeekEndingDate>2014-05-09</WeekEndingDate>
    <Employee>CLARKC11</Employee>
    <ApprovedTimeStamp>2014-05-01T09:13:18</ApprovedTimeStamp>
    <ApprovedUser>Craig Clark</ApprovedUser>
    <EntryTimeStamp>2014-05-01T09:09:09</EntryTimeStamp>
    <EntryUser>Craig Clark</EntryUser>
    <EventLog/>
    <InputFormat>Detailed</InputFormat>
    <IsSummaryFormat>false</IsSummaryFormat>
    <ModifiedTimeStamp>2014-05-01T09:09:09</ModifiedTimeStamp>
    <ModifiedUser>Craig Clark</ModifiedUser>
    <Branch>03</Branch>
    <Status>Approved</Status>
    <PostingDate>2014-05-31</PostingDate>
    <ResubmittedTimeStamp>T00:00:00</ResubmittedTimeStamp>
    <ResubmittedUser/>
    <RejectedReason/>
    <RejectedTimeStamp>T00:00:00</RejectedTimeStamp>
    <RejectedUser/>
    <StandardText/>
    <SubmittedTimeStamp>2014-05-01T09:12:58</SubmittedTimeStamp>
    <SubmittedUser>Craig Clark</SubmittedUser>
    <UnapprovedTimeStamp>T00:00:00</UnapprovedTimeStamp>
    <UnapprovedUser/>
    <LineItems collection='true' count='7'>
        <CRMWebInputTimesheetLine>
            <OidString>6317.44</OidString>
            <Edition>2</Edition>
            <ApprovedTimeStamp>2014-05-01T09:13:18</ApprovedTimeStamp>
            <ApprovedUser>Craig Clark</ApprovedUser>
            <EntryTimeStamp>2014-05-01T09:09:10</EntryTimeStamp>
            <EntryUser>Craig Clark</EntryUser>
            <IsPayrollLineJC>true</IsPayrollLineJC>
            <IsProcessedByPayroll>false</IsProcessedByPayroll>
            <IsReadyForPayroll>true</IsReadyForPayroll>
            <ModifiedTimeStamp>2014-05-01T09:09:10</ModifiedTimeStamp>
            <ModifiedUser>Craig Clark</ModifiedUser>
            <HRTransType>22001</HRTransType>
            <ActivityCode>LABSER</ActivityCode>
            <JobCode>5000</JobCode>
            <WorkCentre>DEV</WorkCentre>
            <StartTime>09:00:00</StartTime>
            <FinishTime>13:00:00</FinishTime>
            <IsUpdateCallStatus>false</IsUpdateCallStatus>
            <IsWriteOff>false</IsWriteOff>
            <PayClassification/>
            <PayReference/>
            <Quantity>4.0000</Quantity>
            <StandardText>Test Line Tue</StandardText>
            <EffortToComplete>0</EffortToComplete>
            <PercentageComplete>0</PercentageComplete>
            <TimeLineDate>2014-05-06</TimeLineDate>
        </CRMWebInputTimesheetLine>
        <CRMWebInputTimesheetLine>
            <OidString>6317.48</OidString>
            <Edition>2</Edition>
            <ApprovedTimeStamp>2014-05-01T09:13:18</ApprovedTimeStamp>
            <ApprovedUser>Craig Clark</ApprovedUser>
            <EntryTimeStamp>2014-05-01T09:10:54</EntryTimeStamp>
            <EntryUser>Craig Clark</EntryUser>
            <IsPayrollLineJC>true</IsPayrollLineJC>
            <IsProcessedByPayroll>false</IsProcessedByPayroll>
            <IsReadyForPayroll>true</IsReadyForPayroll>
            <ModifiedTimeStamp>2014-05-01T09:10:54</ModifiedTimeStamp>
            <ModifiedUser>Craig Clark</ModifiedUser>
            <HRTransType>22001</HRTransType>
            <ActivityCode>LABSER</ActivityCode>
            <JobCode>5000</JobCode>
            <WorkCentre>SERV</WorkCentre>
            <StartTime>10:00:00</StartTime>
            <FinishTime>14:00:00</FinishTime>
            <IsUpdateCallStatus>false</IsUpdateCallStatus>
            <IsWriteOff>false</IsWriteOff>
            <PayClassification/>
            <PayReference/>
            <Quantity>4.0000</Quantity>
            <StandardText/>
            <EffortToComplete>0</EffortToComplete>
            <PercentageComplete>0</PercentageComplete>
            <TimeLineDate>2014-05-06</TimeLineDate>
        </CRMWebInputTimesheetLine>
        <CRMWebInputTimesheetLine>
            <OidString>6317.49</OidString>
            <Edition>2</Edition>
            <ApprovedTimeStamp>2014-05-01T09:13:18</ApprovedTimeStamp>
            <ApprovedUser>Craig Clark</ApprovedUser>
            <EntryTimeStamp>2014-05-01T09:11:43</EntryTimeStamp>
            <EntryUser>Craig Clark</EntryUser>
            <IsPayrollLineJC>true</IsPayrollLineJC>
            <IsProcessedByPayroll>false</IsProcessedByPayroll>
            <IsReadyForPayroll>true</IsReadyForPayroll>
            <ModifiedTimeStamp>2014-05-01T09:11:43</ModifiedTimeStamp>
            <ModifiedUser>Craig Clark</ModifiedUser>
            <HRTransType>22001</HRTransType>
            <ActivityCode>LABSER</ActivityCode>
            <JobCode>5000</JobCode>
            <WorkCentre>SERV</WorkCentre>
            <StartTime>12:00:00</StartTime>
            <FinishTime>15:00:00</FinishTime>
            <IsUpdateCallStatus>false</IsUpdateCallStatus>
            <IsWriteOff>false</IsWriteOff>
            <PayClassification/>
            <PayReference/>
            <Quantity>3.0000</Quantity>
            <StandardText/>
            <EffortToComplete>0</EffortToComplete>
            <PercentageComplete>0</PercentageComplete>
            <TimeLineDate>2014-05-06</TimeLineDate>
        </CRMWebInputTimesheetLine>
        <CRMWebInputTimesheetLine>
            <OidString>6317.45</OidString>
            <Edition>2</Edition>
            <ApprovedTimeStamp>2014-05-01T09:13:18</ApprovedTimeStamp>
            <ApprovedUser>Craig Clark</ApprovedUser>
            <EntryTimeStamp>2014-05-01T09:09:10</EntryTimeStamp>
            <EntryUser>Craig Clark</EntryUser>
            <IsPayrollLineJC>true</IsPayrollLineJC>
            <IsProcessedByPayroll>false</IsProcessedByPayroll>
            <IsReadyForPayroll>true</IsReadyForPayroll>
            <ModifiedTimeStamp>2014-05-01T09:09:10</ModifiedTimeStamp>
            <ModifiedUser>Craig Clark</ModifiedUser>
            <HRTransType>22001</HRTransType>
            <ActivityCode>LABSER</ActivityCode>
            <JobCode>5000</JobCode>
            <WorkCentre>DEV</WorkCentre>
            <StartTime>09:00:00</StartTime>
            <FinishTime>13:00:00</FinishTime>
            <IsUpdateCallStatus>false</IsUpdateCallStatus>
            <IsWriteOff>false</IsWriteOff>
            <PayClassification/>
            <PayReference/>
            <Quantity>4.0000</Quantity>
            <StandardText>Test Line Wed</StandardText>
            <EffortToComplete>0</EffortToComplete>
            <PercentageComplete>0</PercentageComplete>
            <TimeLineDate>2014-05-07</TimeLineDate>
        </CRMWebInputTimesheetLine>
        <CRMWebInputTimesheetLine>
            <OidString>6317.50</OidString>
            <Edition>2</Edition>
            <ApprovedTimeStamp>2014-05-01T09:13:18</ApprovedTimeStamp>
            <ApprovedUser>Craig Clark</ApprovedUser>
            <EntryTimeStamp>2014-05-01T09:12:51</EntryTimeStamp>
            <EntryUser>Craig Clark</EntryUser>
            <IsPayrollLineJC>true</IsPayrollLineJC>
            <IsProcessedByPayroll>false</IsProcessedByPayroll>
            <IsReadyForPayroll>true</IsReadyForPayroll>
            <ModifiedTimeStamp>2014-05-01T09:12:51</ModifiedTimeStamp>
            <ModifiedUser>Craig Clark</ModifiedUser>
            <HRTransType>22001</HRTransType>
            <ActivityCode>LABSER</ActivityCode>
            <JobCode>5000</JobCode>
            <WorkCentre>MAINT</WorkCentre>
            <StartTime>12:00:00</StartTime>
            <FinishTime>15:00:00</FinishTime>
            <IsUpdateCallStatus>false</IsUpdateCallStatus>
            <IsWriteOff>false</IsWriteOff>
            <PayClassification/>
            <PayReference/>
            <Quantity>3.0000</Quantity>
            <StandardText/>
            <EffortToComplete>0</EffortToComplete>
            <PercentageComplete>0</PercentageComplete>
            <TimeLineDate>2014-05-07</TimeLineDate>
        </CRMWebInputTimesheetLine>
        <CRMWebInputTimesheetLine>
            <OidString>6317.46</OidString>
            <Edition>2</Edition>
            <ApprovedTimeStamp>2014-05-01T09:13:18</ApprovedTimeStamp>
            <ApprovedUser>Craig Clark</ApprovedUser>
            <EntryTimeStamp>2014-05-01T09:09:42</EntryTimeStamp>
            <EntryUser>Craig Clark</EntryUser>
            <IsPayrollLineJC>true</IsPayrollLineJC>
            <IsProcessedByPayroll>false</IsProcessedByPayroll>
            <IsReadyForPayroll>true</IsReadyForPayroll>
            <ModifiedTimeStamp>2014-05-01T09:09:42</ModifiedTimeStamp>
            <ModifiedUser>Craig Clark</ModifiedUser>
            <HRTransType>22001</HRTransType>
            <ActivityCode>LABSER</ActivityCode>
            <JobCode>5000</JobCode>
            <WorkCentre>DEV</WorkCentre>
            <StartTime>09:00:00</StartTime>
            <FinishTime>13:00:00</FinishTime>
            <IsUpdateCallStatus>false</IsUpdateCallStatus>
            <IsWriteOff>false</IsWriteOff>
            <PayClassification/>
            <PayReference/>
            <Quantity>4.0000</Quantity>
            <StandardText>Test Line Wed</StandardText>
            <EffortToComplete>0</EffortToComplete>
            <PercentageComplete>0</PercentageComplete>
            <TimeLineDate>2014-05-08</TimeLineDate>
        </CRMWebInputTimesheetLine>
        <CRMWebInputTimesheetLine>
            <OidString>6317.47</OidString>
            <Edition>2</Edition>
            <ApprovedTimeStamp>2014-05-01T09:13:18</ApprovedTimeStamp>
            <ApprovedUser>Craig Clark</ApprovedUser>
            <EntryTimeStamp>2014-05-01T09:09:57</EntryTimeStamp>
            <EntryUser>Craig Clark</EntryUser>
            <IsPayrollLineJC>true</IsPayrollLineJC>
            <IsProcessedByPayroll>false</IsProcessedByPayroll>
            <IsReadyForPayroll>true</IsReadyForPayroll>
            <ModifiedTimeStamp>2014-05-01T09:09:57</ModifiedTimeStamp>
            <ModifiedUser>Craig Clark</ModifiedUser>
            <HRTransType>22001</HRTransType>
            <ActivityCode>LABSER</ActivityCode>
            <JobCode>5000</JobCode>
            <WorkCentre>DEV</WorkCentre>
            <StartTime>09:00:00</StartTime>
            <FinishTime>13:00:00</FinishTime>
            <IsUpdateCallStatus>false</IsUpdateCallStatus>
            <IsWriteOff>false</IsWriteOff>
            <PayClassification/>
            <PayReference/>
            <Quantity>4.0000</Quantity>
            <StandardText>Test Line Wed</StandardText>
            <EffortToComplete>0</EffortToComplete>
            <PercentageComplete>0</PercentageComplete>
            <TimeLineDate>2014-05-09</TimeLineDate>
        </CRMWebInputTimesheetLine>
    </LineItems>
    <UserDefinedFields collection='true' count='0'/>
    <Trees collection='true' count='0'/>
</CRMWebInputTimesheet>

Sample XML Response for summary line items

<?xml version="1.0" encoding="UTF-8"?>
<CRMWebInputTimesheet>
    <Edition>6</Edition>
    <OidString>6283.21</OidString>
    <WeekEndingDate>2013-07-08</WeekEndingDate>
    <Employee>CLARKC11</Employee>
    <ApprovedTimeStamp>T00:00:00</ApprovedTimeStamp>
    <ApprovedUser/>
    <EntryTimeStamp>2013-07-04T13:26:20</EntryTimeStamp>
    <EntryUser>Craig Clark</EntryUser>
    <EventLog/>
    <InputFormat>Summary</InputFormat>
    <IsSummaryFormat>true</IsSummaryFormat>
    <ModifiedTimeStamp>2013-07-04T13:26:20</ModifiedTimeStamp>
    <ModifiedUser>Craig Clark</ModifiedUser>
    <Branch>03</Branch>
    <Status>Entered</Status>
    <PostingDate>2013-07-31</PostingDate>
    <ResubmittedTimeStamp>T00:00:00</ResubmittedTimeStamp>
    <ResubmittedUser/>
    <RejectedReason/>
    <RejectedTimeStamp>T00:00:00</RejectedTimeStamp>
    <RejectedUser/>
    <StandardText>w/e 8/7</StandardText>
    <SubmittedTimeStamp>T00:00:00</SubmittedTimeStamp>
    <SubmittedUser/>
    <UnapprovedTimeStamp>T00:00:00</UnapprovedTimeStamp>
    <UnapprovedUser/>
    <SummaryLineItems collection='true' count='1'>
        <CRMWebInputTimesheetSummary>
            <OidString>6534.45</OidString>
            <Edition>3</Edition>
            <ApprovedTimeStamp>T00:00:00</ApprovedTimeStamp>
            <ApprovedUser/>
            <EntryTimeStamp>2013-07-04T13:26:37</EntryTimeStamp>
            <EntryUser>Craig Clark</EntryUser>
            <IsPayrollLineJC>false</IsPayrollLineJC>
            <IsProcessedByPayroll>false</IsProcessedByPayroll>
            <IsReadyForPayroll>false</IsReadyForPayroll>
            <ModifiedTimeStamp>2013-07-04T13:26:37</ModifiedTimeStamp>
            <ModifiedUser>Craig Clark</ModifiedUser>
            <ActivityCode>LABSER</ActivityCode>
            <JobCode>5002</JobCode>
            <WorkCentre>SERV</WorkCentre>
            <Notes1/>
            <Notes2/>
            <Notes3/>
            <Notes4/>
            <Notes5/>
            <Notes6/>
            <Notes7/>
            <PayClassification/>
            <PayReference/>
            <Quantity1>0</Quantity1>
            <Quantity2>0</Quantity2>
            <Quantity3>0</Quantity3>
            <Quantity4>0</Quantity4>
            <Quantity5>0</Quantity5>
            <Quantity6>0</Quantity6>
            <Quantity7>0</Quantity7>
        </CRMWebInputTimesheetSummary>
    </SummaryLineItems>
    <UserDefinedFields collection='true' count='0'/>
    <Trees collection='true' count='0'/>
</CRMWebInputTimesheet>
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.