JiwaAPI

SO_ExportLinesQuery

**SO_ExportLinesQuery** 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
SO_ExportMain_RecID	query	string	No
SO_ExportMain_RecIDStartsWith	query	string	No
SO_ExportMain_RecIDEndsWith	query	string	No
SO_ExportMain_RecIDContains	query	string	No
SO_ExportMain_RecIDLike	query	string	No
SO_ExportMain_RecIDBetween	query	string[]	No
SO_ExportMain_RecIDIn	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
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
SO_Main_InvoiceID	query	string	No
SO_Main_InvoiceIDStartsWith	query	string	No
SO_Main_InvoiceIDEndsWith	query	string	No
SO_Main_InvoiceIDContains	query	string	No
SO_Main_InvoiceIDLike	query	string	No
SO_Main_InvoiceIDBetween	query	string[]	No
SO_Main_InvoiceIDIn	query	string[]	No
FlaggedForExport	query	bool?	No
SO_History_InvoiceHistoryID	query	string	No
SO_History_InvoiceHistoryIDStartsWith	query	string	No
SO_History_InvoiceHistoryIDEndsWith	query	string	No
SO_History_InvoiceHistoryIDContains	query	string	No
SO_History_InvoiceHistoryIDLike	query	string	No
SO_History_InvoiceHistoryIDBetween	query	string[]	No
SO_History_InvoiceHistoryIDIn	query	string[]	No
RowHash	query	byte[]	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

**SO_ExportLines** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
SO_ExportMain_RecID	form	string	No
LastSavedDateTime	form	DateTime	No
ItemNo	form	int	No
SO_Main_InvoiceID	form	string	No
FlaggedForExport	form	bool?	No
SO_History_InvoiceHistoryID	form	string	No
RowHash	form	byte[]	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/SO_ExportLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SO_ExportLinesQuery 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>
  <FlaggedForExport>false</FlaggedForExport>
  <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>
  <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>
  <SO_ExportMain_RecID>String</SO_ExportMain_RecID>
  <SO_ExportMain_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SO_ExportMain_RecIDBetween>
  <SO_ExportMain_RecIDContains>String</SO_ExportMain_RecIDContains>
  <SO_ExportMain_RecIDEndsWith>String</SO_ExportMain_RecIDEndsWith>
  <SO_ExportMain_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SO_ExportMain_RecIDIn>
  <SO_ExportMain_RecIDLike>String</SO_ExportMain_RecIDLike>
  <SO_ExportMain_RecIDStartsWith>String</SO_ExportMain_RecIDStartsWith>
  <SO_History_InvoiceHistoryID>String</SO_History_InvoiceHistoryID>
  <SO_History_InvoiceHistoryIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SO_History_InvoiceHistoryIDBetween>
  <SO_History_InvoiceHistoryIDContains>String</SO_History_InvoiceHistoryIDContains>
  <SO_History_InvoiceHistoryIDEndsWith>String</SO_History_InvoiceHistoryIDEndsWith>
  <SO_History_InvoiceHistoryIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SO_History_InvoiceHistoryIDIn>
  <SO_History_InvoiceHistoryIDLike>String</SO_History_InvoiceHistoryIDLike>
  <SO_History_InvoiceHistoryIDStartsWith>String</SO_History_InvoiceHistoryIDStartsWith>
  <SO_Main_InvoiceID>String</SO_Main_InvoiceID>
  <SO_Main_InvoiceIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SO_Main_InvoiceIDBetween>
  <SO_Main_InvoiceIDContains>String</SO_Main_InvoiceIDContains>
  <SO_Main_InvoiceIDEndsWith>String</SO_Main_InvoiceIDEndsWith>
  <SO_Main_InvoiceIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SO_Main_InvoiceIDIn>
  <SO_Main_InvoiceIDLike>String</SO_Main_InvoiceIDLike>
  <SO_Main_InvoiceIDStartsWith>String</SO_Main_InvoiceIDStartsWith>
</SO_ExportLinesQuery>

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

<QueryResponseOfSO_ExportLines7kRqkrSv 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:SO_ExportLines>
      <d2p1:_x003C_FlaggedForExport_x003E_k__BackingField>false</d2p1:_x003C_FlaggedForExport_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_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_SO_ExportMain_RecID_x003E_k__BackingField>String</d2p1:_x003C_SO_ExportMain_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SO_History_InvoiceHistoryID_x003E_k__BackingField>String</d2p1:_x003C_SO_History_InvoiceHistoryID_x003E_k__BackingField>
      <d2p1:_x003C_SO_Main_InvoiceID_x003E_k__BackingField>String</d2p1:_x003C_SO_Main_InvoiceID_x003E_k__BackingField>
    </d2p1:SO_ExportLines>
  </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>
</QueryResponseOfSO_ExportLines7kRqkrSv>