JiwaAPI

<back to all web services

v_GL_TransactionsQuery

Requires Authentication
v_GL_TransactionsQuery Parameters:
NameParameterData TypeRequiredDescription
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
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
TransPostDateTimequeryDateTime?No
TransPostDateTimeGreaterThanOrEqualToqueryDateTime?No
TransPostDateTimeGreaterThanqueryDateTime?No
TransPostDateTimeLessThanqueryDateTime?No
TransPostDateTimeLessThanOrEqualToqueryDateTime?No
TransPostDateTimeNotEqualToqueryDateTime?No
TransPostDateTimeBetweenqueryNullable<DateTime>[]No
TransPostDateTimeInqueryNullable<DateTime>[]No
CategoryquerystringNo
CategoryStartsWithquerystringNo
CategoryEndsWithquerystringNo
CategoryContainsquerystringNo
CategoryLikequerystringNo
CategoryBetweenquerystring[]No
CategoryInquerystring[]No
AccountDescriptionquerystringNo
AccountDescriptionStartsWithquerystringNo
AccountDescriptionEndsWithquerystringNo
AccountDescriptionContainsquerystringNo
AccountDescriptionLikequerystringNo
AccountDescriptionBetweenquerystring[]No
AccountDescriptionInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
v_GL_Transactions Parameters:
NameParameterData TypeRequiredDescription
Seg1formstringNo
Seg2formstringNo
Seg3formstringNo
Seg4formstringNo
Seg5formstringNo
Seg6formstringNo
Amountformdecimal?No
TransPostDateTimeformDateTime?No
CategoryformstringNo
AccountDescriptionformstringNo
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.

POST /xml/reply/v_GL_TransactionsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_GL_TransactionsQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
  <Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
  <Include xmlns="http://schemas.servicestack.net/types">String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
  <OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
  <Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
  <Take xmlns="http://schemas.servicestack.net/types">0</Take>
  <AccountDescription>String</AccountDescription>
  <AccountDescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountDescriptionBetween>
  <AccountDescriptionContains>String</AccountDescriptionContains>
  <AccountDescriptionEndsWith>String</AccountDescriptionEndsWith>
  <AccountDescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountDescriptionIn>
  <AccountDescriptionLike>String</AccountDescriptionLike>
  <AccountDescriptionStartsWith>String</AccountDescriptionStartsWith>
  <Amount>0</Amount>
  <AmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </AmountBetween>
  <AmountGreaterThan>0</AmountGreaterThan>
  <AmountGreaterThanOrEqualTo>0</AmountGreaterThanOrEqualTo>
  <AmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </AmountIn>
  <AmountLessThan>0</AmountLessThan>
  <AmountLessThanOrEqualTo>0</AmountLessThanOrEqualTo>
  <AmountNotEqualTo>0</AmountNotEqualTo>
  <Category>String</Category>
  <CategoryBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CategoryBetween>
  <CategoryContains>String</CategoryContains>
  <CategoryEndsWith>String</CategoryEndsWith>
  <CategoryIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CategoryIn>
  <CategoryLike>String</CategoryLike>
  <CategoryStartsWith>String</CategoryStartsWith>
  <Seg1>String</Seg1>
  <Seg1Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg1Between>
  <Seg1Contains>String</Seg1Contains>
  <Seg1EndsWith>String</Seg1EndsWith>
  <Seg1In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg1In>
  <Seg1Like>String</Seg1Like>
  <Seg1StartsWith>String</Seg1StartsWith>
  <Seg2>String</Seg2>
  <Seg2Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg2Between>
  <Seg2Contains>String</Seg2Contains>
  <Seg2EndsWith>String</Seg2EndsWith>
  <Seg2In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg2In>
  <Seg2Like>String</Seg2Like>
  <Seg2StartsWith>String</Seg2StartsWith>
  <Seg3>String</Seg3>
  <Seg3Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg3Between>
  <Seg3Contains>String</Seg3Contains>
  <Seg3EndsWith>String</Seg3EndsWith>
  <Seg3In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg3In>
  <Seg3Like>String</Seg3Like>
  <Seg3StartsWith>String</Seg3StartsWith>
  <Seg4>String</Seg4>
  <Seg4Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg4Between>
  <Seg4Contains>String</Seg4Contains>
  <Seg4EndsWith>String</Seg4EndsWith>
  <Seg4In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg4In>
  <Seg4Like>String</Seg4Like>
  <Seg4StartsWith>String</Seg4StartsWith>
  <Seg5>String</Seg5>
  <Seg5Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg5Between>
  <Seg5Contains>String</Seg5Contains>
  <Seg5EndsWith>String</Seg5EndsWith>
  <Seg5In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg5In>
  <Seg5Like>String</Seg5Like>
  <Seg5StartsWith>String</Seg5StartsWith>
  <Seg6>String</Seg6>
  <Seg6Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg6Between>
  <Seg6Contains>String</Seg6Contains>
  <Seg6EndsWith>String</Seg6EndsWith>
  <Seg6In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Seg6In>
  <Seg6Like>String</Seg6Like>
  <Seg6StartsWith>String</Seg6StartsWith>
  <TransPostDateTime>0001-01-01T00:00:00</TransPostDateTime>
  <TransPostDateTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransPostDateTimeBetween>
  <TransPostDateTimeGreaterThan>0001-01-01T00:00:00</TransPostDateTimeGreaterThan>
  <TransPostDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</TransPostDateTimeGreaterThanOrEqualTo>
  <TransPostDateTimeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransPostDateTimeIn>
  <TransPostDateTimeLessThan>0001-01-01T00:00:00</TransPostDateTimeLessThan>
  <TransPostDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</TransPostDateTimeLessThanOrEqualTo>
  <TransPostDateTimeNotEqualTo>0001-01-01T00:00:00</TransPostDateTimeNotEqualTo>
</v_GL_TransactionsQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfv_GL_Transactions7kRqkrSv 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:v_GL_Transactions>
      <d2p1:_x003C_AccountDescription_x003E_k__BackingField>String</d2p1:_x003C_AccountDescription_x003E_k__BackingField>
      <d2p1:_x003C_Amount_x003E_k__BackingField>0</d2p1:_x003C_Amount_x003E_k__BackingField>
      <d2p1:_x003C_Category_x003E_k__BackingField>String</d2p1:_x003C_Category_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_TransPostDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_TransPostDateTime_x003E_k__BackingField>
    </d2p1:v_GL_Transactions>
  </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>
</QueryResponseOfv_GL_Transactions7kRqkrSv>