JiwaAPI

SY_SysValuesLogQuery

**SY_SysValuesLogQuery** 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
BatchID	query	string	No
BatchIDStartsWith	query	string	No
BatchIDEndsWith	query	string	No
BatchIDContains	query	string	No
BatchIDLike	query	string	No
BatchIDBetween	query	string[]	No
BatchIDIn	query	string[]	No
DatabaseVersion	query	string	No
DatabaseVersionStartsWith	query	string	No
DatabaseVersionEndsWith	query	string	No
DatabaseVersionContains	query	string	No
DatabaseVersionLike	query	string	No
DatabaseVersionBetween	query	string[]	No
DatabaseVersionIn	query	string[]	No
Section	query	string	No
SectionStartsWith	query	string	No
SectionEndsWith	query	string	No
SectionContains	query	string	No
SectionLike	query	string	No
SectionBetween	query	string[]	No
SectionIn	query	string[]	No
SectionCaption	query	string	No
SectionCaptionStartsWith	query	string	No
SectionCaptionEndsWith	query	string	No
SectionCaptionContains	query	string	No
SectionCaptionLike	query	string	No
SectionCaptionBetween	query	string[]	No
SectionCaptionIn	query	string[]	No
IDKey	query	string	No
IDKeyStartsWith	query	string	No
IDKeyEndsWith	query	string	No
IDKeyContains	query	string	No
IDKeyLike	query	string	No
IDKeyBetween	query	string[]	No
IDKeyIn	query	string[]	No
Contents	query	string	No
ContentsStartsWith	query	string	No
ContentsEndsWith	query	string	No
ContentsContains	query	string	No
ContentsLike	query	string	No
ContentsBetween	query	string[]	No
ContentsIn	query	string[]	No
NewContents	query	string	No
NewContentsStartsWith	query	string	No
NewContentsEndsWith	query	string	No
NewContentsContains	query	string	No
NewContentsLike	query	string	No
NewContentsBetween	query	string[]	No
NewContentsIn	query	string[]	No
Description	query	string	No
DescriptionStartsWith	query	string	No
DescriptionEndsWith	query	string	No
DescriptionContains	query	string	No
DescriptionLike	query	string	No
DescriptionBetween	query	string[]	No
DescriptionIn	query	string[]	No
CellType	query	short?	No
CellTypeGreaterThanOrEqualTo	query	short?	No
CellTypeGreaterThan	query	short?	No
CellTypeLessThan	query	short?	No
CellTypeLessThanOrEqualTo	query	short?	No
CellTypeNotEqualTo	query	short?	No
CellTypeBetween	query	short[]	No
CellTypeIn	query	short[]	No
LastModifiedByStaffID	query	string	No
LastModifiedByStaffIDStartsWith	query	string	No
LastModifiedByStaffIDEndsWith	query	string	No
LastModifiedByStaffIDContains	query	string	No
LastModifiedByStaffIDLike	query	string	No
LastModifiedByStaffIDBetween	query	string[]	No
LastModifiedByStaffIDIn	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

**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

