JiwaAPI

DB_Main1Query

**DB_Main1Query** 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
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
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
Address1	query	string	No
Address1StartsWith	query	string	No
Address1EndsWith	query	string	No
Address1Contains	query	string	No
Address1Like	query	string	No
Address1Between	query	string[]	No
Address1In	query	string[]	No
Address2	query	string	No
Address2StartsWith	query	string	No
Address2EndsWith	query	string	No
Address2Contains	query	string	No
Address2Like	query	string	No
Address2Between	query	string[]	No
Address2In	query	string[]	No
Address3	query	string	No
Address3StartsWith	query	string	No
Address3EndsWith	query	string	No
Address3Contains	query	string	No
Address3Like	query	string	No
Address3Between	query	string[]	No
Address3In	query	string[]	No
Address4	query	string	No
Address4StartsWith	query	string	No
Address4EndsWith	query	string	No
Address4Contains	query	string	No
Address4Like	query	string	No
Address4Between	query	string[]	No
Address4In	query	string[]	No
PostCode	query	string	No
PostCodeStartsWith	query	string	No
PostCodeEndsWith	query	string	No
PostCodeContains	query	string	No
PostCodeLike	query	string	No
PostCodeBetween	query	string[]	No
PostCodeIn	query	string[]	No
Phone	query	string	No
PhoneStartsWith	query	string	No
PhoneEndsWith	query	string	No
PhoneContains	query	string	No
PhoneLike	query	string	No
PhoneBetween	query	string[]	No
PhoneIn	query	string[]	No
Fax	query	string	No
FaxStartsWith	query	string	No
FaxEndsWith	query	string	No
FaxContains	query	string	No
FaxLike	query	string	No
FaxBetween	query	string[]	No
FaxIn	query	string[]	No
BankName	query	string	No
BankNameStartsWith	query	string	No
BankNameEndsWith	query	string	No
BankNameContains	query	string	No
BankNameLike	query	string	No
BankNameBetween	query	string[]	No
BankNameIn	query	string[]	No
BankAcc	query	string	No
BankAccStartsWith	query	string	No
BankAccEndsWith	query	string	No
BankAccContains	query	string	No
BankAccLike	query	string	No
BankAccBetween	query	string[]	No
BankAccIn	query	string[]	No
BSBN	query	string	No
BSBNStartsWith	query	string	No
BSBNEndsWith	query	string	No
BSBNContains	query	string	No
BSBNLike	query	string	No
BSBNBetween	query	string[]	No
BSBNIn	query	string[]	No
AccountName	query	string	No
AccountNameStartsWith	query	string	No
AccountNameEndsWith	query	string	No
AccountNameContains	query	string	No
AccountNameLike	query	string	No
AccountNameBetween	query	string[]	No
AccountNameIn	query	string[]	No
TaxExemptNo	query	string	No
TaxExemptNoStartsWith	query	string	No
TaxExemptNoEndsWith	query	string	No
TaxExemptNoContains	query	string	No
TaxExemptNoLike	query	string	No
TaxExemptNoBetween	query	string[]	No
TaxExemptNoIn	query	string[]	No
AccountType	query	int?	No
AccountTypeGreaterThanOrEqualTo	query	int?	No
AccountTypeGreaterThan	query	int?	No
AccountTypeLessThan	query	int?	No
AccountTypeLessThanOrEqualTo	query	int?	No
AccountTypeNotEqualTo	query	int?	No
AccountTypeBetween	query	int[]	No
AccountTypeIn	query	int[]	No
CreditLimit	query	decimal?	No
CreditLimitGreaterThanOrEqualTo	query	decimal?	No
CreditLimitGreaterThan	query	decimal?	No
CreditLimitLessThan	query	decimal?	No
CreditLimitLessThanOrEqualTo	query	decimal?	No
CreditLimitNotEqualTo	query	decimal?	No
CreditLimitBetween	query	Nullable<Decimal>[]	No
CreditLimitIn	query	Nullable<Decimal>[]	No
EarlyPayDisOnStatsDays	query	short?	No
EarlyPayDisOnStatsDaysGreaterThanOrEqualTo	query	short?	No
EarlyPayDisOnStatsDaysGreaterThan	query	short?	No
EarlyPayDisOnStatsDaysLessThan	query	short?	No
EarlyPayDisOnStatsDaysLessThanOrEqualTo	query	short?	No
EarlyPayDisOnStatsDaysNotEqualTo	query	short?	No
EarlyPayDisOnStatsDaysBetween	query	Nullable<Int16>[]	No
EarlyPayDisOnStatsDaysIn	query	Nullable<Int16>[]	No
EarlyPayDisOnStatsAmt	query	decimal?	No
EarlyPayDisOnStatsAmtGreaterThanOrEqualTo	query	decimal?	No
EarlyPayDisOnStatsAmtGreaterThan	query	decimal?	No
EarlyPayDisOnStatsAmtLessThan	query	decimal?	No
EarlyPayDisOnStatsAmtLessThanOrEqualTo	query	decimal?	No
EarlyPayDisOnStatsAmtNotEqualTo	query	decimal?	No
EarlyPayDisOnStatsAmtBetween	query	Nullable<Decimal>[]	No
EarlyPayDisOnStatsAmtIn	query	Nullable<Decimal>[]	No
LastPurchaseDate	query	DateTime?	No
LastPurchaseDateGreaterThanOrEqualTo	query	DateTime?	No
LastPurchaseDateGreaterThan	query	DateTime?	No
LastPurchaseDateLessThan	query	DateTime?	No
LastPurchaseDateLessThanOrEqualTo	query	DateTime?	No
LastPurchaseDateNotEqualTo	query	DateTime?	No
LastPurchaseDateBetween	query	Nullable<DateTime>[]	No
LastPurchaseDateIn	query	Nullable<DateTime>[]	No
LastPaymentDate	query	DateTime?	No
LastPaymentDateGreaterThanOrEqualTo	query	DateTime?	No
LastPaymentDateGreaterThan	query	DateTime?	No
LastPaymentDateLessThan	query	DateTime?	No
LastPaymentDateLessThanOrEqualTo	query	DateTime?	No
LastPaymentDateNotEqualTo	query	DateTime?	No
LastPaymentDateBetween	query	Nullable<DateTime>[]	No
LastPaymentDateIn	query	Nullable<DateTime>[]	No
StandingDisOnInvoices	query	decimal?	No
StandingDisOnInvoicesGreaterThanOrEqualTo	query	decimal?	No
StandingDisOnInvoicesGreaterThan	query	decimal?	No
StandingDisOnInvoicesLessThan	query	decimal?	No
StandingDisOnInvoicesLessThanOrEqualTo	query	decimal?	No
StandingDisOnInvoicesNotEqualTo	query	decimal?	No
StandingDisOnInvoicesBetween	query	Nullable<Decimal>[]	No
StandingDisOnInvoicesIn	query	Nullable<Decimal>[]	No
ClassificationID	query	string	No
ClassificationIDStartsWith	query	string	No
ClassificationIDEndsWith	query	string	No
ClassificationIDContains	query	string	No
ClassificationIDLike	query	string	No
ClassificationIDBetween	query	string[]	No
ClassificationIDIn	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
Period1	query	decimal?	No
Period1GreaterThanOrEqualTo	query	decimal?	No
Period1GreaterThan	query	decimal?	No
Period1LessThan	query	decimal?	No
Period1LessThanOrEqualTo	query	decimal?	No
Period1NotEqualTo	query	decimal?	No
Period1Between	query	Nullable<Decimal>[]	No
Period1In	query	Nullable<Decimal>[]	No
Period2	query	decimal?	No
Period2GreaterThanOrEqualTo	query	decimal?	No
Period2GreaterThan	query	decimal?	No
Period2LessThan	query	decimal?	No
Period2LessThanOrEqualTo	query	decimal?	No
Period2NotEqualTo	query	decimal?	No
Period2Between	query	Nullable<Decimal>[]	No
Period2In	query	Nullable<Decimal>[]	No
Period3	query	decimal?	No
Period3GreaterThanOrEqualTo	query	decimal?	No
Period3GreaterThan	query	decimal?	No
Period3LessThan	query	decimal?	No
Period3LessThanOrEqualTo	query	decimal?	No
Period3NotEqualTo	query	decimal?	No
Period3Between	query	Nullable<Decimal>[]	No
Period3In	query	Nullable<Decimal>[]	No
Period4	query	decimal?	No
Period4GreaterThanOrEqualTo	query	decimal?	No
Period4GreaterThan	query	decimal?	No
Period4LessThan	query	decimal?	No
Period4LessThanOrEqualTo	query	decimal?	No
Period4NotEqualTo	query	decimal?	No
Period4Between	query	Nullable<Decimal>[]	No
Period4In	query	Nullable<Decimal>[]	No
Period5	query	int?	No
Period5GreaterThanOrEqualTo	query	int?	No
Period5GreaterThan	query	int?	No
Period5LessThan	query	int?	No
Period5LessThanOrEqualTo	query	int?	No
Period5NotEqualTo	query	int?	No
Period5Between	query	int[]	No
Period5In	query	int[]	No
Period6	query	int?	No
Period6GreaterThanOrEqualTo	query	int?	No
Period6GreaterThan	query	int?	No
Period6LessThan	query	int?	No
Period6LessThanOrEqualTo	query	int?	No
Period6NotEqualTo	query	int?	No
Period6Between	query	int[]	No
Period6In	query	int[]	No
Period7	query	int?	No
Period7GreaterThanOrEqualTo	query	int?	No
Period7GreaterThan	query	int?	No
Period7LessThan	query	int?	No
Period7LessThanOrEqualTo	query	int?	No
Period7NotEqualTo	query	int?	No
Period7Between	query	int[]	No
Period7In	query	int[]	No
Period8	query	int?	No
Period8GreaterThanOrEqualTo	query	int?	No
Period8GreaterThan	query	int?	No
Period8LessThan	query	int?	No
Period8LessThanOrEqualTo	query	int?	No
Period8NotEqualTo	query	int?	No
Period8Between	query	int[]	No
Period8In	query	int[]	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
NotifyRequired	query	bool?	No
NotifyAddress	query	string	No
NotifyAddressStartsWith	query	string	No
NotifyAddressEndsWith	query	string	No
NotifyAddressContains	query	string	No
NotifyAddressLike	query	string	No
NotifyAddressBetween	query	string[]	No
NotifyAddressIn	query	string[]	No
CommenceDate	query	DateTime?	No
CommenceDateGreaterThanOrEqualTo	query	DateTime?	No
CommenceDateGreaterThan	query	DateTime?	No
CommenceDateLessThan	query	DateTime?	No
CommenceDateLessThanOrEqualTo	query	DateTime?	No
CommenceDateNotEqualTo	query	DateTime?	No
CommenceDateBetween	query	Nullable<DateTime>[]	No
CommenceDateIn	query	Nullable<DateTime>[]	No
WebAccess	query	bool?	No
ParentDebtorID	query	string	No
ParentDebtorIDStartsWith	query	string	No
ParentDebtorIDEndsWith	query	string	No
ParentDebtorIDContains	query	string	No
ParentDebtorIDLike	query	string	No
ParentDebtorIDBetween	query	string[]	No
ParentDebtorIDIn	query	string[]	No
AllocLastSavedDateTime	query	DateTime?	No
AllocLastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
AllocLastSavedDateTimeGreaterThan	query	DateTime?	No
AllocLastSavedDateTimeLessThan	query	DateTime?	No
AllocLastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
AllocLastSavedDateTimeNotEqualTo	query	DateTime?	No
AllocLastSavedDateTimeBetween	query	Nullable<DateTime>[]	No
AllocLastSavedDateTimeIn	query	Nullable<DateTime>[]	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
AustPostDPID	query	string	No
AustPostDPIDStartsWith	query	string	No
AustPostDPIDEndsWith	query	string	No
AustPostDPIDContains	query	string	No
AustPostDPIDLike	query	string	No
AustPostDPIDBetween	query	string[]	No
AustPostDPIDIn	query	string[]	No
AustPostBCSP	query	string	No
AustPostBCSPStartsWith	query	string	No
AustPostBCSPEndsWith	query	string	No
AustPostBCSPContains	query	string	No
AustPostBCSPLike	query	string	No
AustPostBCSPBetween	query	string[]	No
AustPostBCSPIn	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

