JiwaAPI

v_Oscar_DebtorsQuery

The following routes are available for this service:
GET	/Queries/OscarDebtors	Queryable list of debtors with default delivery address and contact name for Oscar

**v_Oscar_DebtorsQuery** Parameters:
Name	Parameter	Data Type	Required
DebtorID	query	string	No
DebtorIDStartsWith	query	string	No
DebtorIDEndsWith	query	string	No
DebtorIDContains	query	string	No
DebtorIDLike	query	string	No
DebtorIDBetween	query	string[]	No
DebtorIDIn	query	string[]	No
AccountNo	query	string	No
AccountNoStartsWith	query	string	No
AccountNoEndsWith	query	string	No
AccountNoContains	query	string	No
AccountNoLike	query	string	No
AccountNoBetween	query	string[]	No
AccountNoIn	query	string[]	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
AltAccountNo	query	string	No
AltAccountNoStartsWith	query	string	No
AltAccountNoEndsWith	query	string	No
AltAccountNoContains	query	string	No
AltAccountNoLike	query	string	No
AltAccountNoBetween	query	string[]	No
AltAccountNoIn	query	string[]	No
MailingAddress1	query	string	No
MailingAddress1StartsWith	query	string	No
MailingAddress1EndsWith	query	string	No
MailingAddress1Contains	query	string	No
MailingAddress1Like	query	string	No
MailingAddress1Between	query	string[]	No
MailingAddress1In	query	string[]	No
MailingAddress2	query	string	No
MailingAddress2StartsWith	query	string	No
MailingAddress2EndsWith	query	string	No
MailingAddress2Contains	query	string	No
MailingAddress2Like	query	string	No
MailingAddress2Between	query	string[]	No
MailingAddress2In	query	string[]	No
MailingAddress3	query	string	No
MailingAddress3StartsWith	query	string	No
MailingAddress3EndsWith	query	string	No
MailingAddress3Contains	query	string	No
MailingAddress3Like	query	string	No
MailingAddress3Between	query	string[]	No
MailingAddress3In	query	string[]	No
MailingAddress4	query	string	No
MailingAddress4StartsWith	query	string	No
MailingAddress4EndsWith	query	string	No
MailingAddress4Contains	query	string	No
MailingAddress4Like	query	string	No
MailingAddress4Between	query	string[]	No
MailingAddress4In	query	string[]	No
MailingAddressPostcode	query	string	No
MailingAddressPostcodeStartsWith	query	string	No
MailingAddressPostcodeEndsWith	query	string	No
MailingAddressPostcodeContains	query	string	No
MailingAddressPostcodeLike	query	string	No
MailingAddressPostcodeBetween	query	string[]	No
MailingAddressPostcodeIn	query	string[]	No
MailingAddressCountry	query	string	No
MailingAddressCountryStartsWith	query	string	No
MailingAddressCountryEndsWith	query	string	No
MailingAddressCountryContains	query	string	No
MailingAddressCountryLike	query	string	No
MailingAddressCountryBetween	query	string[]	No
MailingAddressCountryIn	query	string[]	No
MailingAddressPhone	query	string	No
MailingAddressPhoneStartsWith	query	string	No
MailingAddressPhoneEndsWith	query	string	No
MailingAddressPhoneContains	query	string	No
MailingAddressPhoneLike	query	string	No
MailingAddressPhoneBetween	query	string[]	No
MailingAddressPhoneIn	query	string[]	No
DeliveryAddressName	query	string	No
DeliveryAddressNameStartsWith	query	string	No
DeliveryAddressNameEndsWith	query	string	No
DeliveryAddressNameContains	query	string	No
DeliveryAddressNameLike	query	string	No
DeliveryAddressNameBetween	query	string[]	No
DeliveryAddressNameIn	query	string[]	No
DeliveryAddressCode	query	string	No
DeliveryAddressCodeStartsWith	query	string	No
DeliveryAddressCodeEndsWith	query	string	No
DeliveryAddressCodeContains	query	string	No
DeliveryAddressCodeLike	query	string	No
DeliveryAddressCodeBetween	query	string[]	No
DeliveryAddressCodeIn	query	string[]	No
DeliveryAddress1	query	string	No
DeliveryAddress1StartsWith	query	string	No
DeliveryAddress1EndsWith	query	string	No
DeliveryAddress1Contains	query	string	No
DeliveryAddress1Like	query	string	No
DeliveryAddress1Between	query	string[]	No
DeliveryAddress1In	query	string[]	No
DeliveryAddress2	query	string	No
DeliveryAddress2StartsWith	query	string	No
DeliveryAddress2EndsWith	query	string	No
DeliveryAddress2Contains	query	string	No
DeliveryAddress2Like	query	string	No
DeliveryAddress2Between	query	string[]	No
DeliveryAddress2In	query	string[]	No
DeliveryAddress3	query	string	No
DeliveryAddress3StartsWith	query	string	No
DeliveryAddress3EndsWith	query	string	No
DeliveryAddress3Contains	query	string	No
DeliveryAddress3Like	query	string	No
DeliveryAddress3Between	query	string[]	No
DeliveryAddress3In	query	string[]	No
DeliveryAddress4	query	string	No
DeliveryAddress4StartsWith	query	string	No
DeliveryAddress4EndsWith	query	string	No
DeliveryAddress4Contains	query	string	No
DeliveryAddress4Like	query	string	No
DeliveryAddress4Between	query	string[]	No
DeliveryAddress4In	query	string[]	No
DeliveryAddressPostcode	query	string	No
DeliveryAddressPostcodeStartsWith	query	string	No
DeliveryAddressPostcodeEndsWith	query	string	No
DeliveryAddressPostcodeContains	query	string	No
DeliveryAddressPostcodeLike	query	string	No
DeliveryAddressPostcodeBetween	query	string[]	No
DeliveryAddressPostcodeIn	query	string[]	No
DeliveryAddressCountry	query	string	No
DeliveryAddressCountryStartsWith	query	string	No
DeliveryAddressCountryEndsWith	query	string	No
DeliveryAddressCountryContains	query	string	No
DeliveryAddressCountryLike	query	string	No
DeliveryAddressCountryBetween	query	string[]	No
DeliveryAddressCountryIn	query	string[]	No
AccountOnHold	query	bool?	No
EmailAddress	query	string	No
EmailAddressStartsWith	query	string	No
EmailAddressEndsWith	query	string	No
EmailAddressContains	query	string	No
EmailAddressLike	query	string	No
EmailAddressBetween	query	string[]	No
EmailAddressIn	query	string[]	No
CurrentBalance	query	decimal?	No
CurrentBalanceGreaterThanOrEqualTo	query	decimal?	No
CurrentBalanceGreaterThan	query	decimal?	No
CurrentBalanceLessThan	query	decimal?	No
CurrentBalanceLessThanOrEqualTo	query	decimal?	No
CurrentBalanceNotEqualTo	query	decimal?	No
CurrentBalanceBetween	query	Nullable<Decimal>[]	No
CurrentBalanceIn	query	Nullable<Decimal>[]	No
WebAccess	query	bool?	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	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<DateTime>[]	No
TradingStatus	query	byte?	No
TradingStatusGreaterThanOrEqualTo	query	byte?	No
TradingStatusGreaterThan	query	byte?	No
TradingStatusLessThan	query	byte?	No
TradingStatusLessThanOrEqualTo	query	byte?	No
TradingStatusNotEqualTo	query	byte?	No
TradingStatusBetween	query	Nullable<Byte>[]	No
TradingStatusIn	query	Nullable<Byte>[]	No
DebtorClassificationID	query	string	No
DebtorClassificationIDStartsWith	query	string	No
DebtorClassificationIDEndsWith	query	string	No
DebtorClassificationIDContains	query	string	No
DebtorClassificationIDLike	query	string	No
DebtorClassificationIDBetween	query	string[]	No
DebtorClassificationIDIn	query	string[]	No
ClassificationDescription	query	string	No
ClassificationDescriptionStartsWith	query	string	No
ClassificationDescriptionEndsWith	query	string	No
ClassificationDescriptionContains	query	string	No
ClassificationDescriptionLike	query	string	No
ClassificationDescriptionBetween	query	string[]	No
ClassificationDescriptionIn	query	string[]	No
Category1ID	query	string	No
Category1IDStartsWith	query	string	No
Category1IDEndsWith	query	string	No
Category1IDContains	query	string	No
Category1IDLike	query	string	No
Category1IDBetween	query	string[]	No
Category1IDIn	query	string[]	No
Category1Description	query	string	No
Category1DescriptionStartsWith	query	string	No
Category1DescriptionEndsWith	query	string	No
Category1DescriptionContains	query	string	No
Category1DescriptionLike	query	string	No
Category1DescriptionBetween	query	string[]	No
Category1DescriptionIn	query	string[]	No
Category2ID	query	string	No
Category2IDStartsWith	query	string	No
Category2IDEndsWith	query	string	No
Category2IDContains	query	string	No
Category2IDLike	query	string	No
Category2IDBetween	query	string[]	No
Category2IDIn	query	string[]	No
Category2Description	query	string	No
Category2DescriptionStartsWith	query	string	No
Category2DescriptionEndsWith	query	string	No
Category2DescriptionContains	query	string	No
Category2DescriptionLike	query	string	No
Category2DescriptionBetween	query	string[]	No
Category2DescriptionIn	query	string[]	No
Category3ID	query	string	No
Category3IDStartsWith	query	string	No
Category3IDEndsWith	query	string	No
Category3IDContains	query	string	No
Category3IDLike	query	string	No
Category3IDBetween	query	string[]	No
Category3IDIn	query	string[]	No
Category3Description	query	string	No
Category3DescriptionStartsWith	query	string	No
Category3DescriptionEndsWith	query	string	No
Category3DescriptionContains	query	string	No
Category3DescriptionLike	query	string	No
Category3DescriptionBetween	query	string[]	No
Category3DescriptionIn	query	string[]	No
Category4ID	query	string	No
Category4IDStartsWith	query	string	No
Category4IDEndsWith	query	string	No
Category4IDContains	query	string	No
Category4IDLike	query	string	No
Category4IDBetween	query	string[]	No
Category4IDIn	query	string[]	No
Category4Description	query	string	No
Category4DescriptionStartsWith	query	string	No
Category4DescriptionEndsWith	query	string	No
Category4DescriptionContains	query	string	No
Category4DescriptionLike	query	string	No
Category4DescriptionBetween	query	string[]	No
Category4DescriptionIn	query	string[]	No
Category5ID	query	string	No
Category5IDStartsWith	query	string	No
Category5IDEndsWith	query	string	No
Category5IDContains	query	string	No
Category5IDLike	query	string	No
Category5IDBetween	query	string[]	No
Category5IDIn	query	string[]	No
Category5Description	query	string	No
Category5DescriptionStartsWith	query	string	No
Category5DescriptionEndsWith	query	string	No
Category5DescriptionContains	query	string	No
Category5DescriptionLike	query	string	No
Category5DescriptionBetween	query	string[]	No
Category5DescriptionIn	query	string[]	No
PriceSchemeID	query	string	No
PriceSchemeIDStartsWith	query	string	No
PriceSchemeIDEndsWith	query	string	No
PriceSchemeIDContains	query	string	No
PriceSchemeIDLike	query	string	No
PriceSchemeIDBetween	query	string[]	No
PriceSchemeIDIn	query	string[]	No
PriceSchemeDescription	query	string	No
PriceSchemeDescriptionStartsWith	query	string	No
PriceSchemeDescriptionEndsWith	query	string	No
PriceSchemeDescriptionContains	query	string	No
PriceSchemeDescriptionLike	query	string	No
PriceSchemeDescriptionBetween	query	string[]	No
PriceSchemeDescriptionIn	query	string[]	No
PricingGroupID	query	string	No
PricingGroupIDStartsWith	query	string	No
PricingGroupIDEndsWith	query	string	No
PricingGroupIDContains	query	string	No
PricingGroupIDLike	query	string	No
PricingGroupIDBetween	query	string[]	No
PricingGroupIDIn	query	string[]	No
PricingGroupDescription	query	string	No
PricingGroupDescriptionStartsWith	query	string	No
PricingGroupDescriptionEndsWith	query	string	No
PricingGroupDescriptionContains	query	string	No
PricingGroupDescriptionLike	query	string	No
PricingGroupDescriptionBetween	query	string[]	No
PricingGroupDescriptionIn	query	string[]	No
ContactTitle	query	string	No
ContactTitleStartsWith	query	string	No
ContactTitleEndsWith	query	string	No
ContactTitleContains	query	string	No
ContactTitleLike	query	string	No
ContactTitleBetween	query	string[]	No
ContactTitleIn	query	string[]	No
ContactFirstName	query	string	No
ContactFirstNameStartsWith	query	string	No
ContactFirstNameEndsWith	query	string	No
ContactFirstNameContains	query	string	No
ContactFirstNameLike	query	string	No
ContactFirstNameBetween	query	string[]	No
ContactFirstNameIn	query	string[]	No
ContactSurname	query	string	No
ContactSurnameStartsWith	query	string	No
ContactSurnameEndsWith	query	string	No
ContactSurnameContains	query	string	No
ContactSurnameLike	query	string	No
ContactSurnameBetween	query	string[]	No
ContactSurnameIn	query	string[]	No
ContactEmailAddress	query	string	No
ContactEmailAddressStartsWith	query	string	No
ContactEmailAddressEndsWith	query	string	No
ContactEmailAddressContains	query	string	No
ContactEmailAddressLike	query	string	No
ContactEmailAddressBetween	query	string[]	No
ContactEmailAddressIn	query	string[]	No
ContactTelephone	query	string	No
ContactTelephoneStartsWith	query	string	No
ContactTelephoneEndsWith	query	string	No
ContactTelephoneContains	query	string	No
ContactTelephoneLike	query	string	No
ContactTelephoneBetween	query	string[]	No
ContactTelephoneIn	query	string[]	No
ContactMobileTelephone	query	string	No
ContactMobileTelephoneStartsWith	query	string	No
ContactMobileTelephoneEndsWith	query	string	No
ContactMobileTelephoneContains	query	string	No
ContactMobileTelephoneLike	query	string	No
ContactMobileTelephoneBetween	query	string[]	No
ContactMobileTelephoneIn	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_Oscar_Debtors** Parameters:
Name	Parameter	Data Type	Required
DebtorID	form	string	No
AccountNo	form	string	No
Name	form	string	No
AltAccountNo	form	string	No
MailingAddress1	form	string	No
MailingAddress2	form	string	No
MailingAddress3	form	string	No
MailingAddress4	form	string	No
MailingAddressPostcode	form	string	No
MailingAddressCountry	form	string	No
MailingAddressPhone	form	string	No
DeliveryAddressName	form	string	No
DeliveryAddressCode	form	string	No
DeliveryAddress1	form	string	No
DeliveryAddress2	form	string	No
DeliveryAddress3	form	string	No
DeliveryAddress4	form	string	No
DeliveryAddressPostcode	form	string	No
DeliveryAddressCountry	form	string	No
AccountOnHold	form	bool?	No
EmailAddress	form	string	No
CurrentBalance	form	decimal?	No
WebAccess	form	bool	No
LastSavedDateTime	form	DateTime?	No
TradingStatus	form	byte?	No
DebtorClassificationID	form	string	No
ClassificationDescription	form	string	No
Category1ID	form	string	No
Category1Description	form	string	No
Category2ID	form	string	No
Category2Description	form	string	No
Category3ID	form	string	No
Category3Description	form	string	No
Category4ID	form	string	No
Category4Description	form	string	No
Category5ID	form	string	No
Category5Description	form	string	No
PriceSchemeID	form	string	No
PriceSchemeDescription	form	string	No
PricingGroupID	form	string	No
PricingGroupDescription	form	string	No
ContactTitle	form	string	No
ContactFirstName	form	string	No
ContactSurname	form	string	No
ContactEmailAddress	form	string	No
ContactTelephone	form	string	No
ContactMobileTelephone	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.

