JiwaAPI

<back to all web services

IN_StandCostQuery

Requires Authentication
IN_StandCostQuery Parameters:
NameParameterData TypeRequiredDescription
INStandCostIDquerystringNo
INStandCostIDStartsWithquerystringNo
INStandCostIDEndsWithquerystringNo
INStandCostIDContainsquerystringNo
INStandCostIDLikequerystringNo
INStandCostIDBetweenquerystring[]No
INStandCostIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
DocumentNoquerystringNo
DocumentNoStartsWithquerystringNo
DocumentNoEndsWithquerystringNo
DocumentNoContainsquerystringNo
DocumentNoLikequerystringNo
DocumentNoBetweenquerystring[]No
DocumentNoInquerystring[]No
InitDatequeryDateTime?No
InitDateGreaterThanOrEqualToqueryDateTime?No
InitDateGreaterThanqueryDateTime?No
InitDateLessThanqueryDateTime?No
InitDateLessThanOrEqualToqueryDateTime?No
InitDateNotEqualToqueryDateTime?No
InitDateBetweenqueryDateTime[]No
InitDateInqueryDateTime[]No
UsageDatequeryDateTime?No
UsageDateGreaterThanOrEqualToqueryDateTime?No
UsageDateGreaterThanqueryDateTime?No
UsageDateLessThanqueryDateTime?No
UsageDateLessThanOrEqualToqueryDateTime?No
UsageDateNotEqualToqueryDateTime?No
UsageDateBetweenqueryNullable<DateTime>[]No
UsageDateInqueryNullable<DateTime>[]No
FormulaquerystringNo
FormulaStartsWithquerystringNo
FormulaEndsWithquerystringNo
FormulaContainsquerystringNo
FormulaLikequerystringNo
FormulaBetweenquerystring[]No
FormulaInquerystring[]No
Statusquerybool?No
RefquerystringNo
RefStartsWithquerystringNo
RefEndsWithquerystringNo
RefContainsquerystringNo
RefLikequerystringNo
RefBetweenquerystring[]No
RefInquerystring[]No
FromPartNoquerystringNo
FromPartNoStartsWithquerystringNo
FromPartNoEndsWithquerystringNo
FromPartNoContainsquerystringNo
FromPartNoLikequerystringNo
FromPartNoBetweenquerystring[]No
FromPartNoInquerystring[]No
ToPartNoquerystringNo
ToPartNoStartsWithquerystringNo
ToPartNoEndsWithquerystringNo
ToPartNoContainsquerystringNo
ToPartNoLikequerystringNo
ToPartNoBetweenquerystring[]No
ToPartNoInquerystring[]No
FromSupplierquerystringNo
FromSupplierStartsWithquerystringNo
FromSupplierEndsWithquerystringNo
FromSupplierContainsquerystringNo
FromSupplierLikequerystringNo
FromSupplierBetweenquerystring[]No
FromSupplierInquerystring[]No
ToSupplierquerystringNo
ToSupplierStartsWithquerystringNo
ToSupplierEndsWithquerystringNo
ToSupplierContainsquerystringNo
ToSupplierLikequerystringNo
ToSupplierBetweenquerystring[]No
ToSupplierInquerystring[]No
FromClassquerystringNo
FromClassStartsWithquerystringNo
FromClassEndsWithquerystringNo
FromClassContainsquerystringNo
FromClassLikequerystringNo
FromClassBetweenquerystring[]No
FromClassInquerystring[]No
ToClassquerystringNo
ToClassStartsWithquerystringNo
ToClassEndsWithquerystringNo
ToClassContainsquerystringNo
ToClassLikequerystringNo
ToClassBetweenquerystring[]No
ToClassInquerystring[]No
FromCat1querystringNo
FromCat1StartsWithquerystringNo
FromCat1EndsWithquerystringNo
FromCat1ContainsquerystringNo
FromCat1LikequerystringNo
FromCat1Betweenquerystring[]No
FromCat1Inquerystring[]No
ToCat1querystringNo
ToCat1StartsWithquerystringNo
ToCat1EndsWithquerystringNo
ToCat1ContainsquerystringNo
ToCat1LikequerystringNo
ToCat1Betweenquerystring[]No
ToCat1Inquerystring[]No
FromCat2querystringNo
FromCat2StartsWithquerystringNo
FromCat2EndsWithquerystringNo
FromCat2ContainsquerystringNo
FromCat2LikequerystringNo
FromCat2Betweenquerystring[]No
FromCat2Inquerystring[]No
ToCat2querystringNo
ToCat2StartsWithquerystringNo
ToCat2EndsWithquerystringNo
ToCat2ContainsquerystringNo
ToCat2LikequerystringNo
ToCat2Betweenquerystring[]No
ToCat2Inquerystring[]No
FromCat3querystringNo
FromCat3StartsWithquerystringNo
FromCat3EndsWithquerystringNo
FromCat3ContainsquerystringNo
FromCat3LikequerystringNo
FromCat3Betweenquerystring[]No
FromCat3Inquerystring[]No
ToCat3querystringNo
ToCat3StartsWithquerystringNo
ToCat3EndsWithquerystringNo
ToCat3ContainsquerystringNo
ToCat3LikequerystringNo
ToCat3Betweenquerystring[]No
ToCat3Inquerystring[]No
FromCat4querystringNo
FromCat4StartsWithquerystringNo
FromCat4EndsWithquerystringNo
FromCat4ContainsquerystringNo
FromCat4LikequerystringNo
FromCat4Betweenquerystring[]No
FromCat4Inquerystring[]No
ToCat4querystringNo
ToCat4StartsWithquerystringNo
ToCat4EndsWithquerystringNo
ToCat4ContainsquerystringNo
ToCat4LikequerystringNo
ToCat4Betweenquerystring[]No
ToCat4Inquerystring[]No
FromCat5querystringNo
FromCat5StartsWithquerystringNo
FromCat5EndsWithquerystringNo
FromCat5ContainsquerystringNo
FromCat5LikequerystringNo
FromCat5Betweenquerystring[]No
FromCat5Inquerystring[]No
ToCat5querystringNo
ToCat5StartsWithquerystringNo
ToCat5EndsWithquerystringNo
ToCat5ContainsquerystringNo
ToCat5LikequerystringNo
ToCat5Betweenquerystring[]No
ToCat5Inquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IN_StandCost Parameters:
NameParameterData TypeRequiredDescription
INStandCostIDformstringNo
LastSavedDateTimeformDateTimeNo
DocumentNoformstringNo
InitDateformDateTimeNo
UsageDateformDateTime?No
FormulaformstringNo
Statusformbool?No
RefformstringNo
FromPartNoformstringNo
ToPartNoformstringNo
FromSupplierformstringNo
ToSupplierformstringNo
FromClassformstringNo
ToClassformstringNo
FromCat1formstringNo
ToCat1formstringNo
FromCat2formstringNo
ToCat2formstringNo
FromCat3formstringNo
ToCat3formstringNo
FromCat4formstringNo
ToCat4formstringNo
FromCat5formstringNo
ToCat5formstringNo
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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

POST /json/reply/IN_StandCostQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
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: application/json
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"}}}