JiwaAPI

<back to all web services

v_JB_InvoicedToDateQuery

Requires Authentication
v_JB_InvoicedToDateQuery Parameters:
NameParameterData TypeRequiredDescription
InvoicedAmountquerydecimal?No
InvoicedAmountGreaterThanOrEqualToquerydecimal?No
InvoicedAmountGreaterThanquerydecimal?No
InvoicedAmountLessThanquerydecimal?No
InvoicedAmountLessThanOrEqualToquerydecimal?No
InvoicedAmountNotEqualToquerydecimal?No
InvoicedAmountBetweenqueryNullable<Decimal>[]No
InvoicedAmountInqueryNullable<Decimal>[]No
InvoicedCostquerydecimal?No
InvoicedCostGreaterThanOrEqualToquerydecimal?No
InvoicedCostGreaterThanquerydecimal?No
InvoicedCostLessThanquerydecimal?No
InvoicedCostLessThanOrEqualToquerydecimal?No
InvoicedCostNotEqualToquerydecimal?No
InvoicedCostBetweenqueryNullable<Decimal>[]No
InvoicedCostInqueryNullable<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_InvoicedToDate Parameters:
NameParameterData TypeRequiredDescription
InvoicedAmountformdecimal?No
InvoicedCostformdecimal?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 .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /csv/reply/v_JB_InvoicedToDateQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"InvoicedAmount":0,"InvoicedAmountGreaterThanOrEqualTo":0,"InvoicedAmountGreaterThan":0,"InvoicedAmountLessThan":0,"InvoicedAmountLessThanOrEqualTo":0,"InvoicedAmountNotEqualTo":0,"InvoicedAmountBetween":[0],"InvoicedAmountIn":[0],"InvoicedCost":0,"InvoicedCostGreaterThanOrEqualTo":0,"InvoicedCostGreaterThan":0,"InvoicedCostLessThan":0,"InvoicedCostLessThanOrEqualTo":0,"InvoicedCostNotEqualTo":0,"InvoicedCostBetween":[0],"InvoicedCostIn":[0],"JobID":"String","JobIDStartsWith":"String","JobIDEndsWith":"String","JobIDContains":"String","JobIDLike":"String","JobIDBetween":["String"],"JobIDIn":["String"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"InvoicedAmount":0,"InvoicedCost":0,"JobID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}