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 |
---|---|---|
modifiedSince | Return web timesheets modified since a particular date and time | modifiedSince=2013-02-28T16:45:00 |
treeName and treeBranch | Return a web timesheets assigned to a nominated branch of a nominated tree | treeName=Colour-AUS&treeBranch=Blue |
status | Return a list of web timesheets for a particular status | status=Active |
Security Linked Menu
Menu Item | Located |
---|---|
Timesheet Entry | Data 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>