JiwaAPI

GL_TransactionsQuery

**GL_TransactionsQuery** Parameters:
Name	Parameter	Data Type	Required
GLTransactionID	query	string	No
GLTransactionIDStartsWith	query	string	No
GLTransactionIDEndsWith	query	string	No
GLTransactionIDContains	query	string	No
GLTransactionIDLike	query	string	No
GLTransactionIDBetween	query	string[]	No
GLTransactionIDIn	query	string[]	No
GLSetID	query	string	No
GLSetIDStartsWith	query	string	No
GLSetIDEndsWith	query	string	No
GLSetIDContains	query	string	No
GLSetIDLike	query	string	No
GLSetIDBetween	query	string[]	No
GLSetIDIn	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
DebitCredit	query	bool?	No
Amount	query	decimal?	No
AmountGreaterThanOrEqualTo	query	decimal?	No
AmountGreaterThan	query	decimal?	No
AmountLessThan	query	decimal?	No
AmountLessThanOrEqualTo	query	decimal?	No
AmountNotEqualTo	query	decimal?	No
AmountBetween	query	Nullable<Decimal>[]	No
AmountIn	query	Nullable<Decimal>[]	No
Ref	query	string	No
RefStartsWith	query	string	No
RefEndsWith	query	string	No
RefContains	query	string	No
RefLike	query	string	No
RefBetween	query	string[]	No
RefIn	query	string[]	No
Remark	query	string	No
RemarkStartsWith	query	string	No
RemarkEndsWith	query	string	No
RemarkContains	query	string	No
RemarkLike	query	string	No
RemarkBetween	query	string[]	No
RemarkIn	query	string[]	No
LineNum	query	int?	No
LineNumGreaterThanOrEqualTo	query	int?	No
LineNumGreaterThan	query	int?	No
LineNumLessThan	query	int?	No
LineNumLessThanOrEqualTo	query	int?	No
LineNumNotEqualTo	query	int?	No
LineNumBetween	query	int[]	No
LineNumIn	query	int[]	No
TransCode1ID	query	string	No
TransCode1IDStartsWith	query	string	No
TransCode1IDEndsWith	query	string	No
TransCode1IDContains	query	string	No
TransCode1IDLike	query	string	No
TransCode1IDBetween	query	string[]	No
TransCode1IDIn	query	string[]	No
TransCode2ID	query	string	No
TransCode2IDStartsWith	query	string	No
TransCode2IDEndsWith	query	string	No
TransCode2IDContains	query	string	No
TransCode2IDLike	query	string	No
TransCode2IDBetween	query	string[]	No
TransCode2IDIn	query	string[]	No
TransCode3ID	query	string	No
TransCode3IDStartsWith	query	string	No
TransCode3IDEndsWith	query	string	No
TransCode3IDContains	query	string	No
TransCode3IDLike	query	string	No
TransCode3IDBetween	query	string[]	No
TransCode3IDIn	query	string[]	No
StaffID	query	string	No
StaffIDStartsWith	query	string	No
StaffIDEndsWith	query	string	No
StaffIDContains	query	string	No
StaffIDLike	query	string	No
StaffIDBetween	query	string[]	No
StaffIDIn	query	string[]	No
Reconciled	query	bool?	No
Cleared	query	bool?	No
TransPostDateTime	query	DateTime?	No
TransPostDateTimeGreaterThanOrEqualTo	query	DateTime?	No
TransPostDateTimeGreaterThan	query	DateTime?	No
TransPostDateTimeLessThan	query	DateTime?	No
TransPostDateTimeLessThanOrEqualTo	query	DateTime?	No
TransPostDateTimeNotEqualTo	query	DateTime?	No
TransPostDateTimeBetween	query	Nullable<DateTime>[]	No
TransPostDateTimeIn	query	Nullable<DateTime>[]	No
JB_JobStages_RecID	query	string	No
JB_JobStages_RecIDStartsWith	query	string	No
JB_JobStages_RecIDEndsWith	query	string	No
JB_JobStages_RecIDContains	query	string	No
JB_JobStages_RecIDLike	query	string	No
JB_JobStages_RecIDBetween	query	string[]	No
JB_JobStages_RecIDIn	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_Transactions** Parameters:
Name	Parameter	Data Type	Required
GLTransactionID	form	string	No
GLSetID	form	string	No
GLLedgerID	form	string	No
DebitCredit	form	bool?	No
Amount	form	decimal?	No
Ref	form	string	No
Remark	form	string	No
LineNum	form	int	No
TransCode1ID	form	string	No
TransCode2ID	form	string	No
TransCode3ID	form	string	No
StaffID	form	string	No
Reconciled	form	bool?	No
Cleared	form	bool?	No
TransPostDateTime	form	DateTime?	No
JB_JobStages_RecID	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_TransactionsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<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>
  <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>
  <Cleared>false</Cleared>
  <DebitCredit>false</DebitCredit>
  <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>
  <GLSetID>String</GLSetID>
  <GLSetIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLSetIDBetween>
  <GLSetIDContains>String</GLSetIDContains>
  <GLSetIDEndsWith>String</GLSetIDEndsWith>
  <GLSetIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLSetIDIn>
  <GLSetIDLike>String</GLSetIDLike>
  <GLSetIDStartsWith>String</GLSetIDStartsWith>
  <GLTransactionID>String</GLTransactionID>
  <GLTransactionIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLTransactionIDBetween>
  <GLTransactionIDContains>String</GLTransactionIDContains>
  <GLTransactionIDEndsWith>String</GLTransactionIDEndsWith>
  <GLTransactionIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GLTransactionIDIn>
  <GLTransactionIDLike>String</GLTransactionIDLike>
  <GLTransactionIDStartsWith>String</GLTransactionIDStartsWith>
  <JB_JobStages_RecID>String</JB_JobStages_RecID>
  <JB_JobStages_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_JobStages_RecIDBetween>
  <JB_JobStages_RecIDContains>String</JB_JobStages_RecIDContains>
  <JB_JobStages_RecIDEndsWith>String</JB_JobStages_RecIDEndsWith>
  <JB_JobStages_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_JobStages_RecIDIn>
  <JB_JobStages_RecIDLike>String</JB_JobStages_RecIDLike>
  <JB_JobStages_RecIDStartsWith>String</JB_JobStages_RecIDStartsWith>
  <LineNum>0</LineNum>
  <LineNumBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </LineNumBetween>
  <LineNumGreaterThan>0</LineNumGreaterThan>
  <LineNumGreaterThanOrEqualTo>0</LineNumGreaterThanOrEqualTo>
  <LineNumIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </LineNumIn>
  <LineNumLessThan>0</LineNumLessThan>
  <LineNumLessThanOrEqualTo>0</LineNumLessThanOrEqualTo>
  <LineNumNotEqualTo>0</LineNumNotEqualTo>
  <Reconciled>false</Reconciled>
  <Ref>String</Ref>
  <RefBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RefBetween>
  <RefContains>String</RefContains>
  <RefEndsWith>String</RefEndsWith>
  <RefIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RefIn>
  <RefLike>String</RefLike>
  <RefStartsWith>String</RefStartsWith>
  <Remark>String</Remark>
  <RemarkBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemarkBetween>
  <RemarkContains>String</RemarkContains>
  <RemarkEndsWith>String</RemarkEndsWith>
  <RemarkIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemarkIn>
  <RemarkLike>String</RemarkLike>
  <RemarkStartsWith>String</RemarkStartsWith>
  <StaffID>String</StaffID>
  <StaffIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StaffIDBetween>
  <StaffIDContains>String</StaffIDContains>
  <StaffIDEndsWith>String</StaffIDEndsWith>
  <StaffIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StaffIDIn>
  <StaffIDLike>String</StaffIDLike>
  <StaffIDStartsWith>String</StaffIDStartsWith>
  <TransCode1ID>String</TransCode1ID>
  <TransCode1IDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TransCode1IDBetween>
  <TransCode1IDContains>String</TransCode1IDContains>
  <TransCode1IDEndsWith>String</TransCode1IDEndsWith>
  <TransCode1IDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TransCode1IDIn>
  <TransCode1IDLike>String</TransCode1IDLike>
  <TransCode1IDStartsWith>String</TransCode1IDStartsWith>
  <TransCode2ID>String</TransCode2ID>
  <TransCode2IDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TransCode2IDBetween>
  <TransCode2IDContains>String</TransCode2IDContains>
  <TransCode2IDEndsWith>String</TransCode2IDEndsWith>
  <TransCode2IDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TransCode2IDIn>
  <TransCode2IDLike>String</TransCode2IDLike>
  <TransCode2IDStartsWith>String</TransCode2IDStartsWith>
  <TransCode3ID>String</TransCode3ID>
  <TransCode3IDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TransCode3IDBetween>
  <TransCode3IDContains>String</TransCode3IDContains>
  <TransCode3IDEndsWith>String</TransCode3IDEndsWith>
  <TransCode3IDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TransCode3IDIn>
  <TransCode3IDLike>String</TransCode3IDLike>
  <TransCode3IDStartsWith>String</TransCode3IDStartsWith>
  <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>
