JiwaAPI

QO_LineExtraQuery

**QO_LineExtraQuery** Parameters:
Name	Parameter	Data Type	Required
SOLineExtraRecID	query	string	No
SOLineExtraRecIDStartsWith	query	string	No
SOLineExtraRecIDEndsWith	query	string	No
SOLineExtraRecIDContains	query	string	No
SOLineExtraRecIDLike	query	string	No
SOLineExtraRecIDBetween	query	string[]	No
SOLineExtraRecIDIn	query	string[]	No
InvoiceLineID	query	string	No
InvoiceLineIDStartsWith	query	string	No
InvoiceLineIDEndsWith	query	string	No
InvoiceLineIDContains	query	string	No
InvoiceLineIDLike	query	string	No
InvoiceLineIDBetween	query	string[]	No
InvoiceLineIDIn	query	string[]	No
InvoiceHistoryID	query	string	No
InvoiceHistoryIDStartsWith	query	string	No
InvoiceHistoryIDEndsWith	query	string	No
InvoiceHistoryIDContains	query	string	No
InvoiceHistoryIDLike	query	string	No
InvoiceHistoryIDBetween	query	string[]	No
InvoiceHistoryIDIn	query	string[]	No
LedgerReversePurchaseAccID	query	string	No
LedgerReversePurchaseAccIDStartsWith	query	string	No
LedgerReversePurchaseAccIDEndsWith	query	string	No
LedgerReversePurchaseAccIDContains	query	string	No
LedgerReversePurchaseAccIDLike	query	string	No
LedgerReversePurchaseAccIDBetween	query	string[]	No
LedgerReversePurchaseAccIDIn	query	string[]	No
LedgerMovement_COGAccID	query	string	No
LedgerMovement_COGAccIDStartsWith	query	string	No
LedgerMovement_COGAccIDEndsWith	query	string	No
LedgerMovement_COGAccIDContains	query	string	No
LedgerMovement_COGAccIDLike	query	string	No
LedgerMovement_COGAccIDBetween	query	string[]	No
LedgerMovement_COGAccIDIn	query	string[]	No
LedgerSalesAccID	query	string	No
LedgerSalesAccIDStartsWith	query	string	No
LedgerSalesAccIDEndsWith	query	string	No
LedgerSalesAccIDContains	query	string	No
LedgerSalesAccIDLike	query	string	No
LedgerSalesAccIDBetween	query	string[]	No
LedgerSalesAccIDIn	query	string[]	No
LedgerSalesReturnsAccID	query	string	No
LedgerSalesReturnsAccIDStartsWith	query	string	No
LedgerSalesReturnsAccIDEndsWith	query	string	No
LedgerSalesReturnsAccIDContains	query	string	No
LedgerSalesReturnsAccIDLike	query	string	No
LedgerSalesReturnsAccIDBetween	query	string[]	No
LedgerSalesReturnsAccIDIn	query	string[]	No
LedgerTaxLiabAccID	query	string	No
LedgerTaxLiabAccIDStartsWith	query	string	No
LedgerTaxLiabAccIDEndsWith	query	string	No
LedgerTaxLiabAccIDContains	query	string	No
LedgerTaxLiabAccIDLike	query	string	No
LedgerTaxLiabAccIDBetween	query	string[]	No
LedgerTaxLiabAccIDIn	query	string[]	No
LedgerTaxExpAccID	query	string	No
LedgerTaxExpAccIDStartsWith	query	string	No
LedgerTaxExpAccIDEndsWith	query	string	No
LedgerTaxExpAccIDContains	query	string	No
LedgerTaxExpAccIDLike	query	string	No
LedgerTaxExpAccIDBetween	query	string[]	No
LedgerTaxExpAccIDIn	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

