JiwaAPI

GL_SetsQuery

The following routes are available for this service:
GET	/Queries/GL_Sets	Retrieves a list of journal sets.

**GL_SetsQuery** Parameters:
Name	Parameter	Data Type	Required
GLSetID	query	string	No
GLSetIDStartsWith	query	string	No
GLSetIDEndsWith	query	string	No
GLSetIDContains	query	string	No
GLSetIDLike	query	string	No
GLSetIDBetween	query	string[]	No
GLSetIDIn	query	string[]	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	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<DateTime>[]	No
SetNo	query	string	No
SetNoStartsWith	query	string	No
SetNoEndsWith	query	string	No
SetNoContains	query	string	No
SetNoLike	query	string	No
SetNoBetween	query	string[]	No
SetNoIn	query	string[]	No
PostDateTime	query	DateTime?	No
PostDateTimeGreaterThanOrEqualTo	query	DateTime?	No
PostDateTimeGreaterThan	query	DateTime?	No
PostDateTimeLessThan	query	DateTime?	No
PostDateTimeLessThanOrEqualTo	query	DateTime?	No
PostDateTimeNotEqualTo	query	DateTime?	No
PostDateTimeBetween	query	Nullable<DateTime>[]	No
PostDateTimeIn	query	Nullable<DateTime>[]	No
PostedToPeriodNo	query	short?	No
PostedToPeriodNoGreaterThanOrEqualTo	query	short?	No
PostedToPeriodNoGreaterThan	query	short?	No
PostedToPeriodNoLessThan	query	short?	No
PostedToPeriodNoLessThanOrEqualTo	query	short?	No
PostedToPeriodNoNotEqualTo	query	short?	No
PostedToPeriodNoBetween	query	short[]	No
PostedToPeriodNoIn	query	short[]	No
Description	query	string	No
DescriptionStartsWith	query	string	No
DescriptionEndsWith	query	string	No
DescriptionContains	query	string	No
DescriptionLike	query	string	No
DescriptionBetween	query	string[]	No
DescriptionIn	query	string[]	No
Source	query	string	No
SourceStartsWith	query	string	No
SourceEndsWith	query	string	No
SourceContains	query	string	No
SourceLike	query	string	No
SourceBetween	query	string[]	No
SourceIn	query	string[]	No
SourceID	query	string	No
SourceIDStartsWith	query	string	No
SourceIDEndsWith	query	string	No
SourceIDContains	query	string	No
SourceIDLike	query	string	No
SourceIDBetween	query	string[]	No
SourceIDIn	query	string[]	No
UserName	query	string	No
UserNameStartsWith	query	string	No
UserNameEndsWith	query	string	No
UserNameContains	query	string	No
UserNameLike	query	string	No
UserNameBetween	query	string[]	No
UserNameIn	query	string[]	No
SetType	query	short?	No
SetTypeGreaterThanOrEqualTo	query	short?	No
SetTypeGreaterThan	query	short?	No
SetTypeLessThan	query	short?	No
SetTypeLessThanOrEqualTo	query	short?	No
SetTypeNotEqualTo	query	short?	No
SetTypeBetween	query	short[]	No
SetTypeIn	query	short[]	No
RepeatingType	query	short?	No
RepeatingTypeGreaterThanOrEqualTo	query	short?	No
RepeatingTypeGreaterThan	query	short?	No
RepeatingTypeLessThan	query	short?	No
RepeatingTypeLessThanOrEqualTo	query	short?	No
RepeatingTypeNotEqualTo	query	short?	No
RepeatingTypeBetween	query	short[]	No
RepeatingTypeIn	query	short[]	No
RepeatingUnits	query	short?	No
RepeatingUnitsGreaterThanOrEqualTo	query	short?	No
RepeatingUnitsGreaterThan	query	short?	No
RepeatingUnitsLessThan	query	short?	No
RepeatingUnitsLessThanOrEqualTo	query	short?	No
RepeatingUnitsNotEqualTo	query	short?	No
RepeatingUnitsBetween	query	short[]	No
RepeatingUnitsIn	query	short[]	No
NextRepeatingDate	query	DateTime?	No
NextRepeatingDateGreaterThanOrEqualTo	query	DateTime?	No
NextRepeatingDateGreaterThan	query	DateTime?	No
NextRepeatingDateLessThan	query	DateTime?	No
NextRepeatingDateLessThanOrEqualTo	query	DateTime?	No
NextRepeatingDateNotEqualTo	query	DateTime?	No
NextRepeatingDateBetween	query	Nullable<DateTime>[]	No
NextRepeatingDateIn	query	Nullable<DateTime>[]	No
RepeatingWillEnd	query	bool?	No
RepeatingEndDate	query	DateTime?	No
RepeatingEndDateGreaterThanOrEqualTo	query	DateTime?	No
RepeatingEndDateGreaterThan	query	DateTime?	No
RepeatingEndDateLessThan	query	DateTime?	No
RepeatingEndDateLessThanOrEqualTo	query	DateTime?	No
RepeatingEndDateNotEqualTo	query	DateTime?	No
RepeatingEndDateBetween	query	Nullable<DateTime>[]	No
RepeatingEndDateIn	query	Nullable<DateTime>[]	No
ReverseType	query	short?	No
ReverseTypeGreaterThanOrEqualTo	query	short?	No
ReverseTypeGreaterThan	query	short?	No
ReverseTypeLessThan	query	short?	No
ReverseTypeLessThanOrEqualTo	query	short?	No
ReverseTypeNotEqualTo	query	short?	No
ReverseTypeBetween	query	short[]	No
ReverseTypeIn	query	short[]	No
ReversePeriod	query	short?	No
ReversePeriodGreaterThanOrEqualTo	query	short?	No
ReversePeriodGreaterThan	query	short?	No
ReversePeriodLessThan	query	short?	No
ReversePeriodLessThanOrEqualTo	query	short?	No
ReversePeriodNotEqualTo	query	short?	No
ReversePeriodBetween	query	Nullable<Int16>[]	No
ReversePeriodIn	query	Nullable<Int16>[]	No
ReverseDate	query	DateTime?	No
ReverseDateGreaterThanOrEqualTo	query	DateTime?	No
ReverseDateGreaterThan	query	DateTime?	No
ReverseDateLessThan	query	DateTime?	No
ReverseDateLessThanOrEqualTo	query	DateTime?	No
ReverseDateNotEqualTo	query	DateTime?	No
ReverseDateBetween	query	Nullable<DateTime>[]	No
ReverseDateIn	query	Nullable<DateTime>[]	No
Reversed	query	bool?	No
YearNo	query	short?	No
YearNoGreaterThanOrEqualTo	query	short?	No
YearNoGreaterThan	query	short?	No
YearNoLessThan	query	short?	No
YearNoLessThanOrEqualTo	query	short?	No
YearNoNotEqualTo	query	short?	No
YearNoBetween	query	Nullable<Int16>[]	No
YearNoIn	query	Nullable<Int16>[]	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

