JiwaAPI

IN_CreditorQuery

The following routes are available for this service:
GET	/Queries/IN_Creditor	Retrieves a list of IN_Creditor records

**IN_CreditorQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
InventoryID	query	string	No
InventoryIDStartsWith	query	string	No
InventoryIDEndsWith	query	string	No
InventoryIDContains	query	string	No
InventoryIDLike	query	string	No
InventoryIDBetween	query	string[]	No
InventoryIDIn	query	string[]	No
CreditorID	query	string	No
CreditorIDStartsWith	query	string	No
CreditorIDEndsWith	query	string	No
CreditorIDContains	query	string	No
CreditorIDLike	query	string	No
CreditorIDBetween	query	string[]	No
CreditorIDIn	query	string[]	No
PartNo	query	string	No
PartNoStartsWith	query	string	No
PartNoEndsWith	query	string	No
PartNoContains	query	string	No
PartNoLike	query	string	No
PartNoBetween	query	string[]	No
PartNoIn	query	string[]	No
SupplierUPC	query	string	No
SupplierUPCStartsWith	query	string	No
SupplierUPCEndsWith	query	string	No
SupplierUPCContains	query	string	No
SupplierUPCLike	query	string	No
SupplierUPCBetween	query	string[]	No
SupplierUPCIn	query	string[]	No
SpareFloat1	query	decimal?	No
SpareFloat1GreaterThanOrEqualTo	query	decimal?	No
SpareFloat1GreaterThan	query	decimal?	No
SpareFloat1LessThan	query	decimal?	No
SpareFloat1LessThanOrEqualTo	query	decimal?	No
SpareFloat1NotEqualTo	query	decimal?	No
SpareFloat1Between	query	Nullable<Decimal>[]	No
SpareFloat1In	query	Nullable<Decimal>[]	No
SpareFloat2	query	decimal?	No
SpareFloat2GreaterThanOrEqualTo	query	decimal?	No
SpareFloat2GreaterThan	query	decimal?	No
SpareFloat2LessThan	query	decimal?	No
SpareFloat2LessThanOrEqualTo	query	decimal?	No
SpareFloat2NotEqualTo	query	decimal?	No
SpareFloat2Between	query	Nullable<Decimal>[]	No
SpareFloat2In	query	Nullable<Decimal>[]	No
SpareFloat3	query	decimal?	No
SpareFloat3GreaterThanOrEqualTo	query	decimal?	No
SpareFloat3GreaterThan	query	decimal?	No
SpareFloat3LessThan	query	decimal?	No
SpareFloat3LessThanOrEqualTo	query	decimal?	No
SpareFloat3NotEqualTo	query	decimal?	No
SpareFloat3Between	query	Nullable<Decimal>[]	No
SpareFloat3In	query	Nullable<Decimal>[]	No
SpareString1	query	string	No
SpareString1StartsWith	query	string	No
SpareString1EndsWith	query	string	No
SpareString1Contains	query	string	No
SpareString1Like	query	string	No
SpareString1Between	query	string[]	No
SpareString1In	query	string[]	No
SpareString2	query	string	No
SpareString2StartsWith	query	string	No
SpareString2EndsWith	query	string	No
SpareString2Contains	query	string	No
SpareString2Like	query	string	No
SpareString2Between	query	string[]	No
SpareString2In	query	string[]	No
SpareString3	query	string	No
SpareString3StartsWith	query	string	No
SpareString3EndsWith	query	string	No
SpareString3Contains	query	string	No
SpareString3Like	query	string	No
SpareString3Between	query	string[]	No
SpareString3In	query	string[]	No
SpareDate1	query	DateTime?	No
SpareDate1GreaterThanOrEqualTo	query	DateTime?	No
SpareDate1GreaterThan	query	DateTime?	No
SpareDate1LessThan	query	DateTime?	No
SpareDate1LessThanOrEqualTo	query	DateTime?	No
SpareDate1NotEqualTo	query	DateTime?	No
SpareDate1Between	query	Nullable<DateTime>[]	No
SpareDate1In	query	Nullable<DateTime>[]	No
SpareDate2	query	DateTime?	No
SpareDate2GreaterThanOrEqualTo	query	DateTime?	No
SpareDate2GreaterThan	query	DateTime?	No
SpareDate2LessThan	query	DateTime?	No
SpareDate2LessThanOrEqualTo	query	DateTime?	No
SpareDate2NotEqualTo	query	DateTime?	No
SpareDate2Between	query	Nullable<DateTime>[]	No
SpareDate2In	query	Nullable<DateTime>[]	No
SpareDate3	query	DateTime?	No
SpareDate3GreaterThanOrEqualTo	query	DateTime?	No
SpareDate3GreaterThan	query	DateTime?	No
SpareDate3LessThan	query	DateTime?	No
SpareDate3LessThanOrEqualTo	query	DateTime?	No
SpareDate3NotEqualTo	query	DateTime?	No
SpareDate3Between	query	Nullable<DateTime>[]	No
SpareDate3In	query	Nullable<DateTime>[]	No
DefaultSupplier	query	bool?	No
IN_Region_RecID	query	string	No
IN_Region_RecIDStartsWith	query	string	No
IN_Region_RecIDEndsWith	query	string	No
IN_Region_RecIDContains	query	string	No
IN_Region_RecIDLike	query	string	No
IN_Region_RecIDBetween	query	string[]	No
IN_Region_RecIDIn	query	string[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	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

**IN_Creditor** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
InventoryID	form	string	No
CreditorID	form	string	No
PartNo	form	string	No
SupplierUPC	form	string	No
SpareFloat1	form	decimal?	No
SpareFloat2	form	decimal?	No
SpareFloat3	form	decimal?	No
SpareString1	form	string	No
SpareString2	form	string	No
SpareString3	form	string	No
SpareDate1	form	DateTime?	No
SpareDate2	form	DateTime?	No
SpareDate3	form	DateTime?	No
DefaultSupplier	form	bool?	No
IN_Region_RecID	form	string	No
ItemNo	form	int	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.

GET /Queries/IN_Creditor HTTP/1.1 
Host: apitrain.galipo.com.au 
Accept: text/csv

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"RecID":"String","InventoryID":"String","CreditorID":"String","PartNo":"String","SupplierUPC":"String","SpareFloat1":0,"SpareFloat2":0,"SpareFloat3":0,"SpareString1":"String","SpareString2":"String","SpareString3":"String","SpareDate1":"0001-01-01T00:00:00.0000000","SpareDate2":"0001-01-01T00:00:00.0000000","SpareDate3":"0001-01-01T00:00:00.0000000","DefaultSupplier":false,"IN_Region_RecID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}