| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| AccountNo | query | string | No | |
| AccountNoStartsWith | query | string | No | |
| AccountNoEndsWith | query | string | No | |
| AccountNoContains | query | string | No | |
| AccountNoLike | query | string | No | |
| AccountNoBetween | query | string[] | No | |
| AccountNoIn | query | string[] | No | |
| Name | query | string | No | |
| NameStartsWith | query | string | No | |
| NameEndsWith | query | string | No | |
| NameContains | query | string | No | |
| NameLike | query | string | No | |
| NameBetween | query | string[] | No | |
| NameIn | query | string[] | No | |
| JobNo | query | string | No | |
| JobNoStartsWith | query | string | No | |
| JobNoEndsWith | query | string | No | |
| JobNoContains | query | string | No | |
| JobNoLike | query | string | No | |
| JobNoBetween | query | string[] | No | |
| JobNoIn | query | string[] | No | |
| Description | query | string | No | |
| DescriptionStartsWith | query | string | No | |
| DescriptionEndsWith | query | string | No | |
| DescriptionContains | query | string | No | |
| DescriptionLike | query | string | No | |
| DescriptionBetween | query | string[] | No | |
| DescriptionIn | query | string[] | No | |
| Status | query | string | No | |
| StatusStartsWith | query | string | No | |
| StatusEndsWith | query | string | No | |
| StatusContains | query | string | No | |
| StatusLike | query | string | No | |
| StatusBetween | query | string[] | No | |
| StatusIn | query | string[] | No | |
| EstEndDate | query | DateTime? | No | |
| EstEndDateGreaterThanOrEqualTo | query | DateTime? | No | |
| EstEndDateGreaterThan | query | DateTime? | No | |
| EstEndDateLessThan | query | DateTime? | No | |
| EstEndDateLessThanOrEqualTo | query | DateTime? | No | |
| EstEndDateNotEqualTo | query | DateTime? | No | |
| EstEndDateBetween | query | Nullable<DateTime>[] | No | |
| EstEndDateIn | query | Nullable<DateTime>[] | 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 | |
| ChargeToDate | query | decimal? | No | |
| ChargeToDateGreaterThanOrEqualTo | query | decimal? | No | |
| ChargeToDateGreaterThan | query | decimal? | No | |
| ChargeToDateLessThan | query | decimal? | No | |
| ChargeToDateLessThanOrEqualTo | query | decimal? | No | |
| ChargeToDateNotEqualTo | query | decimal? | No | |
| ChargeToDateBetween | query | Nullable<Decimal>[] | No | |
| ChargeToDateIn | query | Nullable<Decimal>[] | No | |
| CostToDate | query | decimal? | No | |
| CostToDateGreaterThanOrEqualTo | query | decimal? | No | |
| CostToDateGreaterThan | query | decimal? | No | |
| CostToDateLessThan | query | decimal? | No | |
| CostToDateLessThanOrEqualTo | query | decimal? | No | |
| CostToDateNotEqualTo | query | decimal? | No | |
| CostToDateBetween | query | Nullable<Decimal>[] | No | |
| CostToDateIn | query | Nullable<Decimal>[] | No | |
| LastInvoiceDate | query | DateTime? | No | |
| LastInvoiceDateGreaterThanOrEqualTo | query | DateTime? | No | |
| LastInvoiceDateGreaterThan | query | DateTime? | No | |
| LastInvoiceDateLessThan | query | DateTime? | No | |
| LastInvoiceDateLessThanOrEqualTo | query | DateTime? | No | |
| LastInvoiceDateNotEqualTo | query | DateTime? | No | |
| LastInvoiceDateBetween | query | Nullable<DateTime>[] | No | |
| LastInvoiceDateIn | query | Nullable<DateTime>[] | No | |
| WIPValueCost | query | decimal? | No | |
| WIPValueCostGreaterThanOrEqualTo | query | decimal? | No | |
| WIPValueCostGreaterThan | query | decimal? | No | |
| WIPValueCostLessThan | query | decimal? | No | |
| WIPValueCostLessThanOrEqualTo | query | decimal? | No | |
| WIPValueCostNotEqualTo | query | decimal? | No | |
| WIPValueCostBetween | query | Nullable<Decimal>[] | No | |
| WIPValueCostIn | query | Nullable<Decimal>[] | No | |
| WIPValueCharge | query | decimal? | No | |
| WIPValueChargeGreaterThanOrEqualTo | query | decimal? | No | |
| WIPValueChargeGreaterThan | query | decimal? | No | |
| WIPValueChargeLessThan | query | decimal? | No | |
| WIPValueChargeLessThanOrEqualTo | query | decimal? | No | |
| WIPValueChargeNotEqualTo | query | decimal? | No | |
| WIPValueChargeBetween | query | Nullable<Decimal>[] | No | |
| WIPValueChargeIn | query | Nullable<Decimal>[] | No | |
| EstimateCharge | query | decimal? | No | |
| EstimateChargeGreaterThanOrEqualTo | query | decimal? | No | |
| EstimateChargeGreaterThan | query | decimal? | No | |
| EstimateChargeLessThan | query | decimal? | No | |
| EstimateChargeLessThanOrEqualTo | query | decimal? | No | |
| EstimateChargeNotEqualTo | query | decimal? | No | |
| EstimateChargeBetween | query | Nullable<Decimal>[] | No | |
| EstimateChargeIn | query | Nullable<Decimal>[] | No | |
| InvoicedToDate | query | decimal? | No | |
| InvoicedToDateGreaterThanOrEqualTo | query | decimal? | No | |
| InvoicedToDateGreaterThan | query | decimal? | No | |
| InvoicedToDateLessThan | query | decimal? | No | |
| InvoicedToDateLessThanOrEqualTo | query | decimal? | No | |
| InvoicedToDateNotEqualTo | query | decimal? | No | |
| InvoicedToDateBetween | query | Nullable<Decimal>[] | No | |
| InvoicedToDateIn | query | Nullable<Decimal>[] | No | |
| EstimateCost | query | decimal? | No | |
| EstimateCostGreaterThanOrEqualTo | query | decimal? | No | |
| EstimateCostGreaterThan | query | decimal? | No | |
| EstimateCostLessThan | query | decimal? | No | |
| EstimateCostLessThanOrEqualTo | query | decimal? | No | |
| EstimateCostNotEqualTo | query | decimal? | No | |
| EstimateCostBetween | query | Nullable<Decimal>[] | No | |
| EstimateCostIn | query | Nullable<Decimal>[] | No | |
| InvoicedCostToDate | query | decimal? | No | |
| InvoicedCostToDateGreaterThanOrEqualTo | query | decimal? | No | |
| InvoicedCostToDateGreaterThan | query | decimal? | No | |
| InvoicedCostToDateLessThan | query | decimal? | No | |
| InvoicedCostToDateLessThanOrEqualTo | query | decimal? | No | |
| InvoicedCostToDateNotEqualTo | query | decimal? | No | |
| InvoicedCostToDateBetween | query | Nullable<Decimal>[] | No | |
| InvoicedCostToDateIn | query | Nullable<Decimal>[] | No | |
| MarginPercentage | query | decimal? | No | |
| MarginPercentageGreaterThanOrEqualTo | query | decimal? | No | |
| MarginPercentageGreaterThan | query | decimal? | No | |
| MarginPercentageLessThan | query | decimal? | No | |
| MarginPercentageLessThanOrEqualTo | query | decimal? | No | |
| MarginPercentageNotEqualTo | query | decimal? | No | |
| MarginPercentageBetween | query | Nullable<Decimal>[] | No | |
| MarginPercentageIn | query | Nullable<Decimal>[] | No | |
| PercentageInvoiced | query | decimal? | No | |
| PercentageInvoicedGreaterThanOrEqualTo | query | decimal? | No | |
| PercentageInvoicedGreaterThan | query | decimal? | No | |
| PercentageInvoicedLessThan | query | decimal? | No | |
| PercentageInvoicedLessThanOrEqualTo | query | decimal? | No | |
| PercentageInvoicedNotEqualTo | query | decimal? | No | |
| PercentageInvoicedBetween | query | Nullable<Decimal>[] | No | |
| PercentageInvoicedIn | query | Nullable<Decimal>[] | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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 |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| AccountNo | form | string | No | |
| Name | form | string | No | |
| JobNo | form | string | No | |
| Description | form | string | No | |
| Status | form | string | No | |
| EstEndDate | form | DateTime? | No | |
| JobID | form | string | No | |
| ChargeToDate | form | decimal? | No | |
| CostToDate | form | decimal? | No | |
| LastInvoiceDate | form | DateTime? | No | |
| WIPValueCost | form | decimal? | No | |
| WIPValueCharge | form | decimal? | No | |
| EstimateCharge | form | decimal? | No | |
| InvoicedToDate | form | decimal? | No | |
| EstimateCost | form | decimal? | No | |
| InvoicedCostToDate | form | decimal? | No | |
| MarginPercentage | form | decimal? | No | |
| PercentageInvoiced | form | decimal? | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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 .csv suffix or ?format=csv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /csv/reply/v_JB_JobsQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"AccountNo":"String","AccountNoStartsWith":"String","AccountNoEndsWith":"String","AccountNoContains":"String","AccountNoLike":"String","AccountNoBetween":["String"],"AccountNoIn":["String"],"Name":"String","NameStartsWith":"String","NameEndsWith":"String","NameContains":"String","NameLike":"String","NameBetween":["String"],"NameIn":["String"],"JobNo":"String","JobNoStartsWith":"String","JobNoEndsWith":"String","JobNoContains":"String","JobNoLike":"String","JobNoBetween":["String"],"JobNoIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"Status":"String","StatusStartsWith":"String","StatusEndsWith":"String","StatusContains":"String","StatusLike":"String","StatusBetween":["String"],"StatusIn":["String"],"EstEndDate":"0001-01-01T00:00:00.0000000","EstEndDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","EstEndDateGreaterThan":"0001-01-01T00:00:00.0000000","EstEndDateLessThan":"0001-01-01T00:00:00.0000000","EstEndDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","EstEndDateNotEqualTo":"0001-01-01T00:00:00.0000000","EstEndDateBetween":["0001-01-01T00:00:00.0000000"],"EstEndDateIn":["0001-01-01T00:00:00.0000000"],"JobID":"String","JobIDStartsWith":"String","JobIDEndsWith":"String","JobIDContains":"String","JobIDLike":"String","JobIDBetween":["String"],"JobIDIn":["String"],"ChargeToDate":0,"ChargeToDateGreaterThanOrEqualTo":0,"ChargeToDateGreaterThan":0,"ChargeToDateLessThan":0,"ChargeToDateLessThanOrEqualTo":0,"ChargeToDateNotEqualTo":0,"ChargeToDateBetween":[0],"ChargeToDateIn":[0],"CostToDate":0,"CostToDateGreaterThanOrEqualTo":0,"CostToDateGreaterThan":0,"CostToDateLessThan":0,"CostToDateLessThanOrEqualTo":0,"CostToDateNotEqualTo":0,"CostToDateBetween":[0],"CostToDateIn":[0],"LastInvoiceDate":"0001-01-01T00:00:00.0000000","LastInvoiceDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastInvoiceDateGreaterThan":"0001-01-01T00:00:00.0000000","LastInvoiceDateLessThan":"0001-01-01T00:00:00.0000000","LastInvoiceDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastInvoiceDateNotEqualTo":"0001-01-01T00:00:00.0000000","LastInvoiceDateBetween":["0001-01-01T00:00:00.0000000"],"LastInvoiceDateIn":["0001-01-01T00:00:00.0000000"],"WIPValueCost":0,"WIPValueCostGreaterThanOrEqualTo":0,"WIPValueCostGreaterThan":0,"WIPValueCostLessThan":0,"WIPValueCostLessThanOrEqualTo":0,"WIPValueCostNotEqualTo":0,"WIPValueCostBetween":[0],"WIPValueCostIn":[0],"WIPValueCharge":0,"WIPValueChargeGreaterThanOrEqualTo":0,"WIPValueChargeGreaterThan":0,"WIPValueChargeLessThan":0,"WIPValueChargeLessThanOrEqualTo":0,"WIPValueChargeNotEqualTo":0,"WIPValueChargeBetween":[0],"WIPValueChargeIn":[0],"EstimateCharge":0,"EstimateChargeGreaterThanOrEqualTo":0,"EstimateChargeGreaterThan":0,"EstimateChargeLessThan":0,"EstimateChargeLessThanOrEqualTo":0,"EstimateChargeNotEqualTo":0,"EstimateChargeBetween":[0],"EstimateChargeIn":[0],"InvoicedToDate":0,"InvoicedToDateGreaterThanOrEqualTo":0,"InvoicedToDateGreaterThan":0,"InvoicedToDateLessThan":0,"InvoicedToDateLessThanOrEqualTo":0,"InvoicedToDateNotEqualTo":0,"InvoicedToDateBetween":[0],"InvoicedToDateIn":[0],"EstimateCost":0,"EstimateCostGreaterThanOrEqualTo":0,"EstimateCostGreaterThan":0,"EstimateCostLessThan":0,"EstimateCostLessThanOrEqualTo":0,"EstimateCostNotEqualTo":0,"EstimateCostBetween":[0],"EstimateCostIn":[0],"InvoicedCostToDate":0,"InvoicedCostToDateGreaterThanOrEqualTo":0,"InvoicedCostToDateGreaterThan":0,"InvoicedCostToDateLessThan":0,"InvoicedCostToDateLessThanOrEqualTo":0,"InvoicedCostToDateNotEqualTo":0,"InvoicedCostToDateBetween":[0],"InvoicedCostToDateIn":[0],"MarginPercentage":0,"MarginPercentageGreaterThanOrEqualTo":0,"MarginPercentageGreaterThan":0,"MarginPercentageLessThan":0,"MarginPercentageLessThanOrEqualTo":0,"MarginPercentageNotEqualTo":0,"MarginPercentageBetween":[0],"MarginPercentageIn":[0],"PercentageInvoiced":0,"PercentageInvoicedGreaterThanOrEqualTo":0,"PercentageInvoicedGreaterThan":0,"PercentageInvoicedLessThan":0,"PercentageInvoicedLessThanOrEqualTo":0,"PercentageInvoicedNotEqualTo":0,"PercentageInvoicedBetween":[0],"PercentageInvoicedIn":[0],"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":[{"AccountNo":"String","Name":"String","JobNo":"String","Description":"String","Status":"String","EstEndDate":"0001-01-01T00:00:00.0000000","JobID":"String","ChargeToDate":0,"CostToDate":0,"LastInvoiceDate":"0001-01-01T00:00:00.0000000","WIPValueCost":0,"WIPValueCharge":0,"EstimateCharge":0,"InvoicedToDate":0,"EstimateCost":0,"InvoicedCostToDate":0,"MarginPercentage":0,"PercentageInvoiced":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}