JiwaAPI

<back to all web services

V_DBGL_ReconciliationQuery

Requires Authentication
V_DBGL_ReconciliationQuery Parameters:
NameParameterData TypeRequiredDescription
IDquerystringNo
IDStartsWithquerystringNo
IDEndsWithquerystringNo
IDContainsquerystringNo
IDLikequerystringNo
IDBetweenquerystring[]No
IDInquerystring[]No
AccountnoquerystringNo
AccountnoStartsWithquerystringNo
AccountnoEndsWithquerystringNo
AccountnoContainsquerystringNo
AccountnoLikequerystringNo
AccountnoBetweenquerystring[]No
AccountnoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
TransDatequeryDateTime?No
TransDateGreaterThanOrEqualToqueryDateTime?No
TransDateGreaterThanqueryDateTime?No
TransDateLessThanqueryDateTime?No
TransDateLessThanOrEqualToqueryDateTime?No
TransDateNotEqualToqueryDateTime?No
TransDateBetweenqueryNullable<DateTime>[]No
TransDateInqueryNullable<DateTime>[]No
SourceTextquerystringNo
SourceTextStartsWithquerystringNo
SourceTextEndsWithquerystringNo
SourceTextContainsquerystringNo
SourceTextLikequerystringNo
SourceTextBetweenquerystring[]No
SourceTextInquerystring[]No
SourceIDquerystringNo
SourceIDStartsWithquerystringNo
SourceIDEndsWithquerystringNo
SourceIDContainsquerystringNo
SourceIDLikequerystringNo
SourceIDBetweenquerystring[]No
SourceIDInquerystring[]No
SourceNumqueryint?No
SourceNumGreaterThanOrEqualToqueryint?No
SourceNumGreaterThanqueryint?No
SourceNumLessThanqueryint?No
SourceNumLessThanOrEqualToqueryint?No
SourceNumNotEqualToqueryint?No
SourceNumBetweenqueryNullable<Int32>[]No
SourceNumInqueryNullable<Int32>[]No
SubTypeNumqueryint?No
SubTypeNumGreaterThanOrEqualToqueryint?No
SubTypeNumGreaterThanqueryint?No
SubTypeNumLessThanqueryint?No
SubTypeNumLessThanOrEqualToqueryint?No
SubTypeNumNotEqualToqueryint?No
SubTypeNumBetweenqueryNullable<Int32>[]No
SubTypeNumInqueryNullable<Int32>[]No
Valuequerydecimal?No
ValueGreaterThanOrEqualToquerydecimal?No
ValueGreaterThanquerydecimal?No
ValueLessThanquerydecimal?No
ValueLessThanOrEqualToquerydecimal?No
ValueNotEqualToquerydecimal?No
ValueBetweenqueryNullable<Decimal>[]No
ValueInqueryNullable<Decimal>[]No
DebitCreditquerybool?No
ReportTypequerystringNo
ReportTypeStartsWithquerystringNo
ReportTypeEndsWithquerystringNo
ReportTypeContainsquerystringNo
ReportTypeLikequerystringNo
ReportTypeBetweenquerystring[]No
ReportTypeInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
V_DBGL_Reconciliation Parameters:
NameParameterData TypeRequiredDescription
IDformstringNo
AccountnoformstringNo
DescriptionformstringNo
TransDateformDateTime?No
SourceTextformstringNo
SourceIDformstringNo
SourceNumformint?No
SubTypeNumformint?No
Valueformdecimal?No
DebitCreditformbool?No
ReportTypeformstringNo
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_DBGL_ReconciliationQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<V_DBGL_ReconciliationQuery 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>
  <Accountno>String</Accountno>
  <AccountnoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountnoBetween>
  <AccountnoContains>String</AccountnoContains>
  <AccountnoEndsWith>String</AccountnoEndsWith>
  <AccountnoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountnoIn>
  <AccountnoLike>String</AccountnoLike>
  <AccountnoStartsWith>String</AccountnoStartsWith>
  <DebitCredit>false</DebitCredit>
  <Description>String</Description>
  <DescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionBetween>
  <DescriptionContains>String</DescriptionContains>
  <DescriptionEndsWith>String</DescriptionEndsWith>
  <DescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionIn>
  <DescriptionLike>String</DescriptionLike>
  <DescriptionStartsWith>String</DescriptionStartsWith>
  <ID>String</ID>
  <IDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IDBetween>
  <IDContains>String</IDContains>
  <IDEndsWith>String</IDEndsWith>
  <IDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IDIn>
  <IDLike>String</IDLike>
  <IDStartsWith>String</IDStartsWith>
  <ReportType>String</ReportType>
  <ReportTypeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReportTypeBetween>
  <ReportTypeContains>String</ReportTypeContains>
  <ReportTypeEndsWith>String</ReportTypeEndsWith>
  <ReportTypeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReportTypeIn>
  <ReportTypeLike>String</ReportTypeLike>
  <ReportTypeStartsWith>String</ReportTypeStartsWith>
  <SourceID>String</SourceID>
  <SourceIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceIDBetween>
  <SourceIDContains>String</SourceIDContains>
  <SourceIDEndsWith>String</SourceIDEndsWith>
  <SourceIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceIDIn>
  <SourceIDLike>String</SourceIDLike>
  <SourceIDStartsWith>String</SourceIDStartsWith>
  <SourceNum>0</SourceNum>
  <SourceNumBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </SourceNumBetween>
  <SourceNumGreaterThan>0</SourceNumGreaterThan>
  <SourceNumGreaterThanOrEqualTo>0</SourceNumGreaterThanOrEqualTo>
  <SourceNumIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </SourceNumIn>
  <SourceNumLessThan>0</SourceNumLessThan>
  <SourceNumLessThanOrEqualTo>0</SourceNumLessThanOrEqualTo>
  <SourceNumNotEqualTo>0</SourceNumNotEqualTo>
  <SourceText>String</SourceText>
  <SourceTextBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceTextBetween>
  <SourceTextContains>String</SourceTextContains>
  <SourceTextEndsWith>String</SourceTextEndsWith>
  <SourceTextIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceTextIn>
  <SourceTextLike>String</SourceTextLike>
  <SourceTextStartsWith>String</SourceTextStartsWith>
  <SubTypeNum>0</SubTypeNum>
  <SubTypeNumBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </SubTypeNumBetween>
  <SubTypeNumGreaterThan>0</SubTypeNumGreaterThan>
  <SubTypeNumGreaterThanOrEqualTo>0</SubTypeNumGreaterThanOrEqualTo>
  <SubTypeNumIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </SubTypeNumIn>
  <SubTypeNumLessThan>0</SubTypeNumLessThan>
  <SubTypeNumLessThanOrEqualTo>0</SubTypeNumLessThanOrEqualTo>
  <SubTypeNumNotEqualTo>0</SubTypeNumNotEqualTo>
  <TransDate>0001-01-01T00:00:00</TransDate>
  <TransDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransDateBetween>
  <TransDateGreaterThan>0001-01-01T00:00:00</TransDateGreaterThan>
  <TransDateGreaterThanOrEqualTo>0001-01-01T00:00:00</TransDateGreaterThanOrEqualTo>
  <TransDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransDateIn>
  <TransDateLessThan>0001-01-01T00:00:00</TransDateLessThan>
  <TransDateLessThanOrEqualTo>0001-01-01T00:00:00</TransDateLessThanOrEqualTo>
  <TransDateNotEqualTo>0001-01-01T00:00:00</TransDateNotEqualTo>
  <Value>0</Value>
  <ValueBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </ValueBetween>
  <ValueGreaterThan>0</ValueGreaterThan>
  <ValueGreaterThanOrEqualTo>0</ValueGreaterThanOrEqualTo>
  <ValueIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </ValueIn>
  <ValueLessThan>0</ValueLessThan>
  <ValueLessThanOrEqualTo>0</ValueLessThanOrEqualTo>
  <ValueNotEqualTo>0</ValueNotEqualTo>
