JiwaAPI

<back to all web services

v_JobsWithActiveTaskQuery

Requires Authentication
v_JobsWithActiveTaskQuery Parameters:
NameParameterData TypeRequiredDescription
JobIDquerystringNo
JobIDStartsWithquerystringNo
JobIDEndsWithquerystringNo
JobIDContainsquerystringNo
JobIDLikequerystringNo
JobIDBetweenquerystring[]No
JobIDInquerystring[]No
JobNoquerystringNo
JobNoStartsWithquerystringNo
JobNoEndsWithquerystringNo
JobNoContainsquerystringNo
JobNoLikequerystringNo
JobNoBetweenquerystring[]No
JobNoInquerystring[]No
DB_Main_RecIDquerystringNo
DB_Main_RecIDStartsWithquerystringNo
DB_Main_RecIDEndsWithquerystringNo
DB_Main_RecIDContainsquerystringNo
DB_Main_RecIDLikequerystringNo
DB_Main_RecIDBetweenquerystring[]No
DB_Main_RecIDInquerystring[]No
AccountNoquerystringNo
AccountNoStartsWithquerystringNo
AccountNoEndsWithquerystringNo
AccountNoContainsquerystringNo
AccountNoLikequerystringNo
AccountNoBetweenquerystring[]No
AccountNoInquerystring[]No
NamequerystringNo
NameStartsWithquerystringNo
NameEndsWithquerystringNo
NameContainsquerystringNo
NameLikequerystringNo
NameBetweenquerystring[]No
NameInquerystring[]No
JobDescriptionquerystringNo
JobDescriptionStartsWithquerystringNo
JobDescriptionEndsWithquerystringNo
JobDescriptionContainsquerystringNo
JobDescriptionLikequerystringNo
JobDescriptionBetweenquerystring[]No
JobDescriptionInquerystring[]No
CoordinatorNamequerystringNo
CoordinatorNameStartsWithquerystringNo
CoordinatorNameEndsWithquerystringNo
CoordinatorNameContainsquerystringNo
CoordinatorNameLikequerystringNo
CoordinatorNameBetweenquerystring[]No
CoordinatorNameInquerystring[]No
JobDateLoggedqueryDateTime?No
JobDateLoggedGreaterThanOrEqualToqueryDateTime?No
JobDateLoggedGreaterThanqueryDateTime?No
JobDateLoggedLessThanqueryDateTime?No
JobDateLoggedLessThanOrEqualToqueryDateTime?No
JobDateLoggedNotEqualToqueryDateTime?No
JobDateLoggedBetweenqueryNullable<DateTime>[]No
JobDateLoggedInqueryNullable<DateTime>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
v_JobsWithActiveTask Parameters:
NameParameterData TypeRequiredDescription
JobIDformstringNo
JobNoformstringNo
DB_Main_RecIDformstringNo
AccountNoformstringNo
NameformstringNo
JobDescriptionformstringNo
CoordinatorNameformstringNo
JobDateLoggedformDateTime?No
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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/v_JobsWithActiveTaskQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_JobsWithActiveTaskQuery 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>
  <AccountNo>String</AccountNo>
  <AccountNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountNoBetween>
  <AccountNoContains>String</AccountNoContains>
  <AccountNoEndsWith>String</AccountNoEndsWith>
  <AccountNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AccountNoIn>
  <AccountNoLike>String</AccountNoLike>
  <AccountNoStartsWith>String</AccountNoStartsWith>
  <CoordinatorName>String</CoordinatorName>
  <CoordinatorNameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CoordinatorNameBetween>
  <CoordinatorNameContains>String</CoordinatorNameContains>
  <CoordinatorNameEndsWith>String</CoordinatorNameEndsWith>
  <CoordinatorNameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CoordinatorNameIn>
  <CoordinatorNameLike>String</CoordinatorNameLike>
  <CoordinatorNameStartsWith>String</CoordinatorNameStartsWith>
  <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>
  <JobDateLogged>0001-01-01T00:00:00</JobDateLogged>
  <JobDateLoggedBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </JobDateLoggedBetween>
  <JobDateLoggedGreaterThan>0001-01-01T00:00:00</JobDateLoggedGreaterThan>
  <JobDateLoggedGreaterThanOrEqualTo>0001-01-01T00:00:00</JobDateLoggedGreaterThanOrEqualTo>
  <JobDateLoggedIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </JobDateLoggedIn>
  <JobDateLoggedLessThan>0001-01-01T00:00:00</JobDateLoggedLessThan>
  <JobDateLoggedLessThanOrEqualTo>0001-01-01T00:00:00</JobDateLoggedLessThanOrEqualTo>
  <JobDateLoggedNotEqualTo>0001-01-01T00:00:00</JobDateLoggedNotEqualTo>
  <JobDescription>String</JobDescription>
  <JobDescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobDescriptionBetween>
  <JobDescriptionContains>String</JobDescriptionContains>
  <JobDescriptionEndsWith>String</JobDescriptionEndsWith>
  <JobDescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobDescriptionIn>
  <JobDescriptionLike>String</JobDescriptionLike>
  <JobDescriptionStartsWith>String</JobDescriptionStartsWith>
  <JobID>String</JobID>
  <JobIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobIDBetween>
  <JobIDContains>String</JobIDContains>
  <JobIDEndsWith>String</JobIDEndsWith>
  <JobIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JobIDIn>
  <JobIDLike>String</JobIDLike>
  <JobIDStartsWith>String</JobIDStartsWith>
  <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>
  <Name>String</Name>
  <NameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameBetween>
  <NameContains>String</NameContains>
  <NameEndsWith>String</NameEndsWith>
  <NameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameIn>
  <NameLike>String</NameLike>
  <NameStartsWith>String</NameStartsWith>
</v_JobsWithActiveTaskQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfv_JobsWithActiveTask7kRqkrSv 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:v_JobsWithActiveTask>
      <d2p1:_x003C_AccountNo_x003E_k__BackingField>String</d2p1:_x003C_AccountNo_x003E_k__BackingField>
      <d2p1:_x003C_CoordinatorName_x003E_k__BackingField>String</d2p1:_x003C_CoordinatorName_x003E_k__BackingField>
      <d2p1:_x003C_DB_Main_RecID_x003E_k__BackingField>String</d2p1:_x003C_DB_Main_RecID_x003E_k__BackingField>
      <d2p1:_x003C_JobDateLogged_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_JobDateLogged_x003E_k__BackingField>
      <d2p1:_x003C_JobDescription_x003E_k__BackingField>String</d2p1:_x003C_JobDescription_x003E_k__BackingField>
      <d2p1:_x003C_JobID_x003E_k__BackingField>String</d2p1:_x003C_JobID_x003E_k__BackingField>
      <d2p1:_x003C_JobNo_x003E_k__BackingField>String</d2p1:_x003C_JobNo_x003E_k__BackingField>
      <d2p1:_x003C_Name_x003E_k__BackingField>String</d2p1:_x003C_Name_x003E_k__BackingField>
    </d2p1:v_JobsWithActiveTask>
  </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>
</QueryResponseOfv_JobsWithActiveTask7kRqkrSv>