| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| INStandCostID | query | string | No | |
| INStandCostIDStartsWith | query | string | No | |
| INStandCostIDEndsWith | query | string | No | |
| INStandCostIDContains | query | string | No | |
| INStandCostIDLike | query | string | No | |
| INStandCostIDBetween | query | string[] | No | |
| INStandCostIDIn | query | string[] | No | |
| LastSavedDateTime | query | DateTime? | No | |
| LastSavedDateTimeGreaterThanOrEqualTo | query | DateTime? | No | |
| LastSavedDateTimeGreaterThan | query | DateTime? | No | |
| LastSavedDateTimeLessThan | query | DateTime? | No | |
| LastSavedDateTimeLessThanOrEqualTo | query | DateTime? | No | |
| LastSavedDateTimeNotEqualTo | query | DateTime? | No | |
| LastSavedDateTimeBetween | query | DateTime[] | No | |
| LastSavedDateTimeIn | query | DateTime[] | No | |
| DocumentNo | query | string | No | |
| DocumentNoStartsWith | query | string | No | |
| DocumentNoEndsWith | query | string | No | |
| DocumentNoContains | query | string | No | |
| DocumentNoLike | query | string | No | |
| DocumentNoBetween | query | string[] | No | |
| DocumentNoIn | query | string[] | No | |
| InitDate | query | DateTime? | No | |
| InitDateGreaterThanOrEqualTo | query | DateTime? | No | |
| InitDateGreaterThan | query | DateTime? | No | |
| InitDateLessThan | query | DateTime? | No | |
| InitDateLessThanOrEqualTo | query | DateTime? | No | |
| InitDateNotEqualTo | query | DateTime? | No | |
| InitDateBetween | query | DateTime[] | No | |
| InitDateIn | query | DateTime[] | No | |
| UsageDate | query | DateTime? | No | |
| UsageDateGreaterThanOrEqualTo | query | DateTime? | No | |
| UsageDateGreaterThan | query | DateTime? | No | |
| UsageDateLessThan | query | DateTime? | No | |
| UsageDateLessThanOrEqualTo | query | DateTime? | No | |
| UsageDateNotEqualTo | query | DateTime? | No | |
| UsageDateBetween | query | Nullable<DateTime>[] | No | |
| UsageDateIn | query | Nullable<DateTime>[] | No | |
| Formula | query | string | No | |
| FormulaStartsWith | query | string | No | |
| FormulaEndsWith | query | string | No | |
| FormulaContains | query | string | No | |
| FormulaLike | query | string | No | |
| FormulaBetween | query | string[] | No | |
| FormulaIn | query | string[] | No | |
| Status | query | bool? | No | |
| Ref | query | string | No | |
| RefStartsWith | query | string | No | |
| RefEndsWith | query | string | No | |
| RefContains | query | string | No | |
| RefLike | query | string | No | |
| RefBetween | query | string[] | No | |
| RefIn | query | string[] | No | |
| FromPartNo | query | string | No | |
| FromPartNoStartsWith | query | string | No | |
| FromPartNoEndsWith | query | string | No | |
| FromPartNoContains | query | string | No | |
| FromPartNoLike | query | string | No | |
| FromPartNoBetween | query | string[] | No | |
| FromPartNoIn | query | string[] | No | |
| ToPartNo | query | string | No | |
| ToPartNoStartsWith | query | string | No | |
| ToPartNoEndsWith | query | string | No | |
| ToPartNoContains | query | string | No | |
| ToPartNoLike | query | string | No | |
| ToPartNoBetween | query | string[] | No | |
| ToPartNoIn | query | string[] | No | |
| FromSupplier | query | string | No | |
| FromSupplierStartsWith | query | string | No | |
| FromSupplierEndsWith | query | string | No | |
| FromSupplierContains | query | string | No | |
| FromSupplierLike | query | string | No | |
| FromSupplierBetween | query | string[] | No | |
| FromSupplierIn | query | string[] | No | |
| ToSupplier | query | string | No | |
| ToSupplierStartsWith | query | string | No | |
| ToSupplierEndsWith | query | string | No | |
| ToSupplierContains | query | string | No | |
| ToSupplierLike | query | string | No | |
| ToSupplierBetween | query | string[] | No | |
| ToSupplierIn | query | string[] | No | |
| FromClass | query | string | No | |
| FromClassStartsWith | query | string | No | |
| FromClassEndsWith | query | string | No | |
| FromClassContains | query | string | No | |
| FromClassLike | query | string | No | |
| FromClassBetween | query | string[] | No | |
| FromClassIn | query | string[] | No | |
| ToClass | query | string | No | |
| ToClassStartsWith | query | string | No | |
| ToClassEndsWith | query | string | No | |
| ToClassContains | query | string | No | |
| ToClassLike | query | string | No | |
| ToClassBetween | query | string[] | No | |
| ToClassIn | query | string[] | No | |
| FromCat1 | query | string | No | |
| FromCat1StartsWith | query | string | No | |
| FromCat1EndsWith | query | string | No | |
| FromCat1Contains | query | string | No | |
| FromCat1Like | query | string | No | |
| FromCat1Between | query | string[] | No | |
| FromCat1In | query | string[] | No | |
| ToCat1 | query | string | No | |
| ToCat1StartsWith | query | string | No | |
| ToCat1EndsWith | query | string | No | |
| ToCat1Contains | query | string | No | |
| ToCat1Like | query | string | No | |
| ToCat1Between | query | string[] | No | |
| ToCat1In | query | string[] | No | |
| FromCat2 | query | string | No | |
| FromCat2StartsWith | query | string | No | |
| FromCat2EndsWith | query | string | No | |
| FromCat2Contains | query | string | No | |
| FromCat2Like | query | string | No | |
| FromCat2Between | query | string[] | No | |
| FromCat2In | query | string[] | No | |
| ToCat2 | query | string | No | |
| ToCat2StartsWith | query | string | No | |
| ToCat2EndsWith | query | string | No | |
| ToCat2Contains | query | string | No | |
| ToCat2Like | query | string | No | |
| ToCat2Between | query | string[] | No | |
| ToCat2In | query | string[] | No | |
| FromCat3 | query | string | No | |
| FromCat3StartsWith | query | string | No | |
| FromCat3EndsWith | query | string | No | |
| FromCat3Contains | query | string | No | |
| FromCat3Like | query | string | No | |
| FromCat3Between | query | string[] | No | |
| FromCat3In | query | string[] | No | |
| ToCat3 | query | string | No | |
| ToCat3StartsWith | query | string | No | |
| ToCat3EndsWith | query | string | No | |
| ToCat3Contains | query | string | No | |
| ToCat3Like | query | string | No | |
| ToCat3Between | query | string[] | No | |
| ToCat3In | query | string[] | No | |
| FromCat4 | query | string | No | |
| FromCat4StartsWith | query | string | No | |
| FromCat4EndsWith | query | string | No | |
| FromCat4Contains | query | string | No | |
| FromCat4Like | query | string | No | |
| FromCat4Between | query | string[] | No | |
| FromCat4In | query | string[] | No | |
| ToCat4 | query | string | No | |
| ToCat4StartsWith | query | string | No | |
| ToCat4EndsWith | query | string | No | |
| ToCat4Contains | query | string | No | |
| ToCat4Like | query | string | No | |
| ToCat4Between | query | string[] | No | |
| ToCat4In | query | string[] | No | |
| FromCat5 | query | string | No | |
| FromCat5StartsWith | query | string | No | |
| FromCat5EndsWith | query | string | No | |
| FromCat5Contains | query | string | No | |
| FromCat5Like | query | string | No | |
| FromCat5Between | query | string[] | No | |
| FromCat5In | query | string[] | No | |
| ToCat5 | query | string | No | |
| ToCat5StartsWith | query | string | No | |
| ToCat5EndsWith | query | string | No | |
| ToCat5Contains | query | string | No | |
| ToCat5Like | query | string | No | |
| ToCat5Between | query | string[] | No | |
| ToCat5In | query | string[] | 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 |
|---|---|---|---|---|
| INStandCostID | form | string | No | |
| LastSavedDateTime | form | DateTime | No | |
| DocumentNo | form | string | No | |
| InitDate | form | DateTime | No | |
| UsageDate | form | DateTime? | No | |
| Formula | form | string | No | |
| Status | form | bool? | No | |
| Ref | form | string | No | |
| FromPartNo | form | string | No | |
| ToPartNo | form | string | No | |
| FromSupplier | form | string | No | |
| ToSupplier | form | string | No | |
| FromClass | form | string | No | |
| ToClass | form | string | No | |
| FromCat1 | form | string | No | |
| ToCat1 | form | string | No | |
| FromCat2 | form | string | No | |
| ToCat2 | form | string | No | |
| FromCat3 | form | string | No | |
| ToCat3 | form | string | No | |
| FromCat4 | form | string | No | |
| ToCat4 | form | string | No | |
| FromCat5 | form | string | No | |
| ToCat5 | form | string | 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/IN_StandCostQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"INStandCostID":"String","INStandCostIDStartsWith":"String","INStandCostIDEndsWith":"String","INStandCostIDContains":"String","INStandCostIDLike":"String","INStandCostIDBetween":["String"],"INStandCostIDIn":["String"],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"DocumentNo":"String","DocumentNoStartsWith":"String","DocumentNoEndsWith":"String","DocumentNoContains":"String","DocumentNoLike":"String","DocumentNoBetween":["String"],"DocumentNoIn":["String"],"InitDate":"0001-01-01T00:00:00.0000000","InitDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","InitDateGreaterThan":"0001-01-01T00:00:00.0000000","InitDateLessThan":"0001-01-01T00:00:00.0000000","InitDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","InitDateNotEqualTo":"0001-01-01T00:00:00.0000000","InitDateBetween":["0001-01-01T00:00:00.0000000"],"InitDateIn":["0001-01-01T00:00:00.0000000"],"UsageDate":"0001-01-01T00:00:00.0000000","UsageDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","UsageDateGreaterThan":"0001-01-01T00:00:00.0000000","UsageDateLessThan":"0001-01-01T00:00:00.0000000","UsageDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","UsageDateNotEqualTo":"0001-01-01T00:00:00.0000000","UsageDateBetween":["0001-01-01T00:00:00.0000000"],"UsageDateIn":["0001-01-01T00:00:00.0000000"],"Formula":"String","FormulaStartsWith":"String","FormulaEndsWith":"String","FormulaContains":"String","FormulaLike":"String","FormulaBetween":["String"],"FormulaIn":["String"],"Status":false,"Ref":"String","RefStartsWith":"String","RefEndsWith":"String","RefContains":"String","RefLike":"String","RefBetween":["String"],"RefIn":["String"],"FromPartNo":"String","FromPartNoStartsWith":"String","FromPartNoEndsWith":"String","FromPartNoContains":"String","FromPartNoLike":"String","FromPartNoBetween":["String"],"FromPartNoIn":["String"],"ToPartNo":"String","ToPartNoStartsWith":"String","ToPartNoEndsWith":"String","ToPartNoContains":"String","ToPartNoLike":"String","ToPartNoBetween":["String"],"ToPartNoIn":["String"],"FromSupplier":"String","FromSupplierStartsWith":"String","FromSupplierEndsWith":"String","FromSupplierContains":"String","FromSupplierLike":"String","FromSupplierBetween":["String"],"FromSupplierIn":["String"],"ToSupplier":"String","ToSupplierStartsWith":"String","ToSupplierEndsWith":"String","ToSupplierContains":"String","ToSupplierLike":"String","ToSupplierBetween":["String"],"ToSupplierIn":["String"],"FromClass":"String","FromClassStartsWith":"String","FromClassEndsWith":"String","FromClassContains":"String","FromClassLike":"String","FromClassBetween":["String"],"FromClassIn":["String"],"ToClass":"String","ToClassStartsWith":"String","ToClassEndsWith":"String","ToClassContains":"String","ToClassLike":"String","ToClassBetween":["String"],"ToClassIn":["String"],"FromCat1":"String","FromCat1StartsWith":"String","FromCat1EndsWith":"String","FromCat1Contains":"String","FromCat1Like":"String","FromCat1Between":["String"],"FromCat1In":["String"],"ToCat1":"String","ToCat1StartsWith":"String","ToCat1EndsWith":"String","ToCat1Contains":"String","ToCat1Like":"String","ToCat1Between":["String"],"ToCat1In":["String"],"FromCat2":"String","FromCat2StartsWith":"String","FromCat2EndsWith":"String","FromCat2Contains":"String","FromCat2Like":"String","FromCat2Between":["String"],"FromCat2In":["String"],"ToCat2":"String","ToCat2StartsWith":"String","ToCat2EndsWith":"String","ToCat2Contains":"String","ToCat2Like":"String","ToCat2Between":["String"],"ToCat2In":["String"],"FromCat3":"String","FromCat3StartsWith":"String","FromCat3EndsWith":"String","FromCat3Contains":"String","FromCat3Like":"String","FromCat3Between":["String"],"FromCat3In":["String"],"ToCat3":"String","ToCat3StartsWith":"String","ToCat3EndsWith":"String","ToCat3Contains":"String","ToCat3Like":"String","ToCat3Between":["String"],"ToCat3In":["String"],"FromCat4":"String","FromCat4StartsWith":"String","FromCat4EndsWith":"String","FromCat4Contains":"String","FromCat4Like":"String","FromCat4Between":["String"],"FromCat4In":["String"],"ToCat4":"String","ToCat4StartsWith":"String","ToCat4EndsWith":"String","ToCat4Contains":"String","ToCat4Like":"String","ToCat4Between":["String"],"ToCat4In":["String"],"FromCat5":"String","FromCat5StartsWith":"String","FromCat5EndsWith":"String","FromCat5Contains":"String","FromCat5Like":"String","FromCat5Between":["String"],"FromCat5In":["String"],"ToCat5":"String","ToCat5StartsWith":"String","ToCat5EndsWith":"String","ToCat5Contains":"String","ToCat5Like":"String","ToCat5Between":["String"],"ToCat5In":["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":[{"INStandCostID":"String","DocumentNo":"String","UsageDate":"0001-01-01T00:00:00.0000000","Formula":"String","Status":false,"Ref":"String","FromPartNo":"String","ToPartNo":"String","FromSupplier":"String","ToSupplier":"String","FromClass":"String","ToClass":"String","FromCat1":"String","ToCat1":"String","FromCat2":"String","ToCat2":"String","FromCat3":"String","ToCat3":"String","FromCat4":"String","ToCat4":"String","FromCat5":"String","ToCat5":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}