JiwaAPI

GL_BankDetailsQuery

**GL_BankDetailsQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
GLLedgerID	query	string	No
GLLedgerIDStartsWith	query	string	No
GLLedgerIDEndsWith	query	string	No
GLLedgerIDContains	query	string	No
GLLedgerIDLike	query	string	No
GLLedgerIDBetween	query	string[]	No
GLLedgerIDIn	query	string[]	No
NextChequeNumber	query	string	No
NextChequeNumberStartsWith	query	string	No
NextChequeNumberEndsWith	query	string	No
NextChequeNumberContains	query	string	No
NextChequeNumberLike	query	string	No
NextChequeNumberBetween	query	string[]	No
NextChequeNumberIn	query	string[]	No
BankName	query	string	No
BankNameStartsWith	query	string	No
BankNameEndsWith	query	string	No
BankNameContains	query	string	No
BankNameLike	query	string	No
BankNameBetween	query	string[]	No
BankNameIn	query	string[]	No
BSBN	query	string	No
BSBNStartsWith	query	string	No
BSBNEndsWith	query	string	No
BSBNContains	query	string	No
BSBNLike	query	string	No
BSBNBetween	query	string[]	No
BSBNIn	query	string[]	No
AccountNumber	query	string	No
AccountNumberStartsWith	query	string	No
AccountNumberEndsWith	query	string	No
AccountNumberContains	query	string	No
AccountNumberLike	query	string	No
AccountNumberBetween	query	string[]	No
AccountNumberIn	query	string[]	No
AccountName	query	string	No
AccountNameStartsWith	query	string	No
AccountNameEndsWith	query	string	No
AccountNameContains	query	string	No
AccountNameLike	query	string	No
AccountNameBetween	query	string[]	No
AccountNameIn	query	string[]	No
DefaultBank	query	bool?	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	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	No
FeesLedgerID	query	string	No
FeesLedgerIDStartsWith	query	string	No
FeesLedgerIDEndsWith	query	string	No
FeesLedgerIDContains	query	string	No
FeesLedgerIDLike	query	string	No
FeesLedgerIDBetween	query	string[]	No
FeesLedgerIDIn	query	string[]	No
EFTBankCode	query	string	No
EFTBankCodeStartsWith	query	string	No
EFTBankCodeEndsWith	query	string	No
EFTBankCodeContains	query	string	No
EFTBankCodeLike	query	string	No
EFTBankCodeBetween	query	string[]	No
EFTBankCodeIn	query	string[]	No
UserIdentificationNumber	query	string	No
UserIdentificationNumberStartsWith	query	string	No
UserIdentificationNumberEndsWith	query	string	No
UserIdentificationNumberContains	query	string	No
UserIdentificationNumberLike	query	string	No
UserIdentificationNumberBetween	query	string[]	No
UserIdentificationNumberIn	query	string[]	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_BankDetails** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
GLLedgerID	form	string	No
NextChequeNumber	form	string	No
BankName	form	string	No
BSBN	form	string	No
AccountNumber	form	string	No
AccountName	form	string	No
DefaultBank	form	bool?	No
LastSavedDateTime	form	DateTime	No
FeesLedgerID	form	string	No
EFTBankCode	form	string	No
UserIdentificationNumber	form	string	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 .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/GL_BankDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<GL_BankDetailsQuery 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>
  <AccountName>String</AccountName>
  <AccountNameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountNameBetween>
  <AccountNameContains>String</AccountNameContains>
  <AccountNameEndsWith>String</AccountNameEndsWith>
  <AccountNameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountNameIn>
  <AccountNameLike>String</AccountNameLike>
  <AccountNameStartsWith>String</AccountNameStartsWith>
  <AccountNumber>String</AccountNumber>
  <AccountNumberBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountNumberBetween>
  <AccountNumberContains>String</AccountNumberContains>
  <AccountNumberEndsWith>String</AccountNumberEndsWith>
  <AccountNumberIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountNumberIn>
  <AccountNumberLike>String</AccountNumberLike>
  <AccountNumberStartsWith>String</AccountNumberStartsWith>
  <BSBN>String</BSBN>
  <BSBNBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BSBNBetween>
  <BSBNContains>String</BSBNContains>
  <BSBNEndsWith>String</BSBNEndsWith>
  <BSBNIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BSBNIn>
  <BSBNLike>String</BSBNLike>
  <BSBNStartsWith>String</BSBNStartsWith>
  <BankName>String</BankName>
  <BankNameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BankNameBetween>
  <BankNameContains>String</BankNameContains>
  <BankNameEndsWith>String</BankNameEndsWith>
  <BankNameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BankNameIn>
  <BankNameLike>String</BankNameLike>
  <BankNameStartsWith>String</BankNameStartsWith>
  <DefaultBank>false</DefaultBank>
  <EFTBankCode>String</EFTBankCode>
  <EFTBankCodeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EFTBankCodeBetween>
  <EFTBankCodeContains>String</EFTBankCodeContains>
  <EFTBankCodeEndsWith>String</EFTBankCodeEndsWith>
  <EFTBankCodeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EFTBankCodeIn>
  <EFTBankCodeLike>String</EFTBankCodeLike>
  <EFTBankCodeStartsWith>String</EFTBankCodeStartsWith>
  <FeesLedgerID>String</FeesLedgerID>
  <FeesLedgerIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FeesLedgerIDBetween>
  <FeesLedgerIDContains>String</FeesLedgerIDContains>
  <FeesLedgerIDEndsWith>String</FeesLedgerIDEndsWith>
  <FeesLedgerIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FeesLedgerIDIn>
  <FeesLedgerIDLike>String</FeesLedgerIDLike>
  <FeesLedgerIDStartsWith>String</FeesLedgerIDStartsWith>
  <GLLedgerID>String</GLLedgerID>
  <GLLedgerIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLLedgerIDBetween>
  <GLLedgerIDContains>String</GLLedgerIDContains>
  <GLLedgerIDEndsWith>String</GLLedgerIDEndsWith>
  <GLLedgerIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLLedgerIDIn>
  <GLLedgerIDLike>String</GLLedgerIDLike>
  <GLLedgerIDStartsWith>String</GLLedgerIDStartsWith>
  <LastSavedDateTime>0001-01-01T00:00:00</LastSavedDateTime>
  <LastSavedDateTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeBetween>
  <LastSavedDateTimeGreaterThan>0001-01-01T00:00:00</LastSavedDateTimeGreaterThan>
  <LastSavedDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeGreaterThanOrEqualTo>
  <LastSavedDateTimeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeIn>
  <LastSavedDateTimeLessThan>0001-01-01T00:00:00</LastSavedDateTimeLessThan>
  <LastSavedDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeLessThanOrEqualTo>
  <LastSavedDateTimeNotEqualTo>0001-01-01T00:00:00</LastSavedDateTimeNotEqualTo>
  <NextChequeNumber>String</NextChequeNumber>
  <NextChequeNumberBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NextChequeNumberBetween>
  <NextChequeNumberContains>String</NextChequeNumberContains>
  <NextChequeNumberEndsWith>String</NextChequeNumberEndsWith>
  <NextChequeNumberIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NextChequeNumberIn>
  <NextChequeNumberLike>String</NextChequeNumberLike>
  <NextChequeNumberStartsWith>String</NextChequeNumberStartsWith>
  <RecID>String</RecID>
  <RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDBetween>
  <RecIDContains>String</RecIDContains>
  <RecIDEndsWith>String</RecIDEndsWith>
  <RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDIn>
  <RecIDLike>String</RecIDLike>
  <RecIDStartsWith>String</RecIDStartsWith>
  <UserIdentificationNumber>String</UserIdentificationNumber>
  <UserIdentificationNumberBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserIdentificationNumberBetween>
  <UserIdentificationNumberContains>String</UserIdentificationNumberContains>
  <UserIdentificationNumberEndsWith>String</UserIdentificationNumberEndsWith>
  <UserIdentificationNumberIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserIdentificationNumberIn>
  <UserIdentificationNumberLike>String</UserIdentificationNumberLike>
  <UserIdentificationNumberStartsWith>String</UserIdentificationNumberStartsWith>