**QO_LineExtra** Parameters:
Name	Parameter	Data Type	Required
SOLineExtraRecID	form	string	No
InvoiceLineID	form	string	No
InvoiceHistoryID	form	string	No
LedgerReversePurchaseAccID	form	string	No
LedgerMovement_COGAccID	form	string	No
LedgerSalesAccID	form	string	No
LedgerSalesReturnsAccID	form	string	No
LedgerTaxLiabAccID	form	string	No
LedgerTaxExpAccID	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/QO_LineExtraQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<QO_LineExtraQuery 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>
  <InvoiceHistoryID>String</InvoiceHistoryID>
  <InvoiceHistoryIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceHistoryIDBetween>
  <InvoiceHistoryIDContains>String</InvoiceHistoryIDContains>
  <InvoiceHistoryIDEndsWith>String</InvoiceHistoryIDEndsWith>
  <InvoiceHistoryIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceHistoryIDIn>
  <InvoiceHistoryIDLike>String</InvoiceHistoryIDLike>
  <InvoiceHistoryIDStartsWith>String</InvoiceHistoryIDStartsWith>
  <InvoiceLineID>String</InvoiceLineID>
  <InvoiceLineIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceLineIDBetween>
  <InvoiceLineIDContains>String</InvoiceLineIDContains>
  <InvoiceLineIDEndsWith>String</InvoiceLineIDEndsWith>
  <InvoiceLineIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceLineIDIn>
  <InvoiceLineIDLike>String</InvoiceLineIDLike>
  <InvoiceLineIDStartsWith>String</InvoiceLineIDStartsWith>
  <LedgerMovement_COGAccID>String</LedgerMovement_COGAccID>
  <LedgerMovement_COGAccIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerMovement_COGAccIDBetween>
  <LedgerMovement_COGAccIDContains>String</LedgerMovement_COGAccIDContains>
  <LedgerMovement_COGAccIDEndsWith>String</LedgerMovement_COGAccIDEndsWith>
  <LedgerMovement_COGAccIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerMovement_COGAccIDIn>
  <LedgerMovement_COGAccIDLike>String</LedgerMovement_COGAccIDLike>
  <LedgerMovement_COGAccIDStartsWith>String</LedgerMovement_COGAccIDStartsWith>
  <LedgerReversePurchaseAccID>String</LedgerReversePurchaseAccID>
  <LedgerReversePurchaseAccIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerReversePurchaseAccIDBetween>
  <LedgerReversePurchaseAccIDContains>String</LedgerReversePurchaseAccIDContains>
  <LedgerReversePurchaseAccIDEndsWith>String</LedgerReversePurchaseAccIDEndsWith>
  <LedgerReversePurchaseAccIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerReversePurchaseAccIDIn>
  <LedgerReversePurchaseAccIDLike>String</LedgerReversePurchaseAccIDLike>
  <LedgerReversePurchaseAccIDStartsWith>String</LedgerReversePurchaseAccIDStartsWith>
  <LedgerSalesAccID>String</LedgerSalesAccID>
  <LedgerSalesAccIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerSalesAccIDBetween>
  <LedgerSalesAccIDContains>String</LedgerSalesAccIDContains>
  <LedgerSalesAccIDEndsWith>String</LedgerSalesAccIDEndsWith>
  <LedgerSalesAccIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerSalesAccIDIn>
  <LedgerSalesAccIDLike>String</LedgerSalesAccIDLike>
  <LedgerSalesAccIDStartsWith>String</LedgerSalesAccIDStartsWith>
  <LedgerSalesReturnsAccID>String</LedgerSalesReturnsAccID>
  <LedgerSalesReturnsAccIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerSalesReturnsAccIDBetween>
  <LedgerSalesReturnsAccIDContains>String</LedgerSalesReturnsAccIDContains>
  <LedgerSalesReturnsAccIDEndsWith>String</LedgerSalesReturnsAccIDEndsWith>
  <LedgerSalesReturnsAccIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerSalesReturnsAccIDIn>
  <LedgerSalesReturnsAccIDLike>String</LedgerSalesReturnsAccIDLike>
  <LedgerSalesReturnsAccIDStartsWith>String</LedgerSalesReturnsAccIDStartsWith>
  <LedgerTaxExpAccID>String</LedgerTaxExpAccID>
  <LedgerTaxExpAccIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerTaxExpAccIDBetween>
  <LedgerTaxExpAccIDContains>String</LedgerTaxExpAccIDContains>
  <LedgerTaxExpAccIDEndsWith>String</LedgerTaxExpAccIDEndsWith>
  <LedgerTaxExpAccIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerTaxExpAccIDIn>
  <LedgerTaxExpAccIDLike>String</LedgerTaxExpAccIDLike>
  <LedgerTaxExpAccIDStartsWith>String</LedgerTaxExpAccIDStartsWith>
  <LedgerTaxLiabAccID>String</LedgerTaxLiabAccID>
  <LedgerTaxLiabAccIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerTaxLiabAccIDBetween>
  <LedgerTaxLiabAccIDContains>String</LedgerTaxLiabAccIDContains>
  <LedgerTaxLiabAccIDEndsWith>String</LedgerTaxLiabAccIDEndsWith>
  <LedgerTaxLiabAccIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LedgerTaxLiabAccIDIn>
  <LedgerTaxLiabAccIDLike>String</LedgerTaxLiabAccIDLike>
  <LedgerTaxLiabAccIDStartsWith>String</LedgerTaxLiabAccIDStartsWith>
  <SOLineExtraRecID>String</SOLineExtraRecID>
  <SOLineExtraRecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SOLineExtraRecIDBetween>
  <SOLineExtraRecIDContains>String</SOLineExtraRecIDContains>
  <SOLineExtraRecIDEndsWith>String</SOLineExtraRecIDEndsWith>
  <SOLineExtraRecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SOLineExtraRecIDIn>
  <SOLineExtraRecIDLike>String</SOLineExtraRecIDLike>
  <SOLineExtraRecIDStartsWith>String</SOLineExtraRecIDStartsWith>