</GL_TransactionsQuery>

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

<QueryResponseOfGL_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:GL_Transactions>
      <d2p1:_x003C_Amount_x003E_k__BackingField>0</d2p1:_x003C_Amount_x003E_k__BackingField>
      <d2p1:_x003C_Cleared_x003E_k__BackingField>false</d2p1:_x003C_Cleared_x003E_k__BackingField>
      <d2p1:_x003C_DebitCredit_x003E_k__BackingField>false</d2p1:_x003C_DebitCredit_x003E_k__BackingField>
      <d2p1:_x003C_GLLedgerID_x003E_k__BackingField>String</d2p1:_x003C_GLLedgerID_x003E_k__BackingField>
      <d2p1:_x003C_GLSetID_x003E_k__BackingField>String</d2p1:_x003C_GLSetID_x003E_k__BackingField>
      <d2p1:_x003C_GLTransactionID_x003E_k__BackingField>String</d2p1:_x003C_GLTransactionID_x003E_k__BackingField>
      <d2p1:_x003C_JB_JobStages_RecID_x003E_k__BackingField>String</d2p1:_x003C_JB_JobStages_RecID_x003E_k__BackingField>
      <d2p1:_x003C_LineNum_x003E_k__BackingField>0</d2p1:_x003C_LineNum_x003E_k__BackingField>
      <d2p1:_x003C_Reconciled_x003E_k__BackingField>false</d2p1:_x003C_Reconciled_x003E_k__BackingField>
      <d2p1:_x003C_Ref_x003E_k__BackingField>String</d2p1:_x003C_Ref_x003E_k__BackingField>
      <d2p1:_x003C_Remark_x003E_k__BackingField>String</d2p1:_x003C_Remark_x003E_k__BackingField>
      <d2p1:_x003C_StaffID_x003E_k__BackingField>String</d2p1:_x003C_StaffID_x003E_k__BackingField>
      <d2p1:_x003C_TransCode1ID_x003E_k__BackingField>String</d2p1:_x003C_TransCode1ID_x003E_k__BackingField>
      <d2p1:_x003C_TransCode2ID_x003E_k__BackingField>String</d2p1:_x003C_TransCode2ID_x003E_k__BackingField>
      <d2p1:_x003C_TransCode3ID_x003E_k__BackingField>String</d2p1:_x003C_TransCode3ID_x003E_k__BackingField>
      <d2p1:_x003C_TransPostDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_TransPostDateTime_x003E_k__BackingField>
    </d2p1: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>
</QueryResponseOfGL_Transactions7kRqkrSv>