**DB_Main1** Parameters:
Name	Parameter	Data Type	Required
DebtorID	form	string	No
LastSavedDateTime	form	DateTime?	No
AccountNo	form	string	No
Name	form	string	No
Address1	form	string	No
Address2	form	string	No
Address3	form	string	No
Address4	form	string	No
PostCode	form	string	No
Phone	form	string	No
Fax	form	string	No
BankName	form	string	No
BankAcc	form	string	No
BSBN	form	string	No
AccountName	form	string	No
TaxExemptNo	form	string	No
AccountType	form	int	No
CreditLimit	form	decimal?	No
EarlyPayDisOnStatsDays	form	short?	No
EarlyPayDisOnStatsAmt	form	decimal?	No
LastPurchaseDate	form	DateTime?	No
LastPaymentDate	form	DateTime?	No
StandingDisOnInvoices	form	decimal?	No
ClassificationID	form	string	No
AccountOnHold	form	bool?	No
EmailAddress	form	string	No
CurrentBalance	form	decimal?	No
Period1	form	decimal?	No
Period2	form	decimal?	No
Period3	form	decimal?	No
Period4	form	decimal?	No
Period5	form	int	No
Period6	form	int	No
Period7	form	int	No
Period8	form	int	No
AltAccountNo	form	string	No
NotifyRequired	form	bool	No
NotifyAddress	form	string	No
CommenceDate	form	DateTime?	No
WebAccess	form	bool	No
ParentDebtorID	form	string	No
AllocLastSavedDateTime	form	DateTime?	No
PriceSchemeID	form	string	No
AustPostDPID	form	string	No
AustPostBCSP	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/DB_Main1Query HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["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"],"AccountNo":"String","AccountNoStartsWith":"String","AccountNoEndsWith":"String","AccountNoContains":"String","AccountNoLike":"String","AccountNoBetween":["String"],"AccountNoIn":["String"],"Name":"String","NameStartsWith":"String","NameEndsWith":"String","NameContains":"String","NameLike":"String","NameBetween":["String"],"NameIn":["String"],"Address1":"String","Address1StartsWith":"String","Address1EndsWith":"String","Address1Contains":"String","Address1Like":"String","Address1Between":["String"],"Address1In":["String"],"Address2":"String","Address2StartsWith":"String","Address2EndsWith":"String","Address2Contains":"String","Address2Like":"String","Address2Between":["String"],"Address2In":["String"],"Address3":"String","Address3StartsWith":"String","Address3EndsWith":"String","Address3Contains":"String","Address3Like":"String","Address3Between":["String"],"Address3In":["String"],"Address4":"String","Address4StartsWith":"String","Address4EndsWith":"String","Address4Contains":"String","Address4Like":"String","Address4Between":["String"],"Address4In":["String"],"PostCode":"String","PostCodeStartsWith":"String","PostCodeEndsWith":"String","PostCodeContains":"String","PostCodeLike":"String","PostCodeBetween":["String"],"PostCodeIn":["String"],"Phone":"String","PhoneStartsWith":"String","PhoneEndsWith":"String","PhoneContains":"String","PhoneLike":"String","PhoneBetween":["String"],"PhoneIn":["String"],"Fax":"String","FaxStartsWith":"String","FaxEndsWith":"String","FaxContains":"String","FaxLike":"String","FaxBetween":["String"],"FaxIn":["String"],"BankName":"String","BankNameStartsWith":"String","BankNameEndsWith":"String","BankNameContains":"String","BankNameLike":"String","BankNameBetween":["String"],"BankNameIn":["String"],"BankAcc":"String","BankAccStartsWith":"String","BankAccEndsWith":"String","BankAccContains":"String","BankAccLike":"String","BankAccBetween":["String"],"BankAccIn":["String"],"BSBN":"String","BSBNStartsWith":"String","BSBNEndsWith":"String","BSBNContains":"String","BSBNLike":"String","BSBNBetween":["String"],"BSBNIn":["String"],"AccountName":"String","AccountNameStartsWith":"String","AccountNameEndsWith":"String","AccountNameContains":"String","AccountNameLike":"String","AccountNameBetween":["String"],"AccountNameIn":["String"],"TaxExemptNo":"String","TaxExemptNoStartsWith":"String","TaxExemptNoEndsWith":"String","TaxExemptNoContains":"String","TaxExemptNoLike":"String","TaxExemptNoBetween":["String"],"TaxExemptNoIn":["String"],"AccountType":0,"AccountTypeGreaterThanOrEqualTo":0,"AccountTypeGreaterThan":0,"AccountTypeLessThan":0,"AccountTypeLessThanOrEqualTo":0,"AccountTypeNotEqualTo":0,"AccountTypeBetween":[0],"AccountTypeIn":[0],"CreditLimit":0,"CreditLimitGreaterThanOrEqualTo":0,"CreditLimitGreaterThan":0,"CreditLimitLessThan":0,"CreditLimitLessThanOrEqualTo":0,"CreditLimitNotEqualTo":0,"CreditLimitBetween":[0],"CreditLimitIn":[0],"EarlyPayDisOnStatsDays":0,"EarlyPayDisOnStatsDaysGreaterThanOrEqualTo":0,"EarlyPayDisOnStatsDaysGreaterThan":0,"EarlyPayDisOnStatsDaysLessThan":0,"EarlyPayDisOnStatsDaysLessThanOrEqualTo":0,"EarlyPayDisOnStatsDaysNotEqualTo":0,"EarlyPayDisOnStatsDaysBetween":[0],"EarlyPayDisOnStatsDaysIn":[0],"EarlyPayDisOnStatsAmt":0,"EarlyPayDisOnStatsAmtGreaterThanOrEqualTo":0,"EarlyPayDisOnStatsAmtGreaterThan":0,"EarlyPayDisOnStatsAmtLessThan":0,"EarlyPayDisOnStatsAmtLessThanOrEqualTo":0,"EarlyPayDisOnStatsAmtNotEqualTo":0,"EarlyPayDisOnStatsAmtBetween":[0],"EarlyPayDisOnStatsAmtIn":[0],"LastPurchaseDate":"0001-01-01T00:00:00.0000000","LastPurchaseDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastPurchaseDateGreaterThan":"0001-01-01T00:00:00.0000000","LastPurchaseDateLessThan":"0001-01-01T00:00:00.0000000","LastPurchaseDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastPurchaseDateNotEqualTo":"0001-01-01T00:00:00.0000000","LastPurchaseDateBetween":["0001-01-01T00:00:00.0000000"],"LastPurchaseDateIn":["0001-01-01T00:00:00.0000000"],"LastPaymentDate":"0001-01-01T00:00:00.0000000","LastPaymentDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastPaymentDateGreaterThan":"0001-01-01T00:00:00.0000000","LastPaymentDateLessThan":"0001-01-01T00:00:00.0000000","LastPaymentDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastPaymentDateNotEqualTo":"0001-01-01T00:00:00.0000000","LastPaymentDateBetween":["0001-01-01T00:00:00.0000000"],"LastPaymentDateIn":["0001-01-01T00:00:00.0000000"],"StandingDisOnInvoices":0,"StandingDisOnInvoicesGreaterThanOrEqualTo":0,"StandingDisOnInvoicesGreaterThan":0,"StandingDisOnInvoicesLessThan":0,"StandingDisOnInvoicesLessThanOrEqualTo":0,"StandingDisOnInvoicesNotEqualTo":0,"StandingDisOnInvoicesBetween":[0],"StandingDisOnInvoicesIn":[0],"ClassificationID":"String","ClassificationIDStartsWith":"String","ClassificationIDEndsWith":"String","ClassificationIDContains":"String","ClassificationIDLike":"String","ClassificationIDBetween":["String"],"ClassificationIDIn":["String"],"AccountOnHold":false,"EmailAddress":"String","EmailAddressStartsWith":"String","EmailAddressEndsWith":"String","EmailAddressContains":"String","EmailAddressLike":"String","EmailAddressBetween":["String"],"EmailAddressIn":["String"],"CurrentBalance":0,"CurrentBalanceGreaterThanOrEqualTo":0,"CurrentBalanceGreaterThan":0,"CurrentBalanceLessThan":0,"CurrentBalanceLessThanOrEqualTo":0,"CurrentBalanceNotEqualTo":0,"CurrentBalanceBetween":[0],"CurrentBalanceIn":[0],"Period1":0,"Period1GreaterThanOrEqualTo":0,"Period1GreaterThan":0,"Period1LessThan":0,"Period1LessThanOrEqualTo":0,"Period1NotEqualTo":0,"Period1Between":[0],"Period1In":[0],"Period2":0,"Period2GreaterThanOrEqualTo":0,"Period2GreaterThan":0,"Period2LessThan":0,"Period2LessThanOrEqualTo":0,"Period2NotEqualTo":0,"Period2Between":[0],"Period2In":[0],"Period3":0,"Period3GreaterThanOrEqualTo":0,"Period3GreaterThan":0,"Period3LessThan":0,"Period3LessThanOrEqualTo":0,"Period3NotEqualTo":0,"Period3Between":[0],"Period3In":[0],"Period4":0,"Period4GreaterThanOrEqualTo":0,"Period4GreaterThan":0,"Period4LessThan":0,"Period4LessThanOrEqualTo":0,"Period4NotEqualTo":0,"Period4Between":[0],"Period4In":[0],"Period5":0,"Period5GreaterThanOrEqualTo":0,"Period5GreaterThan":0,"Period5LessThan":0,"Period5LessThanOrEqualTo":0,"Period5NotEqualTo":0,"Period5Between":[0],"Period5In":[0],"Period6":0,"Period6GreaterThanOrEqualTo":0,"Period6GreaterThan":0,"Period6LessThan":0,"Period6LessThanOrEqualTo":0,"Period6NotEqualTo":0,"Period6Between":[0],"Period6In":[0],"Period7":0,"Period7GreaterThanOrEqualTo":0,"Period7GreaterThan":0,"Period7LessThan":0,"Period7LessThanOrEqualTo":0,"Period7NotEqualTo":0,"Period7Between":[0],"Period7In":[0],"Period8":0,"Period8GreaterThanOrEqualTo":0,"Period8GreaterThan":0,"Period8LessThan":0,"Period8LessThanOrEqualTo":0,"Period8NotEqualTo":0,"Period8Between":[0],"Period8In":[0],"AltAccountNo":"String","AltAccountNoStartsWith":"String","AltAccountNoEndsWith":"String","AltAccountNoContains":"String","AltAccountNoLike":"String","AltAccountNoBetween":["String"],"AltAccountNoIn":["String"],"NotifyRequired":false,"NotifyAddress":"String","NotifyAddressStartsWith":"String","NotifyAddressEndsWith":"String","NotifyAddressContains":"String","NotifyAddressLike":"String","NotifyAddressBetween":["String"],"NotifyAddressIn":["String"],"CommenceDate":"0001-01-01T00:00:00.0000000","CommenceDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","CommenceDateGreaterThan":"0001-01-01T00:00:00.0000000","CommenceDateLessThan":"0001-01-01T00:00:00.0000000","CommenceDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","CommenceDateNotEqualTo":"0001-01-01T00:00:00.0000000","CommenceDateBetween":["0001-01-01T00:00:00.0000000"],"CommenceDateIn":["0001-01-01T00:00:00.0000000"],"WebAccess":false,"ParentDebtorID":"String","ParentDebtorIDStartsWith":"String","ParentDebtorIDEndsWith":"String","ParentDebtorIDContains":"String","ParentDebtorIDLike":"String","ParentDebtorIDBetween":["String"],"ParentDebtorIDIn":["String"],"AllocLastSavedDateTime":"0001-01-01T00:00:00.0000000","AllocLastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","AllocLastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","AllocLastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","AllocLastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","AllocLastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","AllocLastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"AllocLastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"PriceSchemeID":"String","PriceSchemeIDStartsWith":"String","PriceSchemeIDEndsWith":"String","PriceSchemeIDContains":"String","PriceSchemeIDLike":"String","PriceSchemeIDBetween":["String"],"PriceSchemeIDIn":["String"],"AustPostDPID":"String","AustPostDPIDStartsWith":"String","AustPostDPIDEndsWith":"String","AustPostDPIDContains":"String","AustPostDPIDLike":"String","AustPostDPIDBetween":["String"],"AustPostDPIDIn":["String"],"AustPostBCSP":"String","AustPostBCSPStartsWith":"String","AustPostBCSPEndsWith":"String","AustPostBCSPContains":"String","AustPostBCSPLike":"String","AustPostBCSPBetween":["String"],"AustPostBCSPIn":["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":[{"DebtorID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","AccountNo":"String","Name":"String","Address1":"String","Address2":"String","Address3":"String","Address4":"String","PostCode":"String","Phone":"String","Fax":"String","BankName":"String","BankAcc":"String","BSBN":"String","AccountName":"String","TaxExemptNo":"String","CreditLimit":0,"EarlyPayDisOnStatsDays":0,"EarlyPayDisOnStatsAmt":0,"LastPurchaseDate":"0001-01-01T00:00:00.0000000","LastPaymentDate":"0001-01-01T00:00:00.0000000","StandingDisOnInvoices":0,"ClassificationID":"String","AccountOnHold":false,"EmailAddress":"String","CurrentBalance":0,"Period1":0,"Period2":0,"Period3":0,"Period4":0,"AltAccountNo":"String","NotifyAddress":"String","CommenceDate":"0001-01-01T00:00:00.0000000","ParentDebtorID":"String","AllocLastSavedDateTime":"0001-01-01T00:00:00.0000000","PriceSchemeID":"String","AustPostDPID":"String","AustPostBCSP":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}