JiwaAPI

v_PrepaidLabourPacksHoursUsedQuery

**v_PrepaidLabourPacksHoursUsedQuery** Parameters:
Name	Parameter	Data Type	Required
SM_PrepaidLabourPacks_RecID	query	string	No
SM_PrepaidLabourPacks_RecIDStartsWith	query	string	No
SM_PrepaidLabourPacks_RecIDEndsWith	query	string	No
SM_PrepaidLabourPacks_RecIDContains	query	string	No
SM_PrepaidLabourPacks_RecIDLike	query	string	No
SM_PrepaidLabourPacks_RecIDBetween	query	string[]	No
SM_PrepaidLabourPacks_RecIDIn	query	string[]	No
HoursUsed	query	decimal?	No
HoursUsedGreaterThanOrEqualTo	query	decimal?	No
HoursUsedGreaterThan	query	decimal?	No
HoursUsedLessThan	query	decimal?	No
HoursUsedLessThanOrEqualTo	query	decimal?	No
HoursUsedNotEqualTo	query	decimal?	No
HoursUsedBetween	query	Nullable<Decimal>[]	No
HoursUsedIn	query	Nullable<Decimal>[]	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

**v_PrepaidLabourPacksHoursUsed** Parameters:
Name	Parameter	Data Type	Required	Description
SM_PrepaidLabourPacks_RecID	form	string	No
HoursUsed	form	decimal?	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/v_PrepaidLabourPacksHoursUsedQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_PrepaidLabourPacksHoursUsedQuery 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>
  <HoursUsed>0</HoursUsed>
  <HoursUsedBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </HoursUsedBetween>
  <HoursUsedGreaterThan>0</HoursUsedGreaterThan>
  <HoursUsedGreaterThanOrEqualTo>0</HoursUsedGreaterThanOrEqualTo>
  <HoursUsedIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </HoursUsedIn>
  <HoursUsedLessThan>0</HoursUsedLessThan>
  <HoursUsedLessThanOrEqualTo>0</HoursUsedLessThanOrEqualTo>
  <HoursUsedNotEqualTo>0</HoursUsedNotEqualTo>
  <SM_PrepaidLabourPacks_RecID>String</SM_PrepaidLabourPacks_RecID>
  <SM_PrepaidLabourPacks_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_PrepaidLabourPacks_RecIDBetween>
  <SM_PrepaidLabourPacks_RecIDContains>String</SM_PrepaidLabourPacks_RecIDContains>
  <SM_PrepaidLabourPacks_RecIDEndsWith>String</SM_PrepaidLabourPacks_RecIDEndsWith>
  <SM_PrepaidLabourPacks_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_PrepaidLabourPacks_RecIDIn>
  <SM_PrepaidLabourPacks_RecIDLike>String</SM_PrepaidLabourPacks_RecIDLike>
  <SM_PrepaidLabourPacks_RecIDStartsWith>String</SM_PrepaidLabourPacks_RecIDStartsWith>
</v_PrepaidLabourPacksHoursUsedQuery>

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

<QueryResponseOfv_PrepaidLabourPacksHoursUsed7kRqkrSv 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_PrepaidLabourPacksHoursUsed>
      <d2p1:_x003C_HoursUsed_x003E_k__BackingField>0</d2p1:_x003C_HoursUsed_x003E_k__BackingField>
      <d2p1:_x003C_SM_PrepaidLabourPacks_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_PrepaidLabourPacks_RecID_x003E_k__BackingField>
    </d2p1:v_PrepaidLabourPacksHoursUsed>
  </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_PrepaidLabourPacksHoursUsed7kRqkrSv>