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>