**GL_Sets** Parameters:
Name	Parameter	Data Type	Required
GLSetID	form	string	No
LastSavedDateTime	form	DateTime?	No
SetNo	form	string	No
PostDateTime	form	DateTime?	No
PostedToPeriodNo	form	short	No
Description	form	string	No
Source	form	string	No
SourceID	form	string	No
UserName	form	string	No
SetType	form	short	No
RepeatingType	form	short	No
RepeatingUnits	form	short	No
NextRepeatingDate	form	DateTime?	No
RepeatingWillEnd	form	bool?	No
RepeatingEndDate	form	DateTime?	No
ReverseType	form	short	No
ReversePeriod	form	short?	No
ReverseDate	form	DateTime?	No
Reversed	form	bool?	No
YearNo	form	short?	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.

GET /Queries/GL_Sets HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv

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

{"Results":[{"GLSetID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","SetNo":"String","PostDateTime":"0001-01-01T00:00:00.0000000","Description":"String","Source":"String","SourceID":"String","UserName":"String","NextRepeatingDate":"0001-01-01T00:00:00.0000000","RepeatingWillEnd":false,"RepeatingEndDate":"0001-01-01T00:00:00.0000000","ReversePeriod":0,"ReverseDate":"0001-01-01T00:00:00.0000000","Reversed":false,"YearNo":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}