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 .csv suffix or ?format=csv

HTTP + CSV

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

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

{"RecID":"00000000000000000000000000000000","RecIDIn":["00000000-0000-0000-0000-000000000000"],"SM_Timesheets_RecID":"00000000000000000000000000000000","SM_Timesheets_RecIDIn":["00000000-0000-0000-0000-000000000000"],"SM_Tasks_RecID":"String","SM_Tasks_RecIDStartsWith":"String","SM_Tasks_RecIDEndsWith":"String","SM_Tasks_RecIDContains":"String","SM_Tasks_RecIDLike":"String","SM_Tasks_RecIDBetween":["String"],"SM_Tasks_RecIDIn":["String"],"StartTime":"0001-01-01T00:00:00.0000000","StartTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","StartTimeGreaterThan":"0001-01-01T00:00:00.0000000","StartTimeLessThan":"0001-01-01T00:00:00.0000000","StartTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","StartTimeNotEqualTo":"0001-01-01T00:00:00.0000000","StartTimeBetween":["0001-01-01T00:00:00.0000000"],"StartTimeIn":["0001-01-01T00:00:00.0000000"],"EndTime":"0001-01-01T00:00:00.0000000","EndTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","EndTimeGreaterThan":"0001-01-01T00:00:00.0000000","EndTimeLessThan":"0001-01-01T00:00:00.0000000","EndTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","EndTimeNotEqualTo":"0001-01-01T00:00:00.0000000","EndTimeBetween":["0001-01-01T00:00:00.0000000"],"EndTimeIn":["0001-01-01T00:00:00.0000000"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"SM_Activities_RecID":"String","SM_Activities_RecIDStartsWith":"String","SM_Activities_RecIDEndsWith":"String","SM_Activities_RecIDContains":"String","SM_Activities_RecIDLike":"String","SM_Activities_RecIDBetween":["String"],"SM_Activities_RecIDIn":["String"],"RowHash":"AA==","Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"SM_Tasks_RecID":"String","EndTime":"0001-01-01T00:00:00.0000000","Description":"String","SM_Activities_RecID":"String","RowHash":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}