JiwaAPI

<back to all web services

v_JB_ResourcesTotalsToDateQuery

Requires Authentication
v_JB_ResourcesTotalsToDateQuery Parameters:
NameParameterData TypeRequiredDescription
Chargequerydecimal?No
ChargeGreaterThanOrEqualToquerydecimal?No
ChargeGreaterThanquerydecimal?No
ChargeLessThanquerydecimal?No
ChargeLessThanOrEqualToquerydecimal?No
ChargeNotEqualToquerydecimal?No
ChargeBetweenqueryNullable<Decimal>[]No
ChargeInqueryNullable<Decimal>[]No
Costquerydecimal?No
CostGreaterThanOrEqualToquerydecimal?No
CostGreaterThanquerydecimal?No
CostLessThanquerydecimal?No
CostLessThanOrEqualToquerydecimal?No
CostNotEqualToquerydecimal?No
CostBetweenqueryNullable<Decimal>[]No
CostInqueryNullable<Decimal>[]No
Qtyquerydecimal?No
QtyGreaterThanOrEqualToquerydecimal?No
QtyGreaterThanquerydecimal?No
QtyLessThanquerydecimal?No
QtyLessThanOrEqualToquerydecimal?No
QtyNotEqualToquerydecimal?No
QtyBetweenqueryNullable<Decimal>[]No
QtyInqueryNullable<Decimal>[]No
JobIDquerystringNo
JobIDStartsWithquerystringNo
JobIDEndsWithquerystringNo
JobIDContainsquerystringNo
JobIDLikequerystringNo
JobIDBetweenquerystring[]No
JobIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
v_JB_ResourcesTotalsToDate Parameters:
NameParameterData TypeRequiredDescription
Chargeformdecimal?No
Costformdecimal?No
Qtyformdecimal?No
JobIDformstringNo
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_JB_ResourcesTotalsToDateQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_JB_ResourcesTotalsToDateQuery 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>
  <Charge>0</Charge>
  <ChargeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </ChargeBetween>
  <ChargeGreaterThan>0</ChargeGreaterThan>
  <ChargeGreaterThanOrEqualTo>0</ChargeGreaterThanOrEqualTo>
  <ChargeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </ChargeIn>
  <ChargeLessThan>0</ChargeLessThan>
  <ChargeLessThanOrEqualTo>0</ChargeLessThanOrEqualTo>
  <ChargeNotEqualTo>0</ChargeNotEqualTo>
  <Cost>0</Cost>
  <CostBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </CostBetween>
  <CostGreaterThan>0</CostGreaterThan>
  <CostGreaterThanOrEqualTo>0</CostGreaterThanOrEqualTo>
  <CostIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </CostIn>
  <CostLessThan>0</CostLessThan>
  <CostLessThanOrEqualTo>0</CostLessThanOrEqualTo>
  <CostNotEqualTo>0</CostNotEqualTo>
  <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>
  <Qty>0</Qty>
  <QtyBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QtyBetween>
  <QtyGreaterThan>0</QtyGreaterThan>
  <QtyGreaterThanOrEqualTo>0</QtyGreaterThanOrEqualTo>
  <QtyIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QtyIn>
  <QtyLessThan>0</QtyLessThan>
  <QtyLessThanOrEqualTo>0</QtyLessThanOrEqualTo>
  <QtyNotEqualTo>0</QtyNotEqualTo>
</v_JB_ResourcesTotalsToDateQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfv_JB_ResourcesTotalsToDate7kRqkrSv 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_JB_ResourcesTotalsToDate>
      <d2p1:_x003C_Charge_x003E_k__BackingField>0</d2p1:_x003C_Charge_x003E_k__BackingField>
      <d2p1:_x003C_Cost_x003E_k__BackingField>0</d2p1:_x003C_Cost_x003E_k__BackingField>
      <d2p1:_x003C_JobID_x003E_k__BackingField>String</d2p1:_x003C_JobID_x003E_k__BackingField>
      <d2p1:_x003C_Qty_x003E_k__BackingField>0</d2p1:_x003C_Qty_x003E_k__BackingField>
    </d2p1:v_JB_ResourcesTotalsToDate>
  </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_JB_ResourcesTotalsToDate7kRqkrSv>