JiwaAPI

EX_ExportQueueQuery

**EX_ExportQueueQuery** Parameters:
Name	Parameter	Data Type	Required
ExportQueueID	query	string	No
ExportQueueIDStartsWith	query	string	No
ExportQueueIDEndsWith	query	string	No
ExportQueueIDContains	query	string	No
ExportQueueIDLike	query	string	No
ExportQueueIDBetween	query	string[]	No
ExportQueueIDIn	query	string[]	No
ExportData	query	string	No
ExportDataStartsWith	query	string	No
ExportDataEndsWith	query	string	No
ExportDataContains	query	string	No
ExportDataLike	query	string	No
ExportDataBetween	query	string[]	No
ExportDataIn	query	string[]	No
Status	query	byte?	No
StatusGreaterThanOrEqualTo	query	byte?	No
StatusGreaterThan	query	byte?	No
StatusLessThan	query	byte?	No
StatusLessThanOrEqualTo	query	byte?	No
StatusNotEqualTo	query	byte?	No
StatusBetween	query	byte[]	No
StatusIn	query	byte[]	No
AddedToQueueDateTime	query	DateTime?	No
AddedToQueueDateTimeGreaterThanOrEqualTo	query	DateTime?	No
AddedToQueueDateTimeGreaterThan	query	DateTime?	No
AddedToQueueDateTimeLessThan	query	DateTime?	No
AddedToQueueDateTimeLessThanOrEqualTo	query	DateTime?	No
AddedToQueueDateTimeNotEqualTo	query	DateTime?	No
AddedToQueueDateTimeBetween	query	DateTime[]	No
AddedToQueueDateTimeIn	query	DateTime[]	No
AddedToQueueByStaffID	query	string	No
AddedToQueueByStaffIDStartsWith	query	string	No
AddedToQueueByStaffIDEndsWith	query	string	No
AddedToQueueByStaffIDContains	query	string	No
AddedToQueueByStaffIDLike	query	string	No
AddedToQueueByStaffIDBetween	query	string[]	No
AddedToQueueByStaffIDIn	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	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<DateTime>[]	No
LastSavedByStaffID	query	string	No
LastSavedByStaffIDStartsWith	query	string	No
LastSavedByStaffIDEndsWith	query	string	No
LastSavedByStaffIDContains	query	string	No
LastSavedByStaffIDLike	query	string	No
LastSavedByStaffIDBetween	query	string[]	No
LastSavedByStaffIDIn	query	string[]	No
ExportErrorMessage	query	string	No
ExportErrorMessageStartsWith	query	string	No
ExportErrorMessageEndsWith	query	string	No
ExportErrorMessageContains	query	string	No
ExportErrorMessageLike	query	string	No
ExportErrorMessageBetween	query	string[]	No
ExportErrorMessageIn	query	string[]	No
ExportBatchID	query	string	No
ExportBatchIDStartsWith	query	string	No
ExportBatchIDEndsWith	query	string	No
ExportBatchIDContains	query	string	No
ExportBatchIDLike	query	string	No
ExportBatchIDBetween	query	string[]	No
ExportBatchIDIn	query	string[]	No
BatchNo	query	string	No
BatchNoStartsWith	query	string	No
BatchNoEndsWith	query	string	No
BatchNoContains	query	string	No
BatchNoLike	query	string	No
BatchNoBetween	query	string[]	No
BatchNoIn	query	string[]	No
ItemNo	query	string	No
ItemNoStartsWith	query	string	No
ItemNoEndsWith	query	string	No
ItemNoContains	query	string	No
ItemNoLike	query	string	No
ItemNoBetween	query	string[]	No
ItemNoIn	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

