JiwaAPI

<back to all web services

SM_TimesheetLinesQuery

Requires Authentication
SM_TimesheetLinesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDqueryGuid?No
RecIDInqueryGuid[]No
SM_Timesheets_RecIDqueryGuid?No
SM_Timesheets_RecIDInqueryGuid[]No
SM_Tasks_RecIDquerystringNo
SM_Tasks_RecIDStartsWithquerystringNo
SM_Tasks_RecIDEndsWithquerystringNo
SM_Tasks_RecIDContainsquerystringNo
SM_Tasks_RecIDLikequerystringNo
SM_Tasks_RecIDBetweenquerystring[]No
SM_Tasks_RecIDInquerystring[]No
StartTimequeryDateTime?No
StartTimeGreaterThanOrEqualToqueryDateTime?No
StartTimeGreaterThanqueryDateTime?No
StartTimeLessThanqueryDateTime?No
StartTimeLessThanOrEqualToqueryDateTime?No
StartTimeNotEqualToqueryDateTime?No
StartTimeBetweenqueryDateTime[]No
StartTimeInqueryDateTime[]No
EndTimequeryDateTime?No
EndTimeGreaterThanOrEqualToqueryDateTime?No
EndTimeGreaterThanqueryDateTime?No
EndTimeLessThanqueryDateTime?No
EndTimeLessThanOrEqualToqueryDateTime?No
EndTimeNotEqualToqueryDateTime?No
EndTimeBetweenqueryNullable<DateTime>[]No
EndTimeInqueryNullable<DateTime>[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
SM_Activities_RecIDquerystringNo
SM_Activities_RecIDStartsWithquerystringNo
SM_Activities_RecIDEndsWithquerystringNo
SM_Activities_RecIDContainsquerystringNo
SM_Activities_RecIDLikequerystringNo
SM_Activities_RecIDBetweenquerystring[]No
SM_Activities_RecIDInquerystring[]No
RowHashquerybyte[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SM_TimesheetLines Parameters:
NameParameterData TypeRequiredDescription
RecIDformGuidNo
SM_Timesheets_RecIDformGuidNo
SM_Tasks_RecIDformstringNo
StartTimeformDateTimeNo
EndTimeformDateTime?No
DescriptionformstringNo
ItemNoformintNo
SM_Activities_RecIDformstringNo
RowHashformbyte[]No
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /xml/reply/SM_TimesheetLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SM_TimesheetLinesQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
  <Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
  <Include xmlns="http://schemas.servicestack.net/types">String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
  <OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
  <Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
  <Take xmlns="http://schemas.servicestack.net/types">0</Take>
  <Description>String</Description>
  <DescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionBetween>
  <DescriptionContains>String</DescriptionContains>
  <DescriptionEndsWith>String</DescriptionEndsWith>
  <DescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionIn>
  <DescriptionLike>String</DescriptionLike>
  <DescriptionStartsWith>String</DescriptionStartsWith>
  <EndTime>0001-01-01T00:00:00</EndTime>
  <EndTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EndTimeBetween>
  <EndTimeGreaterThan>0001-01-01T00:00:00</EndTimeGreaterThan>
  <EndTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</EndTimeGreaterThanOrEqualTo>
  <EndTimeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EndTimeIn>
  <EndTimeLessThan>0001-01-01T00:00:00</EndTimeLessThan>
  <EndTimeLessThanOrEqualTo>0001-01-01T00:00:00</EndTimeLessThanOrEqualTo>
  <EndTimeNotEqualTo>0001-01-01T00:00:00</EndTimeNotEqualTo>
  <ItemNo>0</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoBetween>
  <ItemNoGreaterThan>0</ItemNoGreaterThan>
  <ItemNoGreaterThanOrEqualTo>0</ItemNoGreaterThanOrEqualTo>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoIn>
  <ItemNoLessThan>0</ItemNoLessThan>
  <ItemNoLessThanOrEqualTo>0</ItemNoLessThanOrEqualTo>
  <ItemNoNotEqualTo>0</ItemNoNotEqualTo>
  <RecID>00000000-0000-0000-0000-000000000000</RecID>
  <RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:guid>00000000-0000-0000-0000-000000000000</d2p1:guid>
  </RecIDIn>
  <RowHash>AA==</RowHash>
  <SM_Activities_RecID>String</SM_Activities_RecID>
  <SM_Activities_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Activities_RecIDBetween>
  <SM_Activities_RecIDContains>String</SM_Activities_RecIDContains>
  <SM_Activities_RecIDEndsWith>String</SM_Activities_RecIDEndsWith>
  <SM_Activities_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Activities_RecIDIn>
  <SM_Activities_RecIDLike>String</SM_Activities_RecIDLike>
  <SM_Activities_RecIDStartsWith>String</SM_Activities_RecIDStartsWith>
  <SM_Tasks_RecID>String</SM_Tasks_RecID>
  <SM_Tasks_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Tasks_RecIDBetween>
  <SM_Tasks_RecIDContains>String</SM_Tasks_RecIDContains>
  <SM_Tasks_RecIDEndsWith>String</SM_Tasks_RecIDEndsWith>
  <SM_Tasks_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Tasks_RecIDIn>
  <SM_Tasks_RecIDLike>String</SM_Tasks_RecIDLike>
  <SM_Tasks_RecIDStartsWith>String</SM_Tasks_RecIDStartsWith>
  <SM_Timesheets_RecID>00000000-0000-0000-0000-000000000000</SM_Timesheets_RecID>
  <SM_Timesheets_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:guid>00000000-0000-0000-0000-000000000000</d2p1:guid>
  </SM_Timesheets_RecIDIn>
  <StartTime>0001-01-01T00:00:00</StartTime>
  <StartTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </StartTimeBetween>
  <StartTimeGreaterThan>0001-01-01T00:00:00</StartTimeGreaterThan>
  <StartTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</StartTimeGreaterThanOrEqualTo>
  <StartTimeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </StartTimeIn>
  <StartTimeLessThan>0001-01-01T00:00:00</StartTimeLessThan>
  <StartTimeLessThanOrEqualTo>0001-01-01T00:00:00</StartTimeLessThanOrEqualTo>
  <StartTimeNotEqualTo>0001-01-01T00:00:00</StartTimeNotEqualTo>
</SM_TimesheetLinesQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfSM_TimesheetLines7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:SM_TimesheetLines>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_EndTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_EndTime_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>00000000-0000-0000-0000-000000000000</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_SM_Activities_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_Activities_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SM_Tasks_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_Tasks_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SM_Timesheets_RecID_x003E_k__BackingField>00000000-0000-0000-0000-000000000000</d2p1:_x003C_SM_Timesheets_RecID_x003E_k__BackingField>
      <d2p1:_x003C_StartTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_StartTime_x003E_k__BackingField>
    </d2p1:SM_TimesheetLines>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfSM_TimesheetLines7kRqkrSv>