**SY_SysValuesLog** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
BatchID	form	string	No
DatabaseVersion	form	string	No
Section	form	string	No
SectionCaption	form	string	No
IDKey	form	string	No
Contents	form	string	No
NewContents	form	string	No
Description	form	string	No
CellType	form	short	No
LastModifiedByStaffID	form	string	No
LastSavedDateTime	form	DateTime	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/SY_SysValuesLogQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SY_SysValuesLogQuery 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>
  <BatchID>String</BatchID>
  <BatchIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BatchIDBetween>
  <BatchIDContains>String</BatchIDContains>
  <BatchIDEndsWith>String</BatchIDEndsWith>
  <BatchIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BatchIDIn>
  <BatchIDLike>String</BatchIDLike>
  <BatchIDStartsWith>String</BatchIDStartsWith>
  <CellType>0</CellType>
  <CellTypeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </CellTypeBetween>
  <CellTypeGreaterThan>0</CellTypeGreaterThan>
  <CellTypeGreaterThanOrEqualTo>0</CellTypeGreaterThanOrEqualTo>
  <CellTypeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </CellTypeIn>
  <CellTypeLessThan>0</CellTypeLessThan>
  <CellTypeLessThanOrEqualTo>0</CellTypeLessThanOrEqualTo>
  <CellTypeNotEqualTo>0</CellTypeNotEqualTo>
  <Contents>String</Contents>
  <ContentsBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ContentsBetween>
  <ContentsContains>String</ContentsContains>
  <ContentsEndsWith>String</ContentsEndsWith>
  <ContentsIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ContentsIn>
  <ContentsLike>String</ContentsLike>
  <ContentsStartsWith>String</ContentsStartsWith>
  <DatabaseVersion>String</DatabaseVersion>
  <DatabaseVersionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DatabaseVersionBetween>
  <DatabaseVersionContains>String</DatabaseVersionContains>
  <DatabaseVersionEndsWith>String</DatabaseVersionEndsWith>
  <DatabaseVersionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DatabaseVersionIn>
  <DatabaseVersionLike>String</DatabaseVersionLike>
  <DatabaseVersionStartsWith>String</DatabaseVersionStartsWith>
  <Description>String</Description>
  <DescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionBetween>
  <DescriptionContains>String</DescriptionContains>
  <DescriptionEndsWith>String</DescriptionEndsWith>
  <DescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionIn>
  <DescriptionLike>String</DescriptionLike>
  <DescriptionStartsWith>String</DescriptionStartsWith>
  <IDKey>String</IDKey>
  <IDKeyBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IDKeyBetween>
  <IDKeyContains>String</IDKeyContains>
  <IDKeyEndsWith>String</IDKeyEndsWith>
  <IDKeyIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IDKeyIn>
  <IDKeyLike>String</IDKeyLike>
  <IDKeyStartsWith>String</IDKeyStartsWith>
  <LastModifiedByStaffID>String</LastModifiedByStaffID>
  <LastModifiedByStaffIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LastModifiedByStaffIDBetween>
  <LastModifiedByStaffIDContains>String</LastModifiedByStaffIDContains>
  <LastModifiedByStaffIDEndsWith>String</LastModifiedByStaffIDEndsWith>
  <LastModifiedByStaffIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LastModifiedByStaffIDIn>
  <LastModifiedByStaffIDLike>String</LastModifiedByStaffIDLike>
  <LastModifiedByStaffIDStartsWith>String</LastModifiedByStaffIDStartsWith>
  <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>
  <NewContents>String</NewContents>
  <NewContentsBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NewContentsBetween>
  <NewContentsContains>String</NewContentsContains>
  <NewContentsEndsWith>String</NewContentsEndsWith>
  <NewContentsIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NewContentsIn>
  <NewContentsLike>String</NewContentsLike>
  <NewContentsStartsWith>String</NewContentsStartsWith>
  <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>
  <Section>String</Section>
  <SectionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SectionBetween>
  <SectionCaption>String</SectionCaption>
  <SectionCaptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SectionCaptionBetween>
  <SectionCaptionContains>String</SectionCaptionContains>
  <SectionCaptionEndsWith>String</SectionCaptionEndsWith>
  <SectionCaptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SectionCaptionIn>
  <SectionCaptionLike>String</SectionCaptionLike>
  <SectionCaptionStartsWith>String</SectionCaptionStartsWith>
  <SectionContains>String</SectionContains>
  <SectionEndsWith>String</SectionEndsWith>
  <SectionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SectionIn>
  <SectionLike>String</SectionLike>
  <SectionStartsWith>String</SectionStartsWith>
</SY_SysValuesLogQuery>

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

<QueryResponseOfSY_SysValuesLog7kRqkrSv 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:SY_SysValuesLog>
      <d2p1:_x003C_BatchID_x003E_k__BackingField>String</d2p1:_x003C_BatchID_x003E_k__BackingField>
      <d2p1:_x003C_CellType_x003E_k__BackingField>0</d2p1:_x003C_CellType_x003E_k__BackingField>
      <d2p1:_x003C_Contents_x003E_k__BackingField>String</d2p1:_x003C_Contents_x003E_k__BackingField>
      <d2p1:_x003C_DatabaseVersion_x003E_k__BackingField>String</d2p1:_x003C_DatabaseVersion_x003E_k__BackingField>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_IDKey_x003E_k__BackingField>String</d2p1:_x003C_IDKey_x003E_k__BackingField>
      <d2p1:_x003C_LastModifiedByStaffID_x003E_k__BackingField>String</d2p1:_x003C_LastModifiedByStaffID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_NewContents_x003E_k__BackingField>String</d2p1:_x003C_NewContents_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SectionCaption_x003E_k__BackingField>String</d2p1:_x003C_SectionCaption_x003E_k__BackingField>
      <d2p1:_x003C_Section_x003E_k__BackingField>String</d2p1:_x003C_Section_x003E_k__BackingField>
    </d2p1:SY_SysValuesLog>
  </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>
</QueryResponseOfSY_SysValuesLog7kRqkrSv>