JiwaAPI

<back to all web services

IN_StandCostLineQuery

Requires Authentication
IN_StandCostLineQuery Parameters:
NameParameterData TypeRequiredDescription
INStandCostLineIDquerystringNo
INStandCostLineIDStartsWithquerystringNo
INStandCostLineIDEndsWithquerystringNo
INStandCostLineIDContainsquerystringNo
INStandCostLineIDLikequerystringNo
INStandCostLineIDBetweenquerystring[]No
INStandCostLineIDInquerystring[]No
INStandCostIDquerystringNo
INStandCostIDStartsWithquerystringNo
INStandCostIDEndsWithquerystringNo
INStandCostIDContainsquerystringNo
INStandCostIDLikequerystringNo
INStandCostIDBetweenquerystring[]No
INStandCostIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
PartNoquerystringNo
PartNoStartsWithquerystringNo
PartNoEndsWithquerystringNo
PartNoContainsquerystringNo
PartNoLikequerystringNo
PartNoBetweenquerystring[]No
PartNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
OldCostquerydecimal?No
OldCostGreaterThanOrEqualToquerydecimal?No
OldCostGreaterThanquerydecimal?No
OldCostLessThanquerydecimal?No
OldCostLessThanOrEqualToquerydecimal?No
OldCostNotEqualToquerydecimal?No
OldCostBetweenqueryNullable<Decimal>[]No
OldCostInqueryNullable<Decimal>[]No
NewCostquerydecimal?No
NewCostGreaterThanOrEqualToquerydecimal?No
NewCostGreaterThanquerydecimal?No
NewCostLessThanquerydecimal?No
NewCostLessThanOrEqualToquerydecimal?No
NewCostNotEqualToquerydecimal?No
NewCostBetweenqueryNullable<Decimal>[]No
NewCostInqueryNullable<Decimal>[]No
LastHomeCostquerydecimal?No
LastHomeCostGreaterThanOrEqualToquerydecimal?No
LastHomeCostGreaterThanquerydecimal?No
LastHomeCostLessThanquerydecimal?No
LastHomeCostLessThanOrEqualToquerydecimal?No
LastHomeCostNotEqualToquerydecimal?No
LastHomeCostBetweenqueryNullable<Decimal>[]No
LastHomeCostInqueryNullable<Decimal>[]No
LastSupplierCostquerydecimal?No
LastSupplierCostGreaterThanOrEqualToquerydecimal?No
LastSupplierCostGreaterThanquerydecimal?No
LastSupplierCostLessThanquerydecimal?No
LastSupplierCostLessThanOrEqualToquerydecimal?No
LastSupplierCostNotEqualToquerydecimal?No
LastSupplierCostBetweenqueryNullable<Decimal>[]No
LastSupplierCostInqueryNullable<Decimal>[]No
StandardDutyquerydecimal?No
StandardDutyGreaterThanOrEqualToquerydecimal?No
StandardDutyGreaterThanquerydecimal?No
StandardDutyLessThanquerydecimal?No
StandardDutyLessThanOrEqualToquerydecimal?No
StandardDutyNotEqualToquerydecimal?No
StandardDutyBetweenqueryNullable<Decimal>[]No
StandardDutyInqueryNullable<Decimal>[]No
StandardFreightquerydecimal?No
StandardFreightGreaterThanOrEqualToquerydecimal?No
StandardFreightGreaterThanquerydecimal?No
StandardFreightLessThanquerydecimal?No
StandardFreightLessThanOrEqualToquerydecimal?No
StandardFreightNotEqualToquerydecimal?No
StandardFreightBetweenqueryNullable<Decimal>[]No
StandardFreightInqueryNullable<Decimal>[]No
FXRatequerydecimal?No
FXRateGreaterThanOrEqualToquerydecimal?No
FXRateGreaterThanquerydecimal?No
FXRateLessThanquerydecimal?No
FXRateLessThanOrEqualToquerydecimal?No
FXRateNotEqualToquerydecimal?No
FXRateBetweenqueryNullable<Decimal>[]No
FXRateInqueryNullable<Decimal>[]No
UserValuequerydecimal?No
UserValueGreaterThanOrEqualToquerydecimal?No
UserValueGreaterThanquerydecimal?No
UserValueLessThanquerydecimal?No
UserValueLessThanOrEqualToquerydecimal?No
UserValueNotEqualToquerydecimal?No
UserValueBetweenqueryNullable<Decimal>[]No
UserValueInqueryNullable<Decimal>[]No
TotalSOHquerydecimal?No
TotalSOHGreaterThanOrEqualToquerydecimal?No
TotalSOHGreaterThanquerydecimal?No
TotalSOHLessThanquerydecimal?No
TotalSOHLessThanOrEqualToquerydecimal?No
TotalSOHNotEqualToquerydecimal?No
TotalSOHBetweenqueryNullable<Decimal>[]No
TotalSOHInqueryNullable<Decimal>[]No
CurrentValuequerydecimal?No
CurrentValueGreaterThanOrEqualToquerydecimal?No
CurrentValueGreaterThanquerydecimal?No
CurrentValueLessThanquerydecimal?No
CurrentValueLessThanOrEqualToquerydecimal?No
CurrentValueNotEqualToquerydecimal?No
CurrentValueBetweenqueryNullable<Decimal>[]No
CurrentValueInqueryNullable<Decimal>[]No
NewValuequerydecimal?No
NewValueGreaterThanOrEqualToquerydecimal?No
NewValueGreaterThanquerydecimal?No
NewValueLessThanquerydecimal?No
NewValueLessThanOrEqualToquerydecimal?No
NewValueNotEqualToquerydecimal?No
NewValueBetweenqueryNullable<Decimal>[]No
NewValueInqueryNullable<Decimal>[]No
Variancequerydecimal?No
VarianceGreaterThanOrEqualToquerydecimal?No
VarianceGreaterThanquerydecimal?No
VarianceLessThanquerydecimal?No
VarianceLessThanOrEqualToquerydecimal?No
VarianceNotEqualToquerydecimal?No
VarianceBetweenqueryNullable<Decimal>[]No
VarianceInqueryNullable<Decimal>[]No
DecimalPlacesqueryshort?No
DecimalPlacesGreaterThanOrEqualToqueryshort?No
DecimalPlacesGreaterThanqueryshort?No
DecimalPlacesLessThanqueryshort?No
DecimalPlacesLessThanOrEqualToqueryshort?No
DecimalPlacesNotEqualToqueryshort?No
DecimalPlacesBetweenqueryNullable<Int16>[]No
DecimalPlacesInqueryNullable<Int16>[]No
FXCapitalRatequerydecimal?No
FXCapitalRateGreaterThanOrEqualToquerydecimal?No
FXCapitalRateGreaterThanquerydecimal?No
FXCapitalRateLessThanquerydecimal?No
FXCapitalRateLessThanOrEqualToquerydecimal?No
FXCapitalRateNotEqualToquerydecimal?No
FXCapitalRateBetweenqueryNullable<Decimal>[]No
FXCapitalRateInqueryNullable<Decimal>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IN_StandCostLine Parameters:
NameParameterData TypeRequiredDescription
INStandCostLineIDformstringNo
INStandCostIDformstringNo
InventoryIDformstringNo
PartNoformstringNo
DescriptionformstringNo
OldCostformdecimal?No
NewCostformdecimal?No
LastHomeCostformdecimal?No
LastSupplierCostformdecimal?No
StandardDutyformdecimal?No
StandardFreightformdecimal?No
FXRateformdecimal?No
UserValueformdecimal?No
TotalSOHformdecimal?No
CurrentValueformdecimal?No
NewValueformdecimal?No
Varianceformdecimal?No
DecimalPlacesformshort?No
FXCapitalRateformdecimal?No
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/IN_StandCostLineQuery HTTP/1.1 
Host: localhost 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"INStandCostLineID":"String","INStandCostLineIDStartsWith":"String","INStandCostLineIDEndsWith":"String","INStandCostLineIDContains":"String","INStandCostLineIDLike":"String","INStandCostLineIDBetween":["String"],"INStandCostLineIDIn":["String"],"INStandCostID":"String","INStandCostIDStartsWith":"String","INStandCostIDEndsWith":"String","INStandCostIDContains":"String","INStandCostIDLike":"String","INStandCostIDBetween":["String"],"INStandCostIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"PartNo":"String","PartNoStartsWith":"String","PartNoEndsWith":"String","PartNoContains":"String","PartNoLike":"String","PartNoBetween":["String"],"PartNoIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"OldCost":0,"OldCostGreaterThanOrEqualTo":0,"OldCostGreaterThan":0,"OldCostLessThan":0,"OldCostLessThanOrEqualTo":0,"OldCostNotEqualTo":0,"OldCostBetween":[0],"OldCostIn":[0],"NewCost":0,"NewCostGreaterThanOrEqualTo":0,"NewCostGreaterThan":0,"NewCostLessThan":0,"NewCostLessThanOrEqualTo":0,"NewCostNotEqualTo":0,"NewCostBetween":[0],"NewCostIn":[0],"LastHomeCost":0,"LastHomeCostGreaterThanOrEqualTo":0,"LastHomeCostGreaterThan":0,"LastHomeCostLessThan":0,"LastHomeCostLessThanOrEqualTo":0,"LastHomeCostNotEqualTo":0,"LastHomeCostBetween":[0],"LastHomeCostIn":[0],"LastSupplierCost":0,"LastSupplierCostGreaterThanOrEqualTo":0,"LastSupplierCostGreaterThan":0,"LastSupplierCostLessThan":0,"LastSupplierCostLessThanOrEqualTo":0,"LastSupplierCostNotEqualTo":0,"LastSupplierCostBetween":[0],"LastSupplierCostIn":[0],"StandardDuty":0,"StandardDutyGreaterThanOrEqualTo":0,"StandardDutyGreaterThan":0,"StandardDutyLessThan":0,"StandardDutyLessThanOrEqualTo":0,"StandardDutyNotEqualTo":0,"StandardDutyBetween":[0],"StandardDutyIn":[0],"StandardFreight":0,"StandardFreightGreaterThanOrEqualTo":0,"StandardFreightGreaterThan":0,"StandardFreightLessThan":0,"StandardFreightLessThanOrEqualTo":0,"StandardFreightNotEqualTo":0,"StandardFreightBetween":[0],"StandardFreightIn":[0],"FXRate":0,"FXRateGreaterThanOrEqualTo":0,"FXRateGreaterThan":0,"FXRateLessThan":0,"FXRateLessThanOrEqualTo":0,"FXRateNotEqualTo":0,"FXRateBetween":[0],"FXRateIn":[0],"UserValue":0,"UserValueGreaterThanOrEqualTo":0,"UserValueGreaterThan":0,"UserValueLessThan":0,"UserValueLessThanOrEqualTo":0,"UserValueNotEqualTo":0,"UserValueBetween":[0],"UserValueIn":[0],"TotalSOH":0,"TotalSOHGreaterThanOrEqualTo":0,"TotalSOHGreaterThan":0,"TotalSOHLessThan":0,"TotalSOHLessThanOrEqualTo":0,"TotalSOHNotEqualTo":0,"TotalSOHBetween":[0],"TotalSOHIn":[0],"CurrentValue":0,"CurrentValueGreaterThanOrEqualTo":0,"CurrentValueGreaterThan":0,"CurrentValueLessThan":0,"CurrentValueLessThanOrEqualTo":0,"CurrentValueNotEqualTo":0,"CurrentValueBetween":[0],"CurrentValueIn":[0],"NewValue":0,"NewValueGreaterThanOrEqualTo":0,"NewValueGreaterThan":0,"NewValueLessThan":0,"NewValueLessThanOrEqualTo":0,"NewValueNotEqualTo":0,"NewValueBetween":[0],"NewValueIn":[0],"Variance":0,"VarianceGreaterThanOrEqualTo":0,"VarianceGreaterThan":0,"VarianceLessThan":0,"VarianceLessThanOrEqualTo":0,"VarianceNotEqualTo":0,"VarianceBetween":[0],"VarianceIn":[0],"DecimalPlaces":0,"DecimalPlacesGreaterThanOrEqualTo":0,"DecimalPlacesGreaterThan":0,"DecimalPlacesLessThan":0,"DecimalPlacesLessThanOrEqualTo":0,"DecimalPlacesNotEqualTo":0,"DecimalPlacesBetween":[0],"DecimalPlacesIn":[0],"FXCapitalRate":0,"FXCapitalRateGreaterThanOrEqualTo":0,"FXCapitalRateGreaterThan":0,"FXCapitalRateLessThan":0,"FXCapitalRateLessThanOrEqualTo":0,"FXCapitalRateNotEqualTo":0,"FXCapitalRateBetween":[0],"FXCapitalRateIn":[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":[{"INStandCostLineID":"String","INStandCostID":"String","InventoryID":"String","PartNo":"String","Description":"String","OldCost":0,"NewCost":0,"LastHomeCost":0,"LastSupplierCost":0,"StandardDuty":0,"StandardFreight":0,"FXRate":0,"UserValue":0,"TotalSOH":0,"CurrentValue":0,"NewValue":0,"Variance":0,"DecimalPlaces":0,"FXCapitalRate":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}