</V_DBGL_ReconciliationQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfV_DBGL_Reconciliation7kRqkrSv 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_DBGL_Reconciliation>
      <d2p1:_x003C_Accountno_x003E_k__BackingField>String</d2p1:_x003C_Accountno_x003E_k__BackingField>
      <d2p1:_x003C_DebitCredit_x003E_k__BackingField>false</d2p1:_x003C_DebitCredit_x003E_k__BackingField>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_ID_x003E_k__BackingField>String</d2p1:_x003C_ID_x003E_k__BackingField>
      <d2p1:_x003C_ReportType_x003E_k__BackingField>String</d2p1:_x003C_ReportType_x003E_k__BackingField>
      <d2p1:_x003C_SourceID_x003E_k__BackingField>String</d2p1:_x003C_SourceID_x003E_k__BackingField>
      <d2p1:_x003C_SourceNum_x003E_k__BackingField>0</d2p1:_x003C_SourceNum_x003E_k__BackingField>
      <d2p1:_x003C_SourceText_x003E_k__BackingField>String</d2p1:_x003C_SourceText_x003E_k__BackingField>
      <d2p1:_x003C_SubTypeNum_x003E_k__BackingField>0</d2p1:_x003C_SubTypeNum_x003E_k__BackingField>
      <d2p1:_x003C_TransDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_TransDate_x003E_k__BackingField>
      <d2p1:_x003C_Value_x003E_k__BackingField>0</d2p1:_x003C_Value_x003E_k__BackingField>
    </d2p1:V_DBGL_Reconciliation>
  </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_DBGL_Reconciliation7kRqkrSv>