GET /Queries/OscarDebtors HTTP/1.1 
Host: 10.150.151.12 
Accept: text/csv

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

{"Results":[{"DebtorID":"String","AccountNo":"String","Name":"String","AltAccountNo":"String","MailingAddress1":"String","MailingAddress2":"String","MailingAddress3":"String","MailingAddress4":"String","MailingAddressPostcode":"String","MailingAddressCountry":"String","MailingAddressPhone":"String","DeliveryAddressName":"String","DeliveryAddressCode":"String","DeliveryAddress1":"String","DeliveryAddress2":"String","DeliveryAddress3":"String","DeliveryAddress4":"String","DeliveryAddressPostcode":"String","DeliveryAddressCountry":"String","AccountOnHold":false,"EmailAddress":"String","CurrentBalance":0,"LastSavedDateTime":"0001-01-01T00:00:00.0000000","TradingStatus":0,"DebtorClassificationID":"String","ClassificationDescription":"String","Category1ID":"String","Category1Description":"String","Category2ID":"String","Category2Description":"String","Category3ID":"String","Category3Description":"String","Category4ID":"String","Category4Description":"String","Category5ID":"String","Category5Description":"String","PriceSchemeID":"String","PriceSchemeDescription":"String","PricingGroupID":"String","PricingGroupDescription":"String","ContactTitle":"String","ContactFirstName":"String","ContactSurname":"String","ContactEmailAddress":"String","ContactTelephone":"String","ContactMobileTelephone":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}