JiwaAPI

RE_LineDetailsQuery

**RE_LineDetailsQuery** 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
RE_Lines_RecID	query	string	No
RE_Lines_RecIDStartsWith	query	string	No
RE_Lines_RecIDEndsWith	query	string	No
RE_Lines_RecIDContains	query	string	No
RE_Lines_RecIDLike	query	string	No
RE_Lines_RecIDBetween	query	string[]	No
RE_Lines_RecIDIn	query	string[]	No
LinkID	query	string	No
LinkIDStartsWith	query	string	No
LinkIDEndsWith	query	string	No
LinkIDContains	query	string	No
LinkIDLike	query	string	No
LinkIDBetween	query	string[]	No
LinkIDIn	query	string[]	No
Quantity	query	decimal?	No
QuantityGreaterThanOrEqualTo	query	decimal?	No
QuantityGreaterThan	query	decimal?	No
QuantityLessThan	query	decimal?	No
QuantityLessThanOrEqualTo	query	decimal?	No
QuantityNotEqualTo	query	decimal?	No
QuantityBetween	query	decimal[]	No
QuantityIn	query	decimal[]	No
SerialNo	query	string	No
SerialNoStartsWith	query	string	No
SerialNoEndsWith	query	string	No
SerialNoContains	query	string	No
SerialNoLike	query	string	No
SerialNoBetween	query	string[]	No
SerialNoIn	query	string[]	No
BinLocationDescription	query	string	No
BinLocationDescriptionStartsWith	query	string	No
BinLocationDescriptionEndsWith	query	string	No
BinLocationDescriptionContains	query	string	No
BinLocationDescriptionLike	query	string	No
BinLocationDescriptionBetween	query	string[]	No
BinLocationDescriptionIn	query	string[]	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
RowHash	query	byte[]	No
ExpiryDate	query	DateTime?	No
ExpiryDateGreaterThanOrEqualTo	query	DateTime?	No
ExpiryDateGreaterThan	query	DateTime?	No
ExpiryDateLessThan	query	DateTime?	No
ExpiryDateLessThanOrEqualTo	query	DateTime?	No
ExpiryDateNotEqualTo	query	DateTime?	No
ExpiryDateBetween	query	Nullable<DateTime>[]	No
ExpiryDateIn	query	Nullable<DateTime>[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	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

**RE_LineDetails** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
RE_Lines_RecID	form	string	No
LinkID	form	string	No
Quantity	form	decimal	No
SerialNo	form	string	No
BinLocationDescription	form	string	No
LastSavedDateTime	form	DateTime	No
RowHash	form	byte[]	No
ExpiryDate	form	DateTime?	No
ItemNo	form	int	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/RE_LineDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<RE_LineDetailsQuery 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>
  <BinLocationDescription>String</BinLocationDescription>
  <BinLocationDescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BinLocationDescriptionBetween>
  <BinLocationDescriptionContains>String</BinLocationDescriptionContains>
  <BinLocationDescriptionEndsWith>String</BinLocationDescriptionEndsWith>
  <BinLocationDescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BinLocationDescriptionIn>
  <BinLocationDescriptionLike>String</BinLocationDescriptionLike>
  <BinLocationDescriptionStartsWith>String</BinLocationDescriptionStartsWith>
  <ExpiryDate>0001-01-01T00:00:00</ExpiryDate>
  <ExpiryDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ExpiryDateBetween>
  <ExpiryDateGreaterThan>0001-01-01T00:00:00</ExpiryDateGreaterThan>
  <ExpiryDateGreaterThanOrEqualTo>0001-01-01T00:00:00</ExpiryDateGreaterThanOrEqualTo>
  <ExpiryDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ExpiryDateIn>
  <ExpiryDateLessThan>0001-01-01T00:00:00</ExpiryDateLessThan>
  <ExpiryDateLessThanOrEqualTo>0001-01-01T00:00:00</ExpiryDateLessThanOrEqualTo>
  <ExpiryDateNotEqualTo>0001-01-01T00:00:00</ExpiryDateNotEqualTo>
  <ItemNo>0</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoBetween>
  <ItemNoGreaterThan>0</ItemNoGreaterThan>
  <ItemNoGreaterThanOrEqualTo>0</ItemNoGreaterThanOrEqualTo>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoIn>
  <ItemNoLessThan>0</ItemNoLessThan>
  <ItemNoLessThanOrEqualTo>0</ItemNoLessThanOrEqualTo>
  <ItemNoNotEqualTo>0</ItemNoNotEqualTo>
  <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>
  <LinkID>String</LinkID>
  <LinkIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LinkIDBetween>
  <LinkIDContains>String</LinkIDContains>
  <LinkIDEndsWith>String</LinkIDEndsWith>
  <LinkIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LinkIDIn>
  <LinkIDLike>String</LinkIDLike>
  <LinkIDStartsWith>String</LinkIDStartsWith>
  <Quantity>0</Quantity>
  <QuantityBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBetween>
  <QuantityGreaterThan>0</QuantityGreaterThan>
  <QuantityGreaterThanOrEqualTo>0</QuantityGreaterThanOrEqualTo>
  <QuantityIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityIn>
  <QuantityLessThan>0</QuantityLessThan>
  <QuantityLessThanOrEqualTo>0</QuantityLessThanOrEqualTo>
  <QuantityNotEqualTo>0</QuantityNotEqualTo>
  <RE_Lines_RecID>String</RE_Lines_RecID>
  <RE_Lines_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RE_Lines_RecIDBetween>
  <RE_Lines_RecIDContains>String</RE_Lines_RecIDContains>
  <RE_Lines_RecIDEndsWith>String</RE_Lines_RecIDEndsWith>
  <RE_Lines_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RE_Lines_RecIDIn>
  <RE_Lines_RecIDLike>String</RE_Lines_RecIDLike>
  <RE_Lines_RecIDStartsWith>String</RE_Lines_RecIDStartsWith>
  <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>
  <RowHash>AA==</RowHash>
  <SerialNo>String</SerialNo>
  <SerialNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SerialNoBetween>
  <SerialNoContains>String</SerialNoContains>
  <SerialNoEndsWith>String</SerialNoEndsWith>
  <SerialNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SerialNoIn>
  <SerialNoLike>String</SerialNoLike>
  <SerialNoStartsWith>String</SerialNoStartsWith>
</RE_LineDetailsQuery>

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

<QueryResponseOfRE_LineDetails7kRqkrSv 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:RE_LineDetails>
      <d2p1:_x003C_BinLocationDescription_x003E_k__BackingField>String</d2p1:_x003C_BinLocationDescription_x003E_k__BackingField>
      <d2p1:_x003C_ExpiryDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ExpiryDate_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LinkID_x003E_k__BackingField>String</d2p1:_x003C_LinkID_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_RE_Lines_RecID_x003E_k__BackingField>String</d2p1:_x003C_RE_Lines_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_SerialNo_x003E_k__BackingField>String</d2p1:_x003C_SerialNo_x003E_k__BackingField>
    </d2p1:RE_LineDetails>
  </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>
</QueryResponseOfRE_LineDetails7kRqkrSv>