JiwaAPI

SO_ExportMainQuery

**SO_ExportMainQuery** 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
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
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
DateCreated	query	DateTime?	No
DateCreatedGreaterThanOrEqualTo	query	DateTime?	No
DateCreatedGreaterThan	query	DateTime?	No
DateCreatedLessThan	query	DateTime?	No
DateCreatedLessThanOrEqualTo	query	DateTime?	No
DateCreatedNotEqualTo	query	DateTime?	No
DateCreatedBetween	query	DateTime[]	No
DateCreatedIn	query	DateTime[]	No
DateActivated	query	DateTime?	No
DateActivatedGreaterThanOrEqualTo	query	DateTime?	No
DateActivatedGreaterThan	query	DateTime?	No
DateActivatedLessThan	query	DateTime?	No
DateActivatedLessThanOrEqualTo	query	DateTime?	No
DateActivatedNotEqualTo	query	DateTime?	No
DateActivatedBetween	query	DateTime[]	No
DateActivatedIn	query	DateTime[]	No
HR_Staff_StaffID	query	string	No
HR_Staff_StaffIDStartsWith	query	string	No
HR_Staff_StaffIDEndsWith	query	string	No
HR_Staff_StaffIDContains	query	string	No
HR_Staff_StaffIDLike	query	string	No
HR_Staff_StaffIDBetween	query	string[]	No
HR_Staff_StaffIDIn	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
ExportFileNameAndPath	query	string	No
ExportFileNameAndPathStartsWith	query	string	No
ExportFileNameAndPathEndsWith	query	string	No
ExportFileNameAndPathContains	query	string	No
ExportFileNameAndPathLike	query	string	No
ExportFileNameAndPathBetween	query	string[]	No
ExportFileNameAndPathIn	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

**SO_ExportMain** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
LastSavedDateTime	form	DateTime	No
BatchNo	form	string	No
DateCreated	form	DateTime	No
DateActivated	form	DateTime	No
HR_Staff_StaffID	form	string	No
Status	form	byte	No
ExportFileNameAndPath	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/SO_ExportMainQuery HTTP/1.1 
Host: localhost 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SO_ExportMainQuery 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>
  <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>
  <DateActivated>0001-01-01T00:00:00</DateActivated>
  <DateActivatedBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </DateActivatedBetween>
  <DateActivatedGreaterThan>0001-01-01T00:00:00</DateActivatedGreaterThan>
  <DateActivatedGreaterThanOrEqualTo>0001-01-01T00:00:00</DateActivatedGreaterThanOrEqualTo>
  <DateActivatedIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </DateActivatedIn>
  <DateActivatedLessThan>0001-01-01T00:00:00</DateActivatedLessThan>
  <DateActivatedLessThanOrEqualTo>0001-01-01T00:00:00</DateActivatedLessThanOrEqualTo>
  <DateActivatedNotEqualTo>0001-01-01T00:00:00</DateActivatedNotEqualTo>
  <DateCreated>0001-01-01T00:00:00</DateCreated>
  <DateCreatedBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </DateCreatedBetween>
  <DateCreatedGreaterThan>0001-01-01T00:00:00</DateCreatedGreaterThan>
  <DateCreatedGreaterThanOrEqualTo>0001-01-01T00:00:00</DateCreatedGreaterThanOrEqualTo>
  <DateCreatedIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </DateCreatedIn>
  <DateCreatedLessThan>0001-01-01T00:00:00</DateCreatedLessThan>
  <DateCreatedLessThanOrEqualTo>0001-01-01T00:00:00</DateCreatedLessThanOrEqualTo>
  <DateCreatedNotEqualTo>0001-01-01T00:00:00</DateCreatedNotEqualTo>
  <ExportFileNameAndPath>String</ExportFileNameAndPath>
  <ExportFileNameAndPathBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportFileNameAndPathBetween>
  <ExportFileNameAndPathContains>String</ExportFileNameAndPathContains>
  <ExportFileNameAndPathEndsWith>String</ExportFileNameAndPathEndsWith>
  <ExportFileNameAndPathIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ExportFileNameAndPathIn>
  <ExportFileNameAndPathLike>String</ExportFileNameAndPathLike>
  <ExportFileNameAndPathStartsWith>String</ExportFileNameAndPathStartsWith>
  <HR_Staff_StaffID>String</HR_Staff_StaffID>
  <HR_Staff_StaffIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_StaffIDBetween>
  <HR_Staff_StaffIDContains>String</HR_Staff_StaffIDContains>
  <HR_Staff_StaffIDEndsWith>String</HR_Staff_StaffIDEndsWith>
  <HR_Staff_StaffIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_StaffIDIn>
  <HR_Staff_StaffIDLike>String</HR_Staff_StaffIDLike>
  <HR_Staff_StaffIDStartsWith>String</HR_Staff_StaffIDStartsWith>
  <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>
  <Status>0</Status>
  <StatusBetween>AA==</StatusBetween>
  <StatusGreaterThan>0</StatusGreaterThan>
  <StatusGreaterThanOrEqualTo>0</StatusGreaterThanOrEqualTo>
  <StatusIn>AA==</StatusIn>
  <StatusLessThan>0</StatusLessThan>
  <StatusLessThanOrEqualTo>0</StatusLessThanOrEqualTo>
  <StatusNotEqualTo>0</StatusNotEqualTo>
</SO_ExportMainQuery>

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

<QueryResponseOfSO_ExportMain7kRqkrSv 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_ExportMain>
      <d2p1:_x003C_BatchNo_x003E_k__BackingField>String</d2p1:_x003C_BatchNo_x003E_k__BackingField>
      <d2p1:_x003C_DateActivated_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_DateActivated_x003E_k__BackingField>
      <d2p1:_x003C_DateCreated_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_DateCreated_x003E_k__BackingField>
      <d2p1:_x003C_ExportFileNameAndPath_x003E_k__BackingField>String</d2p1:_x003C_ExportFileNameAndPath_x003E_k__BackingField>
      <d2p1:_x003C_HR_Staff_StaffID_x003E_k__BackingField>String</d2p1:_x003C_HR_Staff_StaffID_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_Status_x003E_k__BackingField>0</d2p1:_x003C_Status_x003E_k__BackingField>
    </d2p1:SO_ExportMain>
  </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_ExportMain7kRqkrSv>