JiwaAPI

<back to all web services

v_JIWA_JobCosting_EstimatesAndActualsQuery

Requires Authentication
v_JIWA_JobCosting_EstimatesAndActualsQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
EstimateNoquerystringNo
EstimateNoStartsWithquerystringNo
EstimateNoEndsWithquerystringNo
EstimateNoContainsquerystringNo
EstimateNoLikequerystringNo
EstimateNoBetweenquerystring[]No
EstimateNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
JB_Main_RecIDquerystringNo
JB_Main_RecIDStartsWithquerystringNo
JB_Main_RecIDEndsWithquerystringNo
JB_Main_RecIDContainsquerystringNo
JB_Main_RecIDLikequerystringNo
JB_Main_RecIDBetweenquerystring[]No
JB_Main_RecIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
HR_Staff_RecIDquerystringNo
HR_Staff_RecIDStartsWithquerystringNo
HR_Staff_RecIDEndsWithquerystringNo
HR_Staff_RecIDContainsquerystringNo
HR_Staff_RecIDLikequerystringNo
HR_Staff_RecIDBetweenquerystring[]No
HR_Staff_RecIDInquerystring[]No
IN_Logical_RecIDquerystringNo
IN_Logical_RecIDStartsWithquerystringNo
IN_Logical_RecIDEndsWithquerystringNo
IN_Logical_RecIDContainsquerystringNo
IN_Logical_RecIDLikequerystringNo
IN_Logical_RecIDBetweenquerystring[]No
IN_Logical_RecIDInquerystring[]No
IsDefaultqueryint?No
IsDefaultGreaterThanOrEqualToqueryint?No
IsDefaultGreaterThanqueryint?No
IsDefaultLessThanqueryint?No
IsDefaultLessThanOrEqualToqueryint?No
IsDefaultNotEqualToqueryint?No
IsDefaultBetweenqueryint[]No
IsDefaultInqueryint[]No
Statusqueryint?No
StatusGreaterThanOrEqualToqueryint?No
StatusGreaterThanqueryint?No
StatusLessThanqueryint?No
StatusLessThanOrEqualToqueryint?No
StatusNotEqualToqueryint?No
StatusBetweenqueryNullable<Int32>[]No
StatusInqueryNullable<Int32>[]No
IsEstimatequeryint?No
IsEstimateGreaterThanOrEqualToqueryint?No
IsEstimateGreaterThanqueryint?No
IsEstimateLessThanqueryint?No
IsEstimateLessThanOrEqualToqueryint?No
IsEstimateNotEqualToqueryint?No
IsEstimateBetweenqueryint[]No
IsEstimateInqueryint[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
v_JIWA_JobCosting_EstimatesAndActuals Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
EstimateNoformstringNo
DescriptionformstringNo
JB_Main_RecIDformstringNo
LastSavedDateTimeformDateTimeNo
HR_Staff_RecIDformstringNo
IN_Logical_RecIDformstringNo
IsDefaultformintNo
Statusformint?No
IsEstimateformintNo
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_JIWA_JobCosting_EstimatesAndActualsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_JIWA_JobCosting_EstimatesAndActualsQuery 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>
  <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>
  <EstimateNo>String</EstimateNo>
  <EstimateNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EstimateNoBetween>
  <EstimateNoContains>String</EstimateNoContains>
  <EstimateNoEndsWith>String</EstimateNoEndsWith>
  <EstimateNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EstimateNoIn>
  <EstimateNoLike>String</EstimateNoLike>
  <EstimateNoStartsWith>String</EstimateNoStartsWith>
  <HR_Staff_RecID>String</HR_Staff_RecID>
  <HR_Staff_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDBetween>
  <HR_Staff_RecIDContains>String</HR_Staff_RecIDContains>
  <HR_Staff_RecIDEndsWith>String</HR_Staff_RecIDEndsWith>
  <HR_Staff_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDIn>
  <HR_Staff_RecIDLike>String</HR_Staff_RecIDLike>
  <HR_Staff_RecIDStartsWith>String</HR_Staff_RecIDStartsWith>
  <IN_Logical_RecID>String</IN_Logical_RecID>
  <IN_Logical_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_Logical_RecIDBetween>
  <IN_Logical_RecIDContains>String</IN_Logical_RecIDContains>
  <IN_Logical_RecIDEndsWith>String</IN_Logical_RecIDEndsWith>
  <IN_Logical_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_Logical_RecIDIn>
  <IN_Logical_RecIDLike>String</IN_Logical_RecIDLike>
  <IN_Logical_RecIDStartsWith>String</IN_Logical_RecIDStartsWith>
  <IsDefault>0</IsDefault>
  <IsDefaultBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </IsDefaultBetween>
  <IsDefaultGreaterThan>0</IsDefaultGreaterThan>
  <IsDefaultGreaterThanOrEqualTo>0</IsDefaultGreaterThanOrEqualTo>
  <IsDefaultIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </IsDefaultIn>
  <IsDefaultLessThan>0</IsDefaultLessThan>
  <IsDefaultLessThanOrEqualTo>0</IsDefaultLessThanOrEqualTo>
  <IsDefaultNotEqualTo>0</IsDefaultNotEqualTo>
  <IsEstimate>0</IsEstimate>
  <IsEstimateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </IsEstimateBetween>
  <IsEstimateGreaterThan>0</IsEstimateGreaterThan>
  <IsEstimateGreaterThanOrEqualTo>0</IsEstimateGreaterThanOrEqualTo>
  <IsEstimateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </IsEstimateIn>
  <IsEstimateLessThan>0</IsEstimateLessThan>
  <IsEstimateLessThanOrEqualTo>0</IsEstimateLessThanOrEqualTo>
  <IsEstimateNotEqualTo>0</IsEstimateNotEqualTo>
  <JB_Main_RecID>String</JB_Main_RecID>
  <JB_Main_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_Main_RecIDBetween>
  <JB_Main_RecIDContains>String</JB_Main_RecIDContains>
  <JB_Main_RecIDEndsWith>String</JB_Main_RecIDEndsWith>
  <JB_Main_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_Main_RecIDIn>
  <JB_Main_RecIDLike>String</JB_Main_RecIDLike>
  <JB_Main_RecIDStartsWith>String</JB_Main_RecIDStartsWith>
  <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 xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </StatusBetween>
  <StatusGreaterThan>0</StatusGreaterThan>
  <StatusGreaterThanOrEqualTo>0</StatusGreaterThanOrEqualTo>
  <StatusIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </StatusIn>
  <StatusLessThan>0</StatusLessThan>
  <StatusLessThanOrEqualTo>0</StatusLessThanOrEqualTo>
  <StatusNotEqualTo>0</StatusNotEqualTo>
</v_JIWA_JobCosting_EstimatesAndActualsQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfv_JIWA_JobCosting_EstimatesAndActuals7kRqkrSv 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_JIWA_JobCosting_EstimatesAndActuals>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_EstimateNo_x003E_k__BackingField>String</d2p1:_x003C_EstimateNo_x003E_k__BackingField>
      <d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>String</d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>
      <d2p1:_x003C_IN_Logical_RecID_x003E_k__BackingField>String</d2p1:_x003C_IN_Logical_RecID_x003E_k__BackingField>
      <d2p1:_x003C_IsDefault_x003E_k__BackingField>0</d2p1:_x003C_IsDefault_x003E_k__BackingField>
      <d2p1:_x003C_IsEstimate_x003E_k__BackingField>0</d2p1:_x003C_IsEstimate_x003E_k__BackingField>
      <d2p1:_x003C_JB_Main_RecID_x003E_k__BackingField>String</d2p1:_x003C_JB_Main_RecID_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:v_JIWA_JobCosting_EstimatesAndActuals>
  </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_JIWA_JobCosting_EstimatesAndActuals7kRqkrSv>