</QO_LineExtraQuery>

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

<QueryResponseOfQO_LineExtra7kRqkrSv 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:QO_LineExtra>
      <d2p1:_x003C_InvoiceHistoryID_x003E_k__BackingField>String</d2p1:_x003C_InvoiceHistoryID_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceLineID_x003E_k__BackingField>String</d2p1:_x003C_InvoiceLineID_x003E_k__BackingField>
      <d2p1:_x003C_LedgerMovement_COGAccID_x003E_k__BackingField>String</d2p1:_x003C_LedgerMovement_COGAccID_x003E_k__BackingField>
      <d2p1:_x003C_LedgerReversePurchaseAccID_x003E_k__BackingField>String</d2p1:_x003C_LedgerReversePurchaseAccID_x003E_k__BackingField>
      <d2p1:_x003C_LedgerSalesAccID_x003E_k__BackingField>String</d2p1:_x003C_LedgerSalesAccID_x003E_k__BackingField>
      <d2p1:_x003C_LedgerSalesReturnsAccID_x003E_k__BackingField>String</d2p1:_x003C_LedgerSalesReturnsAccID_x003E_k__BackingField>
      <d2p1:_x003C_LedgerTaxExpAccID_x003E_k__BackingField>String</d2p1:_x003C_LedgerTaxExpAccID_x003E_k__BackingField>
      <d2p1:_x003C_LedgerTaxLiabAccID_x003E_k__BackingField>String</d2p1:_x003C_LedgerTaxLiabAccID_x003E_k__BackingField>
      <d2p1:_x003C_SOLineExtraRecID_x003E_k__BackingField>String</d2p1:_x003C_SOLineExtraRecID_x003E_k__BackingField>
    </d2p1:QO_LineExtra>
  </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>
</QueryResponseOfQO_LineExtra7kRqkrSv>