JiwaAPI

v_JIWA_PurchaseOrders_UOMQuery

**v_JIWA_PurchaseOrders_UOMQuery** Parameters:
Name	Parameter	Data Type	Required
OrderLineID	query	string	No
OrderLineIDStartsWith	query	string	No
OrderLineIDEndsWith	query	string	No
OrderLineIDContains	query	string	No
OrderLineIDLike	query	string	No
OrderLineIDBetween	query	string[]	No
OrderLineIDIn	query	string[]	No
QtyUom	query	decimal?	No
QtyUomGreaterThanOrEqualTo	query	decimal?	No
QtyUomGreaterThan	query	decimal?	No
QtyUomLessThan	query	decimal?	No
QtyUomLessThanOrEqualTo	query	decimal?	No
QtyUomNotEqualTo	query	decimal?	No
QtyUomBetween	query	Nullable<Decimal>[]	No
QtyUomIn	query	Nullable<Decimal>[]	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

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
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

**v_JIWA_PurchaseOrders_UOM** Parameters:
Name	Parameter	Data Type	Required
OrderLineID	form	string	No
QtyUom	form	decimal?	No
Name	form	string	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
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

HTTP + CSV

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

POST /csv/reply/v_JIWA_PurchaseOrders_UOMQuery HTTP/1.1 
Host: localhost 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"OrderLineID":"String","OrderLineIDStartsWith":"String","OrderLineIDEndsWith":"String","OrderLineIDContains":"String","OrderLineIDLike":"String","OrderLineIDBetween":["String"],"OrderLineIDIn":["String"],"QtyUom":0,"QtyUomGreaterThanOrEqualTo":0,"QtyUomGreaterThan":0,"QtyUomLessThan":0,"QtyUomLessThanOrEqualTo":0,"QtyUomNotEqualTo":0,"QtyUomBetween":[0],"QtyUomIn":[0],"Name":"String","NameStartsWith":"String","NameEndsWith":"String","NameContains":"String","NameLike":"String","NameBetween":["String"],"NameIn":["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":[{"OrderLineID":"String","QtyUom":0,"Name":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}