**EX_ExportQueue** Parameters:
Name	Parameter	Data Type	Required
ExportQueueID	form	string	No
ExportData	form	string	No
Status	form	byte	No
AddedToQueueDateTime	form	DateTime	No
AddedToQueueByStaffID	form	string	No
LastSavedDateTime	form	DateTime?	No
LastSavedByStaffID	form	string	No
ExportErrorMessage	form	string	No
ExportBatchID	form	string	No
BatchNo	form	string	No
ItemNo	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/EX_ExportQueueQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<EX_ExportQueueQuery 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>
  <AddedToQueueByStaffID>String</AddedToQueueByStaffID>
  <AddedToQueueByStaffIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AddedToQueueByStaffIDBetween>
  <AddedToQueueByStaffIDContains>String</AddedToQueueByStaffIDContains>
  <AddedToQueueByStaffIDEndsWith>String</AddedToQueueByStaffIDEndsWith>
  <AddedToQueueByStaffIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AddedToQueueByStaffIDIn>
  <AddedToQueueByStaffIDLike>String</AddedToQueueByStaffIDLike>
  <AddedToQueueByStaffIDStartsWith>String</AddedToQueueByStaffIDStartsWith>
  <AddedToQueueDateTime>0001-01-01T00:00:00</AddedToQueueDateTime>
  <AddedToQueueDateTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </AddedToQueueDateTimeBetween>
  <AddedToQueueDateTimeGreaterThan>0001-01-01T00:00:00</AddedToQueueDateTimeGreaterThan>
  <AddedToQueueDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</AddedToQueueDateTimeGreaterThanOrEqualTo>
  <AddedToQueueDateTimeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </AddedToQueueDateTimeIn>
  <AddedToQueueDateTimeLessThan>0001-01-01T00:00:00</AddedToQueueDateTimeLessThan>
  <AddedToQueueDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</AddedToQueueDateTimeLessThanOrEqualTo>
  <AddedToQueueDateTimeNotEqualTo>0001-01-01T00:00:00</AddedToQueueDateTimeNotEqualTo>
  <BatchNo>String</BatchNo>
  <BatchNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BatchNoBetween>
  <BatchNoContains>String</BatchNoContains>
  <BatchNoEndsWith>String</BatchNoEndsWith>
  <BatchNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BatchNoIn>
  <BatchNoLike>String</BatchNoLike>
  <BatchNoStartsWith>String</BatchNoStartsWith>
  <ExportBatchID>String</ExportBatchID>
  <ExportBatchIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportBatchIDBetween>
  <ExportBatchIDContains>String</ExportBatchIDContains>
  <ExportBatchIDEndsWith>String</ExportBatchIDEndsWith>
  <ExportBatchIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportBatchIDIn>
  <ExportBatchIDLike>String</ExportBatchIDLike>
  <ExportBatchIDStartsWith>String</ExportBatchIDStartsWith>
  <ExportData>String</ExportData>
  <ExportDataBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportDataBetween>
  <ExportDataContains>String</ExportDataContains>
  <ExportDataEndsWith>String</ExportDataEndsWith>
  <ExportDataIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportDataIn>
  <ExportDataLike>String</ExportDataLike>
  <ExportDataStartsWith>String</ExportDataStartsWith>
  <ExportErrorMessage>String</ExportErrorMessage>
  <ExportErrorMessageBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportErrorMessageBetween>
  <ExportErrorMessageContains>String</ExportErrorMessageContains>
  <ExportErrorMessageEndsWith>String</ExportErrorMessageEndsWith>
  <ExportErrorMessageIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportErrorMessageIn>
  <ExportErrorMessageLike>String</ExportErrorMessageLike>
  <ExportErrorMessageStartsWith>String</ExportErrorMessageStartsWith>
  <ExportQueueID>String</ExportQueueID>
  <ExportQueueIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportQueueIDBetween>
  <ExportQueueIDContains>String</ExportQueueIDContains>
  <ExportQueueIDEndsWith>String</ExportQueueIDEndsWith>
  <ExportQueueIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportQueueIDIn>
  <ExportQueueIDLike>String</ExportQueueIDLike>
  <ExportQueueIDStartsWith>String</ExportQueueIDStartsWith>
  <ItemNo>String</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ItemNoBetween>
  <ItemNoContains>String</ItemNoContains>
  <ItemNoEndsWith>String</ItemNoEndsWith>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ItemNoIn>
  <ItemNoLike>String</ItemNoLike>
  <ItemNoStartsWith>String</ItemNoStartsWith>
  <LastSavedByStaffID>String</LastSavedByStaffID>
  <LastSavedByStaffIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LastSavedByStaffIDBetween>
  <LastSavedByStaffIDContains>String</LastSavedByStaffIDContains>
  <LastSavedByStaffIDEndsWith>String</LastSavedByStaffIDEndsWith>
  <LastSavedByStaffIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LastSavedByStaffIDIn>
  <LastSavedByStaffIDLike>String</LastSavedByStaffIDLike>
  <LastSavedByStaffIDStartsWith>String</LastSavedByStaffIDStartsWith>
  <LastSavedDateTime>0001-01-01T00:00:00</LastSavedDateTime>
  <LastSavedDateTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <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.datacontract.org/2004/07/System">
    <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>
  <Status>0</Status>
  <StatusBetween>AA==</StatusBetween>
  <StatusGreaterThan>0</StatusGreaterThan>
  <StatusGreaterThanOrEqualTo>0</StatusGreaterThanOrEqualTo>
  <StatusIn>AA==</StatusIn>
  <StatusLessThan>0</StatusLessThan>
  <StatusLessThanOrEqualTo>0</StatusLessThanOrEqualTo>
  <StatusNotEqualTo>0</StatusNotEqualTo>
</EX_ExportQueueQuery>

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

<QueryResponseOfEX_ExportQueue7kRqkrSv 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:EX_ExportQueue>
      <d2p1:_x003C_AddedToQueueByStaffID_x003E_k__BackingField>String</d2p1:_x003C_AddedToQueueByStaffID_x003E_k__BackingField>
      <d2p1:_x003C_AddedToQueueDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_AddedToQueueDateTime_x003E_k__BackingField>
      <d2p1:_x003C_BatchNo_x003E_k__BackingField>String</d2p1:_x003C_BatchNo_x003E_k__BackingField>
      <d2p1:_x003C_ExportBatchID_x003E_k__BackingField>String</d2p1:_x003C_ExportBatchID_x003E_k__BackingField>
      <d2p1:_x003C_ExportData_x003E_k__BackingField>String</d2p1:_x003C_ExportData_x003E_k__BackingField>
      <d2p1:_x003C_ExportErrorMessage_x003E_k__BackingField>String</d2p1:_x003C_ExportErrorMessage_x003E_k__BackingField>
      <d2p1:_x003C_ExportQueueID_x003E_k__BackingField>String</d2p1:_x003C_ExportQueueID_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>String</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedByStaffID_x003E_k__BackingField>String</d2p1:_x003C_LastSavedByStaffID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_Status_x003E_k__BackingField>0</d2p1:_x003C_Status_x003E_k__BackingField>
    </d2p1:EX_ExportQueue>
  </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>
</QueryResponseOfEX_ExportQueue7kRqkrSv>