JiwaAPI

SM_TimesheetsQuery

**SM_TimesheetsQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	Guid?	No
RecIDIn	query	Guid[]	No
TimesheetNo	query	string	No
TimesheetNoStartsWith	query	string	No
TimesheetNoEndsWith	query	string	No
TimesheetNoContains	query	string	No
TimesheetNoLike	query	string	No
TimesheetNoBetween	query	string[]	No
TimesheetNoIn	query	string[]	No
HR_Staff_RecID	query	string	No
HR_Staff_RecIDStartsWith	query	string	No
HR_Staff_RecIDEndsWith	query	string	No
HR_Staff_RecIDContains	query	string	No
HR_Staff_RecIDLike	query	string	No
HR_Staff_RecIDBetween	query	string[]	No
HR_Staff_RecIDIn	query	string[]	No
TimeSheetDate	query	DateTime?	No
TimeSheetDateGreaterThanOrEqualTo	query	DateTime?	No
TimeSheetDateGreaterThan	query	DateTime?	No
TimeSheetDateLessThan	query	DateTime?	No
TimeSheetDateLessThanOrEqualTo	query	DateTime?	No
TimeSheetDateNotEqualTo	query	DateTime?	No
TimeSheetDateBetween	query	DateTime[]	No
TimeSheetDateIn	query	DateTime[]	No
LastSavedDateTime	query	DateTime?	No
LastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeGreaterThan	query	DateTime?	No
LastSavedDateTimeLessThan	query	DateTime?	No
LastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeNotEqualTo	query	DateTime?	No
LastSavedDateTimeBetween	query	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	No
IsActivated	query	bool?	No
RowHash	query	byte[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**SM_Timesheets** Parameters:
Name	Parameter	Data Type	Required
RecID	form	Guid	No
TimesheetNo	form	string	No
HR_Staff_RecID	form	string	No
TimeSheetDate	form	DateTime	No
LastSavedDateTime	form	DateTime	No
IsActivated	form	bool	No
RowHash	form	byte[]	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

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_TimesheetsQuery 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"],"TimesheetNo":"String","TimesheetNoStartsWith":"String","TimesheetNoEndsWith":"String","TimesheetNoContains":"String","TimesheetNoLike":"String","TimesheetNoBetween":["String"],"TimesheetNoIn":["String"],"HR_Staff_RecID":"String","HR_Staff_RecIDStartsWith":"String","HR_Staff_RecIDEndsWith":"String","HR_Staff_RecIDContains":"String","HR_Staff_RecIDLike":"String","HR_Staff_RecIDBetween":["String"],"HR_Staff_RecIDIn":["String"],"TimeSheetDate":"0001-01-01T00:00:00.0000000","TimeSheetDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","TimeSheetDateGreaterThan":"0001-01-01T00:00:00.0000000","TimeSheetDateLessThan":"0001-01-01T00:00:00.0000000","TimeSheetDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","TimeSheetDateNotEqualTo":"0001-01-01T00:00:00.0000000","TimeSheetDateBetween":["0001-01-01T00:00:00.0000000"],"TimeSheetDateIn":["0001-01-01T00:00:00.0000000"],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"IsActivated":false,"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":[{"TimesheetNo":"String","HR_Staff_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"}}}