JiwaAPI

v_JB_InvoicedToDateQuery

**v_JB_InvoicedToDateQuery** Parameters:
Name	Parameter	Data Type	Required
InvoicedAmount	query	decimal?	No
InvoicedAmountGreaterThanOrEqualTo	query	decimal?	No
InvoicedAmountGreaterThan	query	decimal?	No
InvoicedAmountLessThan	query	decimal?	No
InvoicedAmountLessThanOrEqualTo	query	decimal?	No
InvoicedAmountNotEqualTo	query	decimal?	No
InvoicedAmountBetween	query	Nullable<Decimal>[]	No
InvoicedAmountIn	query	Nullable<Decimal>[]	No
InvoicedCost	query	decimal?	No
InvoicedCostGreaterThanOrEqualTo	query	decimal?	No
InvoicedCostGreaterThan	query	decimal?	No
InvoicedCostLessThan	query	decimal?	No
InvoicedCostLessThanOrEqualTo	query	decimal?	No
InvoicedCostNotEqualTo	query	decimal?	No
InvoicedCostBetween	query	Nullable<Decimal>[]	No
InvoicedCostIn	query	Nullable<Decimal>[]	No
JobID	query	string	No
JobIDStartsWith	query	string	No
JobIDEndsWith	query	string	No
JobIDContains	query	string	No
JobIDLike	query	string	No
JobIDBetween	query	string[]	No
JobIDIn	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

**v_JB_InvoicedToDate** Parameters:
Name	Parameter	Data Type	Required
InvoicedAmount	form	decimal?	No
InvoicedCost	form	decimal?	No
JobID	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/v_JB_InvoicedToDateQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_JB_InvoicedToDateQuery 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>
  <InvoicedAmount>0</InvoicedAmount>
  <InvoicedAmountBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </InvoicedAmountBetween>
  <InvoicedAmountGreaterThan>0</InvoicedAmountGreaterThan>
  <InvoicedAmountGreaterThanOrEqualTo>0</InvoicedAmountGreaterThanOrEqualTo>
  <InvoicedAmountIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </InvoicedAmountIn>
  <InvoicedAmountLessThan>0</InvoicedAmountLessThan>
  <InvoicedAmountLessThanOrEqualTo>0</InvoicedAmountLessThanOrEqualTo>
  <InvoicedAmountNotEqualTo>0</InvoicedAmountNotEqualTo>
  <InvoicedCost>0</InvoicedCost>
  <InvoicedCostBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </InvoicedCostBetween>
  <InvoicedCostGreaterThan>0</InvoicedCostGreaterThan>
  <InvoicedCostGreaterThanOrEqualTo>0</InvoicedCostGreaterThanOrEqualTo>
  <InvoicedCostIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </InvoicedCostIn>
  <InvoicedCostLessThan>0</InvoicedCostLessThan>
  <InvoicedCostLessThanOrEqualTo>0</InvoicedCostLessThanOrEqualTo>
  <InvoicedCostNotEqualTo>0</InvoicedCostNotEqualTo>
  <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>
</v_JB_InvoicedToDateQuery>

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

<QueryResponseOfv_JB_InvoicedToDate7kRqkrSv 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_InvoicedToDate>
      <d2p1:_x003C_InvoicedAmount_x003E_k__BackingField>0</d2p1:_x003C_InvoicedAmount_x003E_k__BackingField>
      <d2p1:_x003C_InvoicedCost_x003E_k__BackingField>0</d2p1:_x003C_InvoicedCost_x003E_k__BackingField>
      <d2p1:_x003C_JobID_x003E_k__BackingField>String</d2p1:_x003C_JobID_x003E_k__BackingField>
    </d2p1:v_JB_InvoicedToDate>
  </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_InvoicedToDate7kRqkrSv>