</GL_BankDetailsQuery>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfGL_BankDetails7kRqkrSv 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_BankDetails>
      <d2p1:_x003C_AccountName_x003E_k__BackingField>String</d2p1:_x003C_AccountName_x003E_k__BackingField>
      <d2p1:_x003C_AccountNumber_x003E_k__BackingField>String</d2p1:_x003C_AccountNumber_x003E_k__BackingField>
      <d2p1:_x003C_BSBN_x003E_k__BackingField>String</d2p1:_x003C_BSBN_x003E_k__BackingField>
      <d2p1:_x003C_BankName_x003E_k__BackingField>String</d2p1:_x003C_BankName_x003E_k__BackingField>
      <d2p1:_x003C_DefaultBank_x003E_k__BackingField>false</d2p1:_x003C_DefaultBank_x003E_k__BackingField>
      <d2p1:_x003C_EFTBankCode_x003E_k__BackingField>String</d2p1:_x003C_EFTBankCode_x003E_k__BackingField>
      <d2p1:_x003C_FeesLedgerID_x003E_k__BackingField>String</d2p1:_x003C_FeesLedgerID_x003E_k__BackingField>
      <d2p1:_x003C_GLLedgerID_x003E_k__BackingField>String</d2p1:_x003C_GLLedgerID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_NextChequeNumber_x003E_k__BackingField>String</d2p1:_x003C_NextChequeNumber_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_UserIdentificationNumber_x003E_k__BackingField>String</d2p1:_x003C_UserIdentificationNumber_x003E_k__BackingField>
    </d2p1:GL_BankDetails>
  </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_BankDetails7kRqkrSv>