JiwaAPI

<back to all web services

GL_LedgerQuery

Requires Authentication
The following routes are available for this service:
GET/Queries/GL_LedgerRetrieves a list of general ledger accounts.
GL_LedgerQuery Parameters:
NameParameterData TypeRequiredDescription
GLLedgerIDquerystringNo
GLLedgerIDStartsWithquerystringNo
GLLedgerIDEndsWithquerystringNo
GLLedgerIDContainsquerystringNo
GLLedgerIDLikequerystringNo
GLLedgerIDBetweenquerystring[]No
GLLedgerIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
GLCategoryIDquerystringNo
GLCategoryIDStartsWithquerystringNo
GLCategoryIDEndsWithquerystringNo
GLCategoryIDContainsquerystringNo
GLCategoryIDLikequerystringNo
GLCategoryIDBetweenquerystring[]No
GLCategoryIDInquerystring[]No
AccountNoquerystringNo
AccountNoStartsWithquerystringNo
AccountNoEndsWithquerystringNo
AccountNoContainsquerystringNo
AccountNoLikequerystringNo
AccountNoBetweenquerystring[]No
AccountNoInquerystring[]No
Seg1querystringNo
Seg1StartsWithquerystringNo
Seg1EndsWithquerystringNo
Seg1ContainsquerystringNo
Seg1LikequerystringNo
Seg1Betweenquerystring[]No
Seg1Inquerystring[]No
Seg2querystringNo
Seg2StartsWithquerystringNo
Seg2EndsWithquerystringNo
Seg2ContainsquerystringNo
Seg2LikequerystringNo
Seg2Betweenquerystring[]No
Seg2Inquerystring[]No
Seg3querystringNo
Seg3StartsWithquerystringNo
Seg3EndsWithquerystringNo
Seg3ContainsquerystringNo
Seg3LikequerystringNo
Seg3Betweenquerystring[]No
Seg3Inquerystring[]No
Seg4querystringNo
Seg4StartsWithquerystringNo
Seg4EndsWithquerystringNo
Seg4ContainsquerystringNo
Seg4LikequerystringNo
Seg4Betweenquerystring[]No
Seg4Inquerystring[]No
Seg5querystringNo
Seg5StartsWithquerystringNo
Seg5EndsWithquerystringNo
Seg5ContainsquerystringNo
Seg5LikequerystringNo
Seg5Betweenquerystring[]No
Seg5Inquerystring[]No
Seg6querystringNo
Seg6StartsWithquerystringNo
Seg6EndsWithquerystringNo
Seg6ContainsquerystringNo
Seg6LikequerystringNo
Seg6Betweenquerystring[]No
Seg6Inquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
LastYearOpenquerydecimal?No
LastYearOpenGreaterThanOrEqualToquerydecimal?No
LastYearOpenGreaterThanquerydecimal?No
LastYearOpenLessThanquerydecimal?No
LastYearOpenLessThanOrEqualToquerydecimal?No
LastYearOpenNotEqualToquerydecimal?No
LastYearOpenBetweenqueryNullable<Decimal>[]No
LastYearOpenInqueryNullable<Decimal>[]No
CurrYearOpenquerydecimal?No
CurrYearOpenGreaterThanOrEqualToquerydecimal?No
CurrYearOpenGreaterThanquerydecimal?No
CurrYearOpenLessThanquerydecimal?No
CurrYearOpenLessThanOrEqualToquerydecimal?No
CurrYearOpenNotEqualToquerydecimal?No
CurrYearOpenBetweenqueryNullable<Decimal>[]No
CurrYearOpenInqueryNullable<Decimal>[]No
CurrBalquerydecimal?No
CurrBalGreaterThanOrEqualToquerydecimal?No
CurrBalGreaterThanquerydecimal?No
CurrBalLessThanquerydecimal?No
CurrBalLessThanOrEqualToquerydecimal?No
CurrBalNotEqualToquerydecimal?No
CurrBalBetweenqueryNullable<Decimal>[]No
CurrBalInqueryNullable<Decimal>[]No
ExpSignquerybyte?No
ExpSignGreaterThanOrEqualToquerybyte?No
ExpSignGreaterThanquerybyte?No
ExpSignLessThanquerybyte?No
ExpSignLessThanOrEqualToquerybyte?No
ExpSignNotEqualToquerybyte?No
ExpSignBetweenqueryNullable<Byte>[]No
ExpSignInqueryNullable<Byte>[]No
AccClassqueryshort?No
AccClassGreaterThanOrEqualToqueryshort?No
AccClassGreaterThanqueryshort?No
AccClassLessThanqueryshort?No
AccClassLessThanOrEqualToqueryshort?No
AccClassNotEqualToqueryshort?No
AccClassBetweenqueryshort[]No
AccClassInqueryshort[]No
DistributionAccquerybool?No
ShortCutquerystringNo
ShortCutStartsWithquerystringNo
ShortCutEndsWithquerystringNo
ShortCutContainsquerystringNo
ShortCutLikequerystringNo
ShortCutBetweenquerystring[]No
ShortCutInquerystring[]No
PostingAccqueryshort?No
PostingAccGreaterThanOrEqualToqueryshort?No
PostingAccGreaterThanqueryshort?No
PostingAccLessThanqueryshort?No
PostingAccLessThanOrEqualToqueryshort?No
PostingAccNotEqualToqueryshort?No
PostingAccBetweenqueryshort[]No
PostingAccInqueryshort[]No
ParentAccNoquerystringNo
ParentAccNoStartsWithquerystringNo
ParentAccNoEndsWithquerystringNo
ParentAccNoContainsquerystringNo
ParentAccNoLikequerystringNo
ParentAccNoBetweenquerystring[]No
ParentAccNoInquerystring[]No
UseTransCode1querybool?No
UseTransCode2querybool?No
UseTransCode3querybool?No
UseStaffCodequerybool?No
ClearingAccountIDquerystringNo
ClearingAccountIDStartsWithquerystringNo
ClearingAccountIDEndsWithquerystringNo
ClearingAccountIDContainsquerystringNo
ClearingAccountIDLikequerystringNo
ClearingAccountIDBetweenquerystring[]No
ClearingAccountIDInquerystring[]No
DetailsquerystringNo
DetailsStartsWithquerystringNo
DetailsEndsWithquerystringNo
DetailsContainsquerystringNo
DetailsLikequerystringNo
DetailsBetweenquerystring[]No
DetailsInquerystring[]No
IsEnabledquerybool?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
GL_Ledger Parameters:
NameParameterData TypeRequiredDescription
GLLedgerIDformstringNo
LastSavedDateTimeformDateTime?No
GLCategoryIDformstringNo
AccountNoformstringNo
Seg1formstringNo
Seg2formstringNo
Seg3formstringNo
Seg4formstringNo
Seg5formstringNo
Seg6formstringNo
DescriptionformstringNo
LastYearOpenformdecimal?No
CurrYearOpenformdecimal?No
CurrBalformdecimal?No
ExpSignformbyte?No
AccClassformshortNo
DistributionAccformbool?No
ShortCutformstringNo
PostingAccformshortNo
ParentAccNoformstringNo
UseTransCode1formbool?No
UseTransCode2formbool?No
UseTransCode3formbool?No
UseStaffCodeformbool?No
ClearingAccountIDformstringNo
DetailsformstringNo
IsEnabledformbool?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_Ledger HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfGL_Ledger7kRqkrSv 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_Ledger>
      <d2p1:_x003C_AccClass_x003E_k__BackingField>0</d2p1:_x003C_AccClass_x003E_k__BackingField>
      <d2p1:_x003C_AccountNo_x003E_k__BackingField>String</d2p1:_x003C_AccountNo_x003E_k__BackingField>
      <d2p1:_x003C_ClearingAccountID_x003E_k__BackingField>String</d2p1:_x003C_ClearingAccountID_x003E_k__BackingField>
      <d2p1:_x003C_CurrBal_x003E_k__BackingField>0</d2p1:_x003C_CurrBal_x003E_k__BackingField>
      <d2p1:_x003C_CurrYearOpen_x003E_k__BackingField>0</d2p1:_x003C_CurrYearOpen_x003E_k__BackingField>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_Details_x003E_k__BackingField>String</d2p1:_x003C_Details_x003E_k__BackingField>
      <d2p1:_x003C_DistributionAcc_x003E_k__BackingField>false</d2p1:_x003C_DistributionAcc_x003E_k__BackingField>
      <d2p1:_x003C_ExpSign_x003E_k__BackingField>0</d2p1:_x003C_ExpSign_x003E_k__BackingField>
      <d2p1:_x003C_GLCategoryID_x003E_k__BackingField>String</d2p1:_x003C_GLCategoryID_x003E_k__BackingField>
      <d2p1:_x003C_GLLedgerID_x003E_k__BackingField>String</d2p1:_x003C_GLLedgerID_x003E_k__BackingField>
      <d2p1:_x003C_IsEnabled_x003E_k__BackingField>false</d2p1:_x003C_IsEnabled_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LastYearOpen_x003E_k__BackingField>0</d2p1:_x003C_LastYearOpen_x003E_k__BackingField>
      <d2p1:_x003C_ParentAccNo_x003E_k__BackingField>String</d2p1:_x003C_ParentAccNo_x003E_k__BackingField>
      <d2p1:_x003C_PostingAcc_x003E_k__BackingField>0</d2p1:_x003C_PostingAcc_x003E_k__BackingField>
      <d2p1:_x003C_Seg1_x003E_k__BackingField>String</d2p1:_x003C_Seg1_x003E_k__BackingField>
      <d2p1:_x003C_Seg2_x003E_k__BackingField>String</d2p1:_x003C_Seg2_x003E_k__BackingField>
      <d2p1:_x003C_Seg3_x003E_k__BackingField>String</d2p1:_x003C_Seg3_x003E_k__BackingField>
      <d2p1:_x003C_Seg4_x003E_k__BackingField>String</d2p1:_x003C_Seg4_x003E_k__BackingField>
      <d2p1:_x003C_Seg5_x003E_k__BackingField>String</d2p1:_x003C_Seg5_x003E_k__BackingField>
      <d2p1:_x003C_Seg6_x003E_k__BackingField>String</d2p1:_x003C_Seg6_x003E_k__BackingField>
      <d2p1:_x003C_ShortCut_x003E_k__BackingField>String</d2p1:_x003C_ShortCut_x003E_k__BackingField>
      <d2p1:_x003C_UseStaffCode_x003E_k__BackingField>false</d2p1:_x003C_UseStaffCode_x003E_k__BackingField>
      <d2p1:_x003C_UseTransCode1_x003E_k__BackingField>false</d2p1:_x003C_UseTransCode1_x003E_k__BackingField>
      <d2p1:_x003C_UseTransCode2_x003E_k__BackingField>false</d2p1:_x003C_UseTransCode2_x003E_k__BackingField>
      <d2p1:_x003C_UseTransCode3_x003E_k__BackingField>false</d2p1:_x003C_UseTransCode3_x003E_k__BackingField>
    </d2p1:GL_Ledger>
  </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_Ledger7kRqkrSv>