JiwaAPI

SM_JobsQuery

**SM_JobsQuery** 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
JobNo	query	string	No
JobNoStartsWith	query	string	No
JobNoEndsWith	query	string	No
JobNoContains	query	string	No
JobNoLike	query	string	No
JobNoBetween	query	string[]	No
JobNoIn	query	string[]	No
DB_Main_RecID	query	string	No
DB_Main_RecIDStartsWith	query	string	No
DB_Main_RecIDEndsWith	query	string	No
DB_Main_RecIDContains	query	string	No
DB_Main_RecIDLike	query	string	No
DB_Main_RecIDBetween	query	string[]	No
DB_Main_RecIDIn	query	string[]	No
CN_Contact_RecID	query	string	No
CN_Contact_RecIDStartsWith	query	string	No
CN_Contact_RecIDEndsWith	query	string	No
CN_Contact_RecIDContains	query	string	No
CN_Contact_RecIDLike	query	string	No
CN_Contact_RecIDBetween	query	string[]	No
CN_Contact_RecIDIn	query	string[]	No
Reference	query	string	No
ReferenceStartsWith	query	string	No
ReferenceEndsWith	query	string	No
ReferenceContains	query	string	No
ReferenceLike	query	string	No
ReferenceBetween	query	string[]	No
ReferenceIn	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
Coordinator_HR_Staff_RecID	query	string	No
Coordinator_HR_Staff_RecIDStartsWith	query	string	No
Coordinator_HR_Staff_RecIDEndsWith	query	string	No
Coordinator_HR_Staff_RecIDContains	query	string	No
Coordinator_HR_Staff_RecIDLike	query	string	No
Coordinator_HR_Staff_RecIDBetween	query	string[]	No
Coordinator_HR_Staff_RecIDIn	query	string[]	No
DateLogged	query	DateTime?	No
DateLoggedGreaterThanOrEqualTo	query	DateTime?	No
DateLoggedGreaterThan	query	DateTime?	No
DateLoggedLessThan	query	DateTime?	No
DateLoggedLessThanOrEqualTo	query	DateTime?	No
DateLoggedNotEqualTo	query	DateTime?	No
DateLoggedBetween	query	DateTime[]	No
DateLoggedIn	query	DateTime[]	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
LastSaved_HR_Staff_RecID	query	string	No
LastSaved_HR_Staff_RecIDStartsWith	query	string	No
LastSaved_HR_Staff_RecIDEndsWith	query	string	No
LastSaved_HR_Staff_RecIDContains	query	string	No
LastSaved_HR_Staff_RecIDLike	query	string	No
LastSaved_HR_Staff_RecIDBetween	query	string[]	No
LastSaved_HR_Staff_RecIDIn	query	string[]	No
IN_PriceSchemes_RecID	query	string	No
IN_PriceSchemes_RecIDStartsWith	query	string	No
IN_PriceSchemes_RecIDEndsWith	query	string	No
IN_PriceSchemes_RecIDContains	query	string	No
IN_PriceSchemes_RecIDLike	query	string	No
IN_PriceSchemes_RecIDBetween	query	string[]	No
IN_PriceSchemes_RecIDIn	query	string[]	No
TaxExemptNo	query	string	No
TaxExemptNoStartsWith	query	string	No
TaxExemptNoEndsWith	query	string	No
TaxExemptNoContains	query	string	No
TaxExemptNoLike	query	string	No
TaxExemptNoBetween	query	string[]	No
TaxExemptNoIn	query	string[]	No
RowHash	query	byte[]	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	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

