JiwaAPI

<back to all web services

GL_SetsQuery

Requires Authentication
The following routes are available for this service:
GET/Queries/GL_SetsRetrieves a list of journal sets.
GL_SetsQuery Parameters:
NameParameterData TypeRequiredDescription
GLSetIDquerystringNo
GLSetIDStartsWithquerystringNo
GLSetIDEndsWithquerystringNo
GLSetIDContainsquerystringNo
GLSetIDLikequerystringNo
GLSetIDBetweenquerystring[]No
GLSetIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
SetNoquerystringNo
SetNoStartsWithquerystringNo
SetNoEndsWithquerystringNo
SetNoContainsquerystringNo
SetNoLikequerystringNo
SetNoBetweenquerystring[]No
SetNoInquerystring[]No
PostDateTimequeryDateTime?No
PostDateTimeGreaterThanOrEqualToqueryDateTime?No
PostDateTimeGreaterThanqueryDateTime?No
PostDateTimeLessThanqueryDateTime?No
PostDateTimeLessThanOrEqualToqueryDateTime?No
PostDateTimeNotEqualToqueryDateTime?No
PostDateTimeBetweenqueryNullable<DateTime>[]No
PostDateTimeInqueryNullable<DateTime>[]No
PostedToPeriodNoqueryshort?No
PostedToPeriodNoGreaterThanOrEqualToqueryshort?No
PostedToPeriodNoGreaterThanqueryshort?No
PostedToPeriodNoLessThanqueryshort?No
PostedToPeriodNoLessThanOrEqualToqueryshort?No
PostedToPeriodNoNotEqualToqueryshort?No
PostedToPeriodNoBetweenqueryshort[]No
PostedToPeriodNoInqueryshort[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
SourcequerystringNo
SourceStartsWithquerystringNo
SourceEndsWithquerystringNo
SourceContainsquerystringNo
SourceLikequerystringNo
SourceBetweenquerystring[]No
SourceInquerystring[]No
SourceIDquerystringNo
SourceIDStartsWithquerystringNo
SourceIDEndsWithquerystringNo
SourceIDContainsquerystringNo
SourceIDLikequerystringNo
SourceIDBetweenquerystring[]No
SourceIDInquerystring[]No
UserNamequerystringNo
UserNameStartsWithquerystringNo
UserNameEndsWithquerystringNo
UserNameContainsquerystringNo
UserNameLikequerystringNo
UserNameBetweenquerystring[]No
UserNameInquerystring[]No
SetTypequeryshort?No
SetTypeGreaterThanOrEqualToqueryshort?No
SetTypeGreaterThanqueryshort?No
SetTypeLessThanqueryshort?No
SetTypeLessThanOrEqualToqueryshort?No
SetTypeNotEqualToqueryshort?No
SetTypeBetweenqueryshort[]No
SetTypeInqueryshort[]No
RepeatingTypequeryshort?No
RepeatingTypeGreaterThanOrEqualToqueryshort?No
RepeatingTypeGreaterThanqueryshort?No
RepeatingTypeLessThanqueryshort?No
RepeatingTypeLessThanOrEqualToqueryshort?No
RepeatingTypeNotEqualToqueryshort?No
RepeatingTypeBetweenqueryshort[]No
RepeatingTypeInqueryshort[]No
RepeatingUnitsqueryshort?No
RepeatingUnitsGreaterThanOrEqualToqueryshort?No
RepeatingUnitsGreaterThanqueryshort?No
RepeatingUnitsLessThanqueryshort?No
RepeatingUnitsLessThanOrEqualToqueryshort?No
RepeatingUnitsNotEqualToqueryshort?No
RepeatingUnitsBetweenqueryshort[]No
RepeatingUnitsInqueryshort[]No
NextRepeatingDatequeryDateTime?No
NextRepeatingDateGreaterThanOrEqualToqueryDateTime?No
NextRepeatingDateGreaterThanqueryDateTime?No
NextRepeatingDateLessThanqueryDateTime?No
NextRepeatingDateLessThanOrEqualToqueryDateTime?No
NextRepeatingDateNotEqualToqueryDateTime?No
NextRepeatingDateBetweenqueryNullable<DateTime>[]No
NextRepeatingDateInqueryNullable<DateTime>[]No
RepeatingWillEndquerybool?No
RepeatingEndDatequeryDateTime?No
RepeatingEndDateGreaterThanOrEqualToqueryDateTime?No
RepeatingEndDateGreaterThanqueryDateTime?No
RepeatingEndDateLessThanqueryDateTime?No
RepeatingEndDateLessThanOrEqualToqueryDateTime?No
RepeatingEndDateNotEqualToqueryDateTime?No
RepeatingEndDateBetweenqueryNullable<DateTime>[]No
RepeatingEndDateInqueryNullable<DateTime>[]No
ReverseTypequeryshort?No
ReverseTypeGreaterThanOrEqualToqueryshort?No
ReverseTypeGreaterThanqueryshort?No
ReverseTypeLessThanqueryshort?No
ReverseTypeLessThanOrEqualToqueryshort?No
ReverseTypeNotEqualToqueryshort?No
ReverseTypeBetweenqueryshort[]No
ReverseTypeInqueryshort[]No
ReversePeriodqueryshort?No
ReversePeriodGreaterThanOrEqualToqueryshort?No
ReversePeriodGreaterThanqueryshort?No
ReversePeriodLessThanqueryshort?No
ReversePeriodLessThanOrEqualToqueryshort?No
ReversePeriodNotEqualToqueryshort?No
ReversePeriodBetweenqueryNullable<Int16>[]No
ReversePeriodInqueryNullable<Int16>[]No
ReverseDatequeryDateTime?No
ReverseDateGreaterThanOrEqualToqueryDateTime?No
ReverseDateGreaterThanqueryDateTime?No
ReverseDateLessThanqueryDateTime?No
ReverseDateLessThanOrEqualToqueryDateTime?No
ReverseDateNotEqualToqueryDateTime?No
ReverseDateBetweenqueryNullable<DateTime>[]No
ReverseDateInqueryNullable<DateTime>[]No
Reversedquerybool?No
YearNoqueryshort?No
YearNoGreaterThanOrEqualToqueryshort?No
YearNoGreaterThanqueryshort?No
YearNoLessThanqueryshort?No
YearNoLessThanOrEqualToqueryshort?No
YearNoNotEqualToqueryshort?No
YearNoBetweenqueryNullable<Int16>[]No
YearNoInqueryNullable<Int16>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
GL_Sets Parameters:
NameParameterData TypeRequiredDescription
GLSetIDformstringNo
LastSavedDateTimeformDateTime?No
SetNoformstringNo
PostDateTimeformDateTime?No
PostedToPeriodNoformshortNo
DescriptionformstringNo
SourceformstringNo
SourceIDformstringNo
UserNameformstringNo
SetTypeformshortNo
RepeatingTypeformshortNo
RepeatingUnitsformshortNo
NextRepeatingDateformDateTime?No
RepeatingWillEndformbool?No
RepeatingEndDateformDateTime?No
ReverseTypeformshortNo
ReversePeriodformshort?No
ReverseDateformDateTime?No
Reversedformbool?No
YearNoformshort?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.

GET /Queries/GL_Sets HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfGL_Sets7kRqkrSv 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:GL_Sets>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_GLSetID_x003E_k__BackingField>String</d2p1:_x003C_GLSetID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_NextRepeatingDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_NextRepeatingDate_x003E_k__BackingField>
      <d2p1:_x003C_PostDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_PostDateTime_x003E_k__BackingField>
      <d2p1:_x003C_PostedToPeriodNo_x003E_k__BackingField>0</d2p1:_x003C_PostedToPeriodNo_x003E_k__BackingField>
      <d2p1:_x003C_RepeatingEndDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_RepeatingEndDate_x003E_k__BackingField>
      <d2p1:_x003C_RepeatingType_x003E_k__BackingField>0</d2p1:_x003C_RepeatingType_x003E_k__BackingField>
      <d2p1:_x003C_RepeatingUnits_x003E_k__BackingField>0</d2p1:_x003C_RepeatingUnits_x003E_k__BackingField>
      <d2p1:_x003C_RepeatingWillEnd_x003E_k__BackingField>false</d2p1:_x003C_RepeatingWillEnd_x003E_k__BackingField>
      <d2p1:_x003C_ReverseDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ReverseDate_x003E_k__BackingField>
      <d2p1:_x003C_ReversePeriod_x003E_k__BackingField>0</d2p1:_x003C_ReversePeriod_x003E_k__BackingField>
      <d2p1:_x003C_ReverseType_x003E_k__BackingField>0</d2p1:_x003C_ReverseType_x003E_k__BackingField>
      <d2p1:_x003C_Reversed_x003E_k__BackingField>false</d2p1:_x003C_Reversed_x003E_k__BackingField>
      <d2p1:_x003C_SetNo_x003E_k__BackingField>String</d2p1:_x003C_SetNo_x003E_k__BackingField>
      <d2p1:_x003C_SetType_x003E_k__BackingField>0</d2p1:_x003C_SetType_x003E_k__BackingField>
      <d2p1:_x003C_SourceID_x003E_k__BackingField>String</d2p1:_x003C_SourceID_x003E_k__BackingField>
      <d2p1:_x003C_Source_x003E_k__BackingField>String</d2p1:_x003C_Source_x003E_k__BackingField>
      <d2p1:_x003C_UserName_x003E_k__BackingField>String</d2p1:_x003C_UserName_x003E_k__BackingField>
      <d2p1:_x003C_YearNo_x003E_k__BackingField>0</d2p1:_x003C_YearNo_x003E_k__BackingField>
    </d2p1:GL_Sets>
  </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>
</QueryResponseOfGL_Sets7kRqkrSv>