**SM_Jobs** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
JobNo	form	string	No
DB_Main_RecID	form	string	No
CN_Contact_RecID	form	string	No
Reference	form	string	No
Description	form	string	No
Coordinator_HR_Staff_RecID	form	string	No
DateLogged	form	DateTime	No
LastSavedDateTime	form	DateTime	No
LastSaved_HR_Staff_RecID	form	string	No
IN_PriceSchemes_RecID	form	string	No
TaxExemptNo	form	string	No
RowHash	form	byte[]	No
IN_LogicalID	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/SM_JobsQuery HTTP/1.1 
Host: localhost 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SM_JobsQuery 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>
  <CN_Contact_RecID>String</CN_Contact_RecID>
  <CN_Contact_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CN_Contact_RecIDBetween>
  <CN_Contact_RecIDContains>String</CN_Contact_RecIDContains>
  <CN_Contact_RecIDEndsWith>String</CN_Contact_RecIDEndsWith>
  <CN_Contact_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CN_Contact_RecIDIn>
  <CN_Contact_RecIDLike>String</CN_Contact_RecIDLike>
  <CN_Contact_RecIDStartsWith>String</CN_Contact_RecIDStartsWith>
  <Coordinator_HR_Staff_RecID>String</Coordinator_HR_Staff_RecID>
  <Coordinator_HR_Staff_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Coordinator_HR_Staff_RecIDBetween>
  <Coordinator_HR_Staff_RecIDContains>String</Coordinator_HR_Staff_RecIDContains>
  <Coordinator_HR_Staff_RecIDEndsWith>String</Coordinator_HR_Staff_RecIDEndsWith>
  <Coordinator_HR_Staff_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Coordinator_HR_Staff_RecIDIn>
  <Coordinator_HR_Staff_RecIDLike>String</Coordinator_HR_Staff_RecIDLike>
  <Coordinator_HR_Staff_RecIDStartsWith>String</Coordinator_HR_Staff_RecIDStartsWith>
  <DB_Main_RecID>String</DB_Main_RecID>
  <DB_Main_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DB_Main_RecIDBetween>
  <DB_Main_RecIDContains>String</DB_Main_RecIDContains>
  <DB_Main_RecIDEndsWith>String</DB_Main_RecIDEndsWith>
  <DB_Main_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DB_Main_RecIDIn>
  <DB_Main_RecIDLike>String</DB_Main_RecIDLike>
  <DB_Main_RecIDStartsWith>String</DB_Main_RecIDStartsWith>
  <DateLogged>0001-01-01T00:00:00</DateLogged>
  <DateLoggedBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </DateLoggedBetween>
  <DateLoggedGreaterThan>0001-01-01T00:00:00</DateLoggedGreaterThan>
  <DateLoggedGreaterThanOrEqualTo>0001-01-01T00:00:00</DateLoggedGreaterThanOrEqualTo>
  <DateLoggedIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </DateLoggedIn>
  <DateLoggedLessThan>0001-01-01T00:00:00</DateLoggedLessThan>
  <DateLoggedLessThanOrEqualTo>0001-01-01T00:00:00</DateLoggedLessThanOrEqualTo>
  <DateLoggedNotEqualTo>0001-01-01T00:00:00</DateLoggedNotEqualTo>
  <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>
  <IN_LogicalID>String</IN_LogicalID>
  <IN_LogicalIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_LogicalIDBetween>
  <IN_LogicalIDContains>String</IN_LogicalIDContains>
  <IN_LogicalIDEndsWith>String</IN_LogicalIDEndsWith>
  <IN_LogicalIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_LogicalIDIn>
  <IN_LogicalIDLike>String</IN_LogicalIDLike>
  <IN_LogicalIDStartsWith>String</IN_LogicalIDStartsWith>
  <IN_PriceSchemes_RecID>String</IN_PriceSchemes_RecID>
  <IN_PriceSchemes_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_PriceSchemes_RecIDBetween>
  <IN_PriceSchemes_RecIDContains>String</IN_PriceSchemes_RecIDContains>
  <IN_PriceSchemes_RecIDEndsWith>String</IN_PriceSchemes_RecIDEndsWith>
  <IN_PriceSchemes_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_PriceSchemes_RecIDIn>
  <IN_PriceSchemes_RecIDLike>String</IN_PriceSchemes_RecIDLike>
  <IN_PriceSchemes_RecIDStartsWith>String</IN_PriceSchemes_RecIDStartsWith>
  <JobNo>String</JobNo>
  <JobNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobNoBetween>
  <JobNoContains>String</JobNoContains>
  <JobNoEndsWith>String</JobNoEndsWith>
  <JobNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobNoIn>
  <JobNoLike>String</JobNoLike>
  <JobNoStartsWith>String</JobNoStartsWith>
  <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>
  <LastSaved_HR_Staff_RecID>String</LastSaved_HR_Staff_RecID>
  <LastSaved_HR_Staff_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LastSaved_HR_Staff_RecIDBetween>
  <LastSaved_HR_Staff_RecIDContains>String</LastSaved_HR_Staff_RecIDContains>
  <LastSaved_HR_Staff_RecIDEndsWith>String</LastSaved_HR_Staff_RecIDEndsWith>
  <LastSaved_HR_Staff_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LastSaved_HR_Staff_RecIDIn>
  <LastSaved_HR_Staff_RecIDLike>String</LastSaved_HR_Staff_RecIDLike>
  <LastSaved_HR_Staff_RecIDStartsWith>String</LastSaved_HR_Staff_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>
  <Reference>String</Reference>
  <ReferenceBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReferenceBetween>
  <ReferenceContains>String</ReferenceContains>
  <ReferenceEndsWith>String</ReferenceEndsWith>
  <ReferenceIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReferenceIn>
  <ReferenceLike>String</ReferenceLike>
  <ReferenceStartsWith>String</ReferenceStartsWith>
  <RowHash>AA==</RowHash>
  <TaxExemptNo>String</TaxExemptNo>
  <TaxExemptNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TaxExemptNoBetween>
  <TaxExemptNoContains>String</TaxExemptNoContains>
  <TaxExemptNoEndsWith>String</TaxExemptNoEndsWith>
  <TaxExemptNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </TaxExemptNoIn>
  <TaxExemptNoLike>String</TaxExemptNoLike>
  <TaxExemptNoStartsWith>String</TaxExemptNoStartsWith>
</SM_JobsQuery>

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

<QueryResponseOfSM_Jobs7kRqkrSv 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:SM_Jobs>
      <d2p1:_x003C_CN_Contact_RecID_x003E_k__BackingField>String</d2p1:_x003C_CN_Contact_RecID_x003E_k__BackingField>
      <d2p1:_x003C_Coordinator_HR_Staff_RecID_x003E_k__BackingField>String</d2p1:_x003C_Coordinator_HR_Staff_RecID_x003E_k__BackingField>
      <d2p1:_x003C_DB_Main_RecID_x003E_k__BackingField>String</d2p1:_x003C_DB_Main_RecID_x003E_k__BackingField>
      <d2p1:_x003C_DateLogged_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_DateLogged_x003E_k__BackingField>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>String</d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>
      <d2p1:_x003C_IN_PriceSchemes_RecID_x003E_k__BackingField>String</d2p1:_x003C_IN_PriceSchemes_RecID_x003E_k__BackingField>
      <d2p1:_x003C_JobNo_x003E_k__BackingField>String</d2p1:_x003C_JobNo_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LastSaved_HR_Staff_RecID_x003E_k__BackingField>String</d2p1:_x003C_LastSaved_HR_Staff_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_Reference_x003E_k__BackingField>String</d2p1:_x003C_Reference_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_TaxExemptNo_x003E_k__BackingField>String</d2p1:_x003C_TaxExemptNo_x003E_k__BackingField>
    </d2p1:SM_Jobs>
  </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>
</QueryResponseOfSM_Jobs7kRqkrSv>