JiwaAPI

<back to all web services

DB_Main2Query

Requires Authentication
DB_Main2Query Parameters:
NameParameterData TypeRequiredDescription
DebtorIDquerystringNo
DebtorIDStartsWithquerystringNo
DebtorIDEndsWithquerystringNo
DebtorIDContainsquerystringNo
DebtorIDLikequerystringNo
DebtorIDBetweenquerystring[]No
DebtorIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
TradingNamequerystringNo
TradingNameStartsWithquerystringNo
TradingNameEndsWithquerystringNo
TradingNameContainsquerystringNo
TradingNameLikequerystringNo
TradingNameBetweenquerystring[]No
TradingNameInquerystring[]No
CompanyNamequerystringNo
CompanyNameStartsWithquerystringNo
CompanyNameEndsWithquerystringNo
CompanyNameContainsquerystringNo
CompanyNameLikequerystringNo
CompanyNameBetweenquerystring[]No
CompanyNameInquerystring[]No
ACNquerystringNo
ACNStartsWithquerystringNo
ACNEndsWithquerystringNo
ACNContainsquerystringNo
ACNLikequerystringNo
ACNBetweenquerystring[]No
ACNInquerystring[]No
ProprietorsNamequerystringNo
ProprietorsNameStartsWithquerystringNo
ProprietorsNameEndsWithquerystringNo
ProprietorsNameContainsquerystringNo
ProprietorsNameLikequerystringNo
ProprietorsNameBetweenquerystring[]No
ProprietorsNameInquerystring[]No
FaxHeaderquerystringNo
FaxHeaderStartsWithquerystringNo
FaxHeaderEndsWithquerystringNo
FaxHeaderContainsquerystringNo
FaxHeaderLikequerystringNo
FaxHeaderBetweenquerystring[]No
FaxHeaderInquerystring[]No
D1querystringNo
D1StartsWithquerystringNo
D1EndsWithquerystringNo
D1ContainsquerystringNo
D1LikequerystringNo
D1Betweenquerystring[]No
D1Inquerystring[]No
D2querystringNo
D2StartsWithquerystringNo
D2EndsWithquerystringNo
D2ContainsquerystringNo
D2LikequerystringNo
D2Betweenquerystring[]No
D2Inquerystring[]No
D3querystringNo
D3StartsWithquerystringNo
D3EndsWithquerystringNo
D3ContainsquerystringNo
D3LikequerystringNo
D3Betweenquerystring[]No
D3Inquerystring[]No
D4querystringNo
D4StartsWithquerystringNo
D4EndsWithquerystringNo
D4ContainsquerystringNo
D4LikequerystringNo
D4Betweenquerystring[]No
D4Inquerystring[]No
D5querystringNo
D5StartsWithquerystringNo
D5EndsWithquerystringNo
D5ContainsquerystringNo
D5LikequerystringNo
D5Betweenquerystring[]No
D5Inquerystring[]No
D6querystringNo
D6StartsWithquerystringNo
D6EndsWithquerystringNo
D6ContainsquerystringNo
D6LikequerystringNo
D6Betweenquerystring[]No
D6Inquerystring[]No
D7querystringNo
D7StartsWithquerystringNo
D7EndsWithquerystringNo
D7ContainsquerystringNo
D7LikequerystringNo
D7Betweenquerystring[]No
D7Inquerystring[]No
D8querystringNo
D8StartsWithquerystringNo
D8EndsWithquerystringNo
D8ContainsquerystringNo
D8LikequerystringNo
D8Betweenquerystring[]No
D8Inquerystring[]No
D9querystringNo
D9StartsWithquerystringNo
D9EndsWithquerystringNo
D9ContainsquerystringNo
D9LikequerystringNo
D9Betweenquerystring[]No
D9Inquerystring[]No
D10querystringNo
D10StartsWithquerystringNo
D10EndsWithquerystringNo
D10ContainsquerystringNo
D10LikequerystringNo
D10Betweenquerystring[]No
D10Inquerystring[]No
D11querystringNo
D11StartsWithquerystringNo
D11EndsWithquerystringNo
D11ContainsquerystringNo
D11LikequerystringNo
D11Betweenquerystring[]No
D11Inquerystring[]No
OpeningBal1queryint?No
OpeningBal1GreaterThanOrEqualToqueryint?No
OpeningBal1GreaterThanqueryint?No
OpeningBal1LessThanqueryint?No
OpeningBal1LessThanOrEqualToqueryint?No
OpeningBal1NotEqualToqueryint?No
OpeningBal1Betweenqueryint[]No
OpeningBal1Inqueryint[]No
OpeningBal2queryint?No
OpeningBal2GreaterThanOrEqualToqueryint?No
OpeningBal2GreaterThanqueryint?No
OpeningBal2LessThanqueryint?No
OpeningBal2LessThanOrEqualToqueryint?No
OpeningBal2NotEqualToqueryint?No
OpeningBal2Betweenqueryint[]No
OpeningBal2Inqueryint[]No
OpeningBal3queryint?No
OpeningBal3GreaterThanOrEqualToqueryint?No
OpeningBal3GreaterThanqueryint?No
OpeningBal3LessThanqueryint?No
OpeningBal3LessThanOrEqualToqueryint?No
OpeningBal3NotEqualToqueryint?No
OpeningBal3Betweenqueryint[]No
OpeningBal3Inqueryint[]No
OpeningBal4queryint?No
OpeningBal4GreaterThanOrEqualToqueryint?No
OpeningBal4GreaterThanqueryint?No
OpeningBal4LessThanqueryint?No
OpeningBal4LessThanOrEqualToqueryint?No
OpeningBal4NotEqualToqueryint?No
OpeningBal4Betweenqueryint[]No
OpeningBal4Inqueryint[]No
OpeningBal5queryint?No
OpeningBal5GreaterThanOrEqualToqueryint?No
OpeningBal5GreaterThanqueryint?No
OpeningBal5LessThanqueryint?No
OpeningBal5LessThanOrEqualToqueryint?No
OpeningBal5NotEqualToqueryint?No
OpeningBal5Betweenqueryint[]No
OpeningBal5Inqueryint[]No
OpeningBal6queryint?No
OpeningBal6GreaterThanOrEqualToqueryint?No
OpeningBal6GreaterThanqueryint?No
OpeningBal6LessThanqueryint?No
OpeningBal6LessThanOrEqualToqueryint?No
OpeningBal6NotEqualToqueryint?No
OpeningBal6Betweenqueryint[]No
OpeningBal6Inqueryint[]No
OpeningBal7queryint?No
OpeningBal7GreaterThanOrEqualToqueryint?No
OpeningBal7GreaterThanqueryint?No
OpeningBal7LessThanqueryint?No
OpeningBal7LessThanOrEqualToqueryint?No
OpeningBal7NotEqualToqueryint?No
OpeningBal7Betweenqueryint[]No
OpeningBal7Inqueryint[]No
OpeningBal8queryint?No
OpeningBal8GreaterThanOrEqualToqueryint?No
OpeningBal8GreaterThanqueryint?No
OpeningBal8LessThanqueryint?No
OpeningBal8LessThanOrEqualToqueryint?No
OpeningBal8NotEqualToqueryint?No
OpeningBal8Betweenqueryint[]No
OpeningBal8Inqueryint[]No
OpeningBal9queryint?No
OpeningBal9GreaterThanOrEqualToqueryint?No
OpeningBal9GreaterThanqueryint?No
OpeningBal9LessThanqueryint?No
OpeningBal9LessThanOrEqualToqueryint?No
OpeningBal9NotEqualToqueryint?No
OpeningBal9Betweenqueryint[]No
OpeningBal9Inqueryint[]No
OpeningBal10queryint?No
OpeningBal10GreaterThanOrEqualToqueryint?No
OpeningBal10GreaterThanqueryint?No
OpeningBal10LessThanqueryint?No
OpeningBal10LessThanOrEqualToqueryint?No
OpeningBal10NotEqualToqueryint?No
OpeningBal10Betweenqueryint[]No
OpeningBal10Inqueryint[]No
OpeningBal11queryint?No
OpeningBal11GreaterThanOrEqualToqueryint?No
OpeningBal11GreaterThanqueryint?No
OpeningBal11LessThanqueryint?No
OpeningBal11LessThanOrEqualToqueryint?No
OpeningBal11NotEqualToqueryint?No
OpeningBal11Betweenqueryint[]No
OpeningBal11Inqueryint[]No
OpeningBal12queryint?No
OpeningBal12GreaterThanOrEqualToqueryint?No
OpeningBal12GreaterThanqueryint?No
OpeningBal12LessThanqueryint?No
OpeningBal12LessThanOrEqualToqueryint?No
OpeningBal12NotEqualToqueryint?No
OpeningBal12Betweenqueryint[]No
OpeningBal12Inqueryint[]No
OpeningBal13queryint?No
OpeningBal13GreaterThanOrEqualToqueryint?No
OpeningBal13GreaterThanqueryint?No
OpeningBal13LessThanqueryint?No
OpeningBal13LessThanOrEqualToqueryint?No
OpeningBal13NotEqualToqueryint?No
OpeningBal13Betweenqueryint[]No
OpeningBal13Inqueryint[]No
OpeningBal14queryint?No
OpeningBal14GreaterThanOrEqualToqueryint?No
OpeningBal14GreaterThanqueryint?No
OpeningBal14LessThanqueryint?No
OpeningBal14LessThanOrEqualToqueryint?No
OpeningBal14NotEqualToqueryint?No
OpeningBal14Betweenqueryint[]No
OpeningBal14Inqueryint[]No
OpeningBal15queryint?No
OpeningBal15GreaterThanOrEqualToqueryint?No
OpeningBal15GreaterThanqueryint?No
OpeningBal15LessThanqueryint?No
OpeningBal15LessThanOrEqualToqueryint?No
OpeningBal15NotEqualToqueryint?No
OpeningBal15Betweenqueryint[]No
OpeningBal15Inqueryint[]No
OpeningBal16queryint?No
OpeningBal16GreaterThanOrEqualToqueryint?No
OpeningBal16GreaterThanqueryint?No
OpeningBal16LessThanqueryint?No
OpeningBal16LessThanOrEqualToqueryint?No
OpeningBal16NotEqualToqueryint?No
OpeningBal16Betweenqueryint[]No
OpeningBal16Inqueryint[]No
OpeningBal17queryint?No
OpeningBal17GreaterThanOrEqualToqueryint?No
OpeningBal17GreaterThanqueryint?No
OpeningBal17LessThanqueryint?No
OpeningBal17LessThanOrEqualToqueryint?No
OpeningBal17NotEqualToqueryint?No
OpeningBal17Betweenqueryint[]No
OpeningBal17Inqueryint[]No
OpeningBal18queryint?No
OpeningBal18GreaterThanOrEqualToqueryint?No
OpeningBal18GreaterThanqueryint?No
OpeningBal18LessThanqueryint?No
OpeningBal18LessThanOrEqualToqueryint?No
OpeningBal18NotEqualToqueryint?No
OpeningBal18Betweenqueryint[]No
OpeningBal18Inqueryint[]No
OpeningBal19queryint?No
OpeningBal19GreaterThanOrEqualToqueryint?No
OpeningBal19GreaterThanqueryint?No
OpeningBal19LessThanqueryint?No
OpeningBal19LessThanOrEqualToqueryint?No
OpeningBal19NotEqualToqueryint?No
OpeningBal19Betweenqueryint[]No
OpeningBal19Inqueryint[]No
OpeningBal20queryint?No
OpeningBal20GreaterThanOrEqualToqueryint?No
OpeningBal20GreaterThanqueryint?No
OpeningBal20LessThanqueryint?No
OpeningBal20LessThanOrEqualToqueryint?No
OpeningBal20NotEqualToqueryint?No
OpeningBal20Betweenqueryint[]No
OpeningBal20Inqueryint[]No
OpeningBal21queryint?No
OpeningBal21GreaterThanOrEqualToqueryint?No
OpeningBal21GreaterThanqueryint?No
OpeningBal21LessThanqueryint?No
OpeningBal21LessThanOrEqualToqueryint?No
OpeningBal21NotEqualToqueryint?No
OpeningBal21Betweenqueryint[]No
OpeningBal21Inqueryint[]No
OpeningBal22queryint?No
OpeningBal22GreaterThanOrEqualToqueryint?No
OpeningBal22GreaterThanqueryint?No
OpeningBal22LessThanqueryint?No
OpeningBal22LessThanOrEqualToqueryint?No
OpeningBal22NotEqualToqueryint?No
OpeningBal22Betweenqueryint[]No
OpeningBal22Inqueryint[]No
OpeningBal23queryint?No
OpeningBal23GreaterThanOrEqualToqueryint?No
OpeningBal23GreaterThanqueryint?No
OpeningBal23LessThanqueryint?No
OpeningBal23LessThanOrEqualToqueryint?No
OpeningBal23NotEqualToqueryint?No
OpeningBal23Betweenqueryint[]No
OpeningBal23Inqueryint[]No
OpeningBal24queryint?No
OpeningBal24GreaterThanOrEqualToqueryint?No
OpeningBal24GreaterThanqueryint?No
OpeningBal24LessThanqueryint?No
OpeningBal24LessThanOrEqualToqueryint?No
OpeningBal24NotEqualToqueryint?No
OpeningBal24Betweenqueryint[]No
OpeningBal24Inqueryint[]No
OpeningBal25queryint?No
OpeningBal25GreaterThanOrEqualToqueryint?No
OpeningBal25GreaterThanqueryint?No
OpeningBal25LessThanqueryint?No
OpeningBal25LessThanOrEqualToqueryint?No
OpeningBal25NotEqualToqueryint?No
OpeningBal25Betweenqueryint[]No
OpeningBal25Inqueryint[]No
OpeningBal26queryint?No
OpeningBal26GreaterThanOrEqualToqueryint?No
OpeningBal26GreaterThanqueryint?No
OpeningBal26LessThanqueryint?No
OpeningBal26LessThanOrEqualToqueryint?No
OpeningBal26NotEqualToqueryint?No
OpeningBal26Betweenqueryint[]No
OpeningBal26Inqueryint[]No
OpeningBal27queryint?No
OpeningBal27GreaterThanOrEqualToqueryint?No
OpeningBal27GreaterThanqueryint?No
OpeningBal27LessThanqueryint?No
OpeningBal27LessThanOrEqualToqueryint?No
OpeningBal27NotEqualToqueryint?No
OpeningBal27Betweenqueryint[]No
OpeningBal27Inqueryint[]No
OpeningBal28queryint?No
OpeningBal28GreaterThanOrEqualToqueryint?No
OpeningBal28GreaterThanqueryint?No
OpeningBal28LessThanqueryint?No
OpeningBal28LessThanOrEqualToqueryint?No
OpeningBal28NotEqualToqueryint?No
OpeningBal28Betweenqueryint[]No
OpeningBal28Inqueryint[]No
OpeningBal29queryint?No
OpeningBal29GreaterThanOrEqualToqueryint?No
OpeningBal29GreaterThanqueryint?No
OpeningBal29LessThanqueryint?No
OpeningBal29LessThanOrEqualToqueryint?No
OpeningBal29NotEqualToqueryint?No
OpeningBal29Betweenqueryint[]No
OpeningBal29Inqueryint[]No
OpeningBal30queryint?No
OpeningBal30GreaterThanOrEqualToqueryint?No
OpeningBal30GreaterThanqueryint?No
OpeningBal30LessThanqueryint?No
OpeningBal30LessThanOrEqualToqueryint?No
OpeningBal30NotEqualToqueryint?No
OpeningBal30Betweenqueryint[]No
OpeningBal30Inqueryint[]No
OpeningBal31queryint?No
OpeningBal31GreaterThanOrEqualToqueryint?No
OpeningBal31GreaterThanqueryint?No
OpeningBal31LessThanqueryint?No
OpeningBal31LessThanOrEqualToqueryint?No
OpeningBal31NotEqualToqueryint?No
OpeningBal31Betweenqueryint[]No
OpeningBal31Inqueryint[]No
OpeningBal32queryint?No
OpeningBal32GreaterThanOrEqualToqueryint?No
OpeningBal32GreaterThanqueryint?No
OpeningBal32LessThanqueryint?No
OpeningBal32LessThanOrEqualToqueryint?No
OpeningBal32NotEqualToqueryint?No
OpeningBal32Betweenqueryint[]No
OpeningBal32Inqueryint[]No
OpeningBal33queryint?No
OpeningBal33GreaterThanOrEqualToqueryint?No
OpeningBal33GreaterThanqueryint?No
OpeningBal33LessThanqueryint?No
OpeningBal33LessThanOrEqualToqueryint?No
OpeningBal33NotEqualToqueryint?No
OpeningBal33Betweenqueryint[]No
OpeningBal33Inqueryint[]No
OpeningBal34queryint?No
OpeningBal34GreaterThanOrEqualToqueryint?No
OpeningBal34GreaterThanqueryint?No
OpeningBal34LessThanqueryint?No
OpeningBal34LessThanOrEqualToqueryint?No
OpeningBal34NotEqualToqueryint?No
OpeningBal34Betweenqueryint[]No
OpeningBal34Inqueryint[]No
OpeningBal35queryint?No
OpeningBal35GreaterThanOrEqualToqueryint?No
OpeningBal35GreaterThanqueryint?No
OpeningBal35LessThanqueryint?No
OpeningBal35LessThanOrEqualToqueryint?No
OpeningBal35NotEqualToqueryint?No
OpeningBal35Betweenqueryint[]No
OpeningBal35Inqueryint[]No
OpeningBal36queryint?No
OpeningBal36GreaterThanOrEqualToqueryint?No
OpeningBal36GreaterThanqueryint?No
OpeningBal36LessThanqueryint?No
OpeningBal36LessThanOrEqualToqueryint?No
OpeningBal36NotEqualToqueryint?No
OpeningBal36Betweenqueryint[]No
OpeningBal36Inqueryint[]No
OpeningBal37queryint?No
OpeningBal37GreaterThanOrEqualToqueryint?No
OpeningBal37GreaterThanqueryint?No
OpeningBal37LessThanqueryint?No
OpeningBal37LessThanOrEqualToqueryint?No
OpeningBal37NotEqualToqueryint?No
OpeningBal37Betweenqueryint[]No
OpeningBal37Inqueryint[]No
OpeningBal38queryint?No
OpeningBal38GreaterThanOrEqualToqueryint?No
OpeningBal38GreaterThanqueryint?No
OpeningBal38LessThanqueryint?No
OpeningBal38LessThanOrEqualToqueryint?No
OpeningBal38NotEqualToqueryint?No
OpeningBal38Betweenqueryint[]No
OpeningBal38Inqueryint[]No
OpeningBal39queryint?No
OpeningBal39GreaterThanOrEqualToqueryint?No
OpeningBal39GreaterThanqueryint?No
OpeningBal39LessThanqueryint?No
OpeningBal39LessThanOrEqualToqueryint?No
OpeningBal39NotEqualToqueryint?No
OpeningBal39Betweenqueryint[]No
OpeningBal39Inqueryint[]No
OpeningBal40queryint?No
OpeningBal40GreaterThanOrEqualToqueryint?No
OpeningBal40GreaterThanqueryint?No
OpeningBal40LessThanqueryint?No
OpeningBal40LessThanOrEqualToqueryint?No
OpeningBal40NotEqualToqueryint?No
OpeningBal40Betweenqueryint[]No
OpeningBal40Inqueryint[]No
OpeningBal41queryint?No
OpeningBal41GreaterThanOrEqualToqueryint?No
OpeningBal41GreaterThanqueryint?No
OpeningBal41LessThanqueryint?No
OpeningBal41LessThanOrEqualToqueryint?No
OpeningBal41NotEqualToqueryint?No
OpeningBal41Betweenqueryint[]No
OpeningBal41Inqueryint[]No
OpeningBal42queryint?No
OpeningBal42GreaterThanOrEqualToqueryint?No
OpeningBal42GreaterThanqueryint?No
OpeningBal42LessThanqueryint?No
OpeningBal42LessThanOrEqualToqueryint?No
OpeningBal42NotEqualToqueryint?No
OpeningBal42Betweenqueryint[]No
OpeningBal42Inqueryint[]No
OpeningBal43queryint?No
OpeningBal43GreaterThanOrEqualToqueryint?No
OpeningBal43GreaterThanqueryint?No
OpeningBal43LessThanqueryint?No
OpeningBal43LessThanOrEqualToqueryint?No
OpeningBal43NotEqualToqueryint?No
OpeningBal43Betweenqueryint[]No
OpeningBal43Inqueryint[]No
OpeningBal44queryint?No
OpeningBal44GreaterThanOrEqualToqueryint?No
OpeningBal44GreaterThanqueryint?No
OpeningBal44LessThanqueryint?No
OpeningBal44LessThanOrEqualToqueryint?No
OpeningBal44NotEqualToqueryint?No
OpeningBal44Betweenqueryint[]No
OpeningBal44Inqueryint[]No
OpeningBal45queryint?No
OpeningBal45GreaterThanOrEqualToqueryint?No
OpeningBal45GreaterThanqueryint?No
OpeningBal45LessThanqueryint?No
OpeningBal45LessThanOrEqualToqueryint?No
OpeningBal45NotEqualToqueryint?No
OpeningBal45Betweenqueryint[]No
OpeningBal45Inqueryint[]No
OpeningBal46queryint?No
OpeningBal46GreaterThanOrEqualToqueryint?No
OpeningBal46GreaterThanqueryint?No
OpeningBal46LessThanqueryint?No
OpeningBal46LessThanOrEqualToqueryint?No
OpeningBal46NotEqualToqueryint?No
OpeningBal46Betweenqueryint[]No
OpeningBal46Inqueryint[]No
OpeningBal47queryint?No
OpeningBal47GreaterThanOrEqualToqueryint?No
OpeningBal47GreaterThanqueryint?No
OpeningBal47LessThanqueryint?No
OpeningBal47LessThanOrEqualToqueryint?No
OpeningBal47NotEqualToqueryint?No
OpeningBal47Betweenqueryint[]No
OpeningBal47Inqueryint[]No
OpeningBal48queryint?No
OpeningBal48GreaterThanOrEqualToqueryint?No
OpeningBal48GreaterThanqueryint?No
OpeningBal48LessThanqueryint?No
OpeningBal48LessThanOrEqualToqueryint?No
OpeningBal48NotEqualToqueryint?No
OpeningBal48Betweenqueryint[]No
OpeningBal48Inqueryint[]No
OpeningBal49queryint?No
OpeningBal49GreaterThanOrEqualToqueryint?No
OpeningBal49GreaterThanqueryint?No
OpeningBal49LessThanqueryint?No
OpeningBal49LessThanOrEqualToqueryint?No
OpeningBal49NotEqualToqueryint?No
OpeningBal49Betweenqueryint[]No
OpeningBal49Inqueryint[]No
OpeningBal50queryint?No
OpeningBal50GreaterThanOrEqualToqueryint?No
OpeningBal50GreaterThanqueryint?No
OpeningBal50LessThanqueryint?No
OpeningBal50LessThanOrEqualToqueryint?No
OpeningBal50NotEqualToqueryint?No
OpeningBal50Betweenqueryint[]No
OpeningBal50Inqueryint[]No
OpeningBal51queryint?No
OpeningBal51GreaterThanOrEqualToqueryint?No
OpeningBal51GreaterThanqueryint?No
OpeningBal51LessThanqueryint?No
OpeningBal51LessThanOrEqualToqueryint?No
OpeningBal51NotEqualToqueryint?No
OpeningBal51Betweenqueryint[]No
OpeningBal51Inqueryint[]No
OpeningBal52queryint?No
OpeningBal52GreaterThanOrEqualToqueryint?No
OpeningBal52GreaterThanqueryint?No
OpeningBal52LessThanqueryint?No
OpeningBal52LessThanOrEqualToqueryint?No
OpeningBal52NotEqualToqueryint?No
OpeningBal52Betweenqueryint[]No
OpeningBal52Inqueryint[]No
OpeningBal53queryint?No
OpeningBal53GreaterThanOrEqualToqueryint?No
OpeningBal53GreaterThanqueryint?No
OpeningBal53LessThanqueryint?No
OpeningBal53LessThanOrEqualToqueryint?No
OpeningBal53NotEqualToqueryint?No
OpeningBal53Betweenqueryint[]No
OpeningBal53Inqueryint[]No
PeriodTypequeryshort?No
PeriodTypeGreaterThanOrEqualToqueryshort?No
PeriodTypeGreaterThanqueryshort?No
PeriodTypeLessThanqueryshort?No
PeriodTypeLessThanOrEqualToqueryshort?No
PeriodTypeNotEqualToqueryshort?No
PeriodTypeBetweenqueryNullable<Int16>[]No
PeriodTypeInqueryNullable<Int16>[]No
TermsDaysqueryshort?No
TermsDaysGreaterThanOrEqualToqueryshort?No
TermsDaysGreaterThanqueryshort?No
TermsDaysLessThanqueryshort?No
TermsDaysLessThanOrEqualToqueryshort?No
TermsDaysNotEqualToqueryshort?No
TermsDaysBetweenqueryNullable<Int16>[]No
TermsDaysInqueryNullable<Int16>[]No
TermsTypequeryshort?No
TermsTypeGreaterThanOrEqualToqueryshort?No
TermsTypeGreaterThanqueryshort?No
TermsTypeLessThanqueryshort?No
TermsTypeLessThanOrEqualToqueryshort?No
TermsTypeNotEqualToqueryshort?No
TermsTypeBetweenqueryNullable<Int16>[]No
TermsTypeInqueryNullable<Int16>[]No
ABNquerystringNo
ABNStartsWithquerystringNo
ABNEndsWithquerystringNo
ABNContainsquerystringNo
ABNLikequerystringNo
ABNBetweenquerystring[]No
ABNInquerystring[]No
ExcludeFromAgingquerybool?No
BPayReferencequerystringNo
BPayReferenceStartsWithquerystringNo
BPayReferenceEndsWithquerystringNo
BPayReferenceContainsquerystringNo
BPayReferenceLikequerystringNo
BPayReferenceBetweenquerystring[]No
BPayReferenceInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
DB_Main2 Parameters:
NameParameterData TypeRequiredDescription
DebtorIDformstringNo
LastSavedDateTimeformDateTime?No
TradingNameformstringNo
CompanyNameformstringNo
ACNformstringNo
ProprietorsNameformstringNo
FaxHeaderformstringNo
D1formstringNo
D2formstringNo
D3formstringNo
D4formstringNo
D5formstringNo
D6formstringNo
D7formstringNo
D8formstringNo
D9formstringNo
D10formstringNo
D11formstringNo
OpeningBal1formintNo
OpeningBal2formintNo
OpeningBal3formintNo
OpeningBal4formintNo
OpeningBal5formintNo
OpeningBal6formintNo
OpeningBal7formintNo
OpeningBal8formintNo
OpeningBal9formintNo
OpeningBal10formintNo
OpeningBal11formintNo
OpeningBal12formintNo
OpeningBal13formintNo
OpeningBal14formintNo
OpeningBal15formintNo
OpeningBal16formintNo
OpeningBal17formintNo
OpeningBal18formintNo
OpeningBal19formintNo
OpeningBal20formintNo
OpeningBal21formintNo
OpeningBal22formintNo
OpeningBal23formintNo
OpeningBal24formintNo
OpeningBal25formintNo
OpeningBal26formintNo
OpeningBal27formintNo
OpeningBal28formintNo
OpeningBal29formintNo
OpeningBal30formintNo
OpeningBal31formintNo
OpeningBal32formintNo
OpeningBal33formintNo
OpeningBal34formintNo
OpeningBal35formintNo
OpeningBal36formintNo
OpeningBal37formintNo
OpeningBal38formintNo
OpeningBal39formintNo
OpeningBal40formintNo
OpeningBal41formintNo
OpeningBal42formintNo
OpeningBal43formintNo
OpeningBal44formintNo
OpeningBal45formintNo
OpeningBal46formintNo
OpeningBal47formintNo
OpeningBal48formintNo
OpeningBal49formintNo
OpeningBal50formintNo
OpeningBal51formintNo
OpeningBal52formintNo
OpeningBal53formintNo
PeriodTypeformshort?No
TermsDaysformshort?No
TermsTypeformshort?No
ABNformstringNo
ExcludeFromAgingformboolNo
BPayReferenceformstringNo
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/DB_Main2Query 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"],"TradingName":"String","TradingNameStartsWith":"String","TradingNameEndsWith":"String","TradingNameContains":"String","TradingNameLike":"String","TradingNameBetween":["String"],"TradingNameIn":["String"],"CompanyName":"String","CompanyNameStartsWith":"String","CompanyNameEndsWith":"String","CompanyNameContains":"String","CompanyNameLike":"String","CompanyNameBetween":["String"],"CompanyNameIn":["String"],"ACN":"String","ACNStartsWith":"String","ACNEndsWith":"String","ACNContains":"String","ACNLike":"String","ACNBetween":["String"],"ACNIn":["String"],"ProprietorsName":"String","ProprietorsNameStartsWith":"String","ProprietorsNameEndsWith":"String","ProprietorsNameContains":"String","ProprietorsNameLike":"String","ProprietorsNameBetween":["String"],"ProprietorsNameIn":["String"],"FaxHeader":"String","FaxHeaderStartsWith":"String","FaxHeaderEndsWith":"String","FaxHeaderContains":"String","FaxHeaderLike":"String","FaxHeaderBetween":["String"],"FaxHeaderIn":["String"],"D1":"String","D1StartsWith":"String","D1EndsWith":"String","D1Contains":"String","D1Like":"String","D1Between":["String"],"D1In":["String"],"D2":"String","D2StartsWith":"String","D2EndsWith":"String","D2Contains":"String","D2Like":"String","D2Between":["String"],"D2In":["String"],"D3":"String","D3StartsWith":"String","D3EndsWith":"String","D3Contains":"String","D3Like":"String","D3Between":["String"],"D3In":["String"],"D4":"String","D4StartsWith":"String","D4EndsWith":"String","D4Contains":"String","D4Like":"String","D4Between":["String"],"D4In":["String"],"D5":"String","D5StartsWith":"String","D5EndsWith":"String","D5Contains":"String","D5Like":"String","D5Between":["String"],"D5In":["String"],"D6":"String","D6StartsWith":"String","D6EndsWith":"String","D6Contains":"String","D6Like":"String","D6Between":["String"],"D6In":["String"],"D7":"String","D7StartsWith":"String","D7EndsWith":"String","D7Contains":"String","D7Like":"String","D7Between":["String"],"D7In":["String"],"D8":"String","D8StartsWith":"String","D8EndsWith":"String","D8Contains":"String","D8Like":"String","D8Between":["String"],"D8In":["String"],"D9":"String","D9StartsWith":"String","D9EndsWith":"String","D9Contains":"String","D9Like":"String","D9Between":["String"],"D9In":["String"],"D10":"String","D10StartsWith":"String","D10EndsWith":"String","D10Contains":"String","D10Like":"String","D10Between":["String"],"D10In":["String"],"D11":"String","D11StartsWith":"String","D11EndsWith":"String","D11Contains":"String","D11Like":"String","D11Between":["String"],"D11In":["String"],"OpeningBal1":0,"OpeningBal1GreaterThanOrEqualTo":0,"OpeningBal1GreaterThan":0,"OpeningBal1LessThan":0,"OpeningBal1LessThanOrEqualTo":0,"OpeningBal1NotEqualTo":0,"OpeningBal1Between":[0],"OpeningBal1In":[0],"OpeningBal2":0,"OpeningBal2GreaterThanOrEqualTo":0,"OpeningBal2GreaterThan":0,"OpeningBal2LessThan":0,"OpeningBal2LessThanOrEqualTo":0,"OpeningBal2NotEqualTo":0,"OpeningBal2Between":[0],"OpeningBal2In":[0],"OpeningBal3":0,"OpeningBal3GreaterThanOrEqualTo":0,"OpeningBal3GreaterThan":0,"OpeningBal3LessThan":0,"OpeningBal3LessThanOrEqualTo":0,"OpeningBal3NotEqualTo":0,"OpeningBal3Between":[0],"OpeningBal3In":[0],"OpeningBal4":0,"OpeningBal4GreaterThanOrEqualTo":0,"OpeningBal4GreaterThan":0,"OpeningBal4LessThan":0,"OpeningBal4LessThanOrEqualTo":0,"OpeningBal4NotEqualTo":0,"OpeningBal4Between":[0],"OpeningBal4In":[0],"OpeningBal5":0,"OpeningBal5GreaterThanOrEqualTo":0,"OpeningBal5GreaterThan":0,"OpeningBal5LessThan":0,"OpeningBal5LessThanOrEqualTo":0,"OpeningBal5NotEqualTo":0,"OpeningBal5Between":[0],"OpeningBal5In":[0],"OpeningBal6":0,"OpeningBal6GreaterThanOrEqualTo":0,"OpeningBal6GreaterThan":0,"OpeningBal6LessThan":0,"OpeningBal6LessThanOrEqualTo":0,"OpeningBal6NotEqualTo":0,"OpeningBal6Between":[0],"OpeningBal6In":[0],"OpeningBal7":0,"OpeningBal7GreaterThanOrEqualTo":0,"OpeningBal7GreaterThan":0,"OpeningBal7LessThan":0,"OpeningBal7LessThanOrEqualTo":0,"OpeningBal7NotEqualTo":0,"OpeningBal7Between":[0],"OpeningBal7In":[0],"OpeningBal8":0,"OpeningBal8GreaterThanOrEqualTo":0,"OpeningBal8GreaterThan":0,"OpeningBal8LessThan":0,"OpeningBal8LessThanOrEqualTo":0,"OpeningBal8NotEqualTo":0,"OpeningBal8Between":[0],"OpeningBal8In":[0],"OpeningBal9":0,"OpeningBal9GreaterThanOrEqualTo":0,"OpeningBal9GreaterThan":0,"OpeningBal9LessThan":0,"OpeningBal9LessThanOrEqualTo":0,"OpeningBal9NotEqualTo":0,"OpeningBal9Between":[0],"OpeningBal9In":[0],"OpeningBal10":0,"OpeningBal10GreaterThanOrEqualTo":0,"OpeningBal10GreaterThan":0,"OpeningBal10LessThan":0,"OpeningBal10LessThanOrEqualTo":0,"OpeningBal10NotEqualTo":0,"OpeningBal10Between":[0],"OpeningBal10In":[0],"OpeningBal11":0,"OpeningBal11GreaterThanOrEqualTo":0,"OpeningBal11GreaterThan":0,"OpeningBal11LessThan":0,"OpeningBal11LessThanOrEqualTo":0,"OpeningBal11NotEqualTo":0,"OpeningBal11Between":[0],"OpeningBal11In":[0],"OpeningBal12":0,"OpeningBal12GreaterThanOrEqualTo":0,"OpeningBal12GreaterThan":0,"OpeningBal12LessThan":0,"OpeningBal12LessThanOrEqualTo":0,"OpeningBal12NotEqualTo":0,"OpeningBal12Between":[0],"OpeningBal12In":[0],"OpeningBal13":0,"OpeningBal13GreaterThanOrEqualTo":0,"OpeningBal13GreaterThan":0,"OpeningBal13LessThan":0,"OpeningBal13LessThanOrEqualTo":0,"OpeningBal13NotEqualTo":0,"OpeningBal13Between":[0],"OpeningBal13In":[0],"OpeningBal14":0,"OpeningBal14GreaterThanOrEqualTo":0,"OpeningBal14GreaterThan":0,"OpeningBal14LessThan":0,"OpeningBal14LessThanOrEqualTo":0,"OpeningBal14NotEqualTo":0,"OpeningBal14Between":[0],"OpeningBal14In":[0],"OpeningBal15":0,"OpeningBal15GreaterThanOrEqualTo":0,"OpeningBal15GreaterThan":0,"OpeningBal15LessThan":0,"OpeningBal15LessThanOrEqualTo":0,"OpeningBal15NotEqualTo":0,"OpeningBal15Between":[0],"OpeningBal15In":[0],"OpeningBal16":0,"OpeningBal16GreaterThanOrEqualTo":0,"OpeningBal16GreaterThan":0,"OpeningBal16LessThan":0,"OpeningBal16LessThanOrEqualTo":0,"OpeningBal16NotEqualTo":0,"OpeningBal16Between":[0],"OpeningBal16In":[0],"OpeningBal17":0,"OpeningBal17GreaterThanOrEqualTo":0,"OpeningBal17GreaterThan":0,"OpeningBal17LessThan":0,"OpeningBal17LessThanOrEqualTo":0,"OpeningBal17NotEqualTo":0,"OpeningBal17Between":[0],"OpeningBal17In":[0],"OpeningBal18":0,"OpeningBal18GreaterThanOrEqualTo":0,"OpeningBal18GreaterThan":0,"OpeningBal18LessThan":0,"OpeningBal18LessThanOrEqualTo":0,"OpeningBal18NotEqualTo":0,"OpeningBal18Between":[0],"OpeningBal18In":[0],"OpeningBal19":0,"OpeningBal19GreaterThanOrEqualTo":0,"OpeningBal19GreaterThan":0,"OpeningBal19LessThan":0,"OpeningBal19LessThanOrEqualTo":0,"OpeningBal19NotEqualTo":0,"OpeningBal19Between":[0],"OpeningBal19In":[0],"OpeningBal20":0,"OpeningBal20GreaterThanOrEqualTo":0,"OpeningBal20GreaterThan":0,"OpeningBal20LessThan":0,"OpeningBal20LessThanOrEqualTo":0,"OpeningBal20NotEqualTo":0,"OpeningBal20Between":[0],"OpeningBal20In":[0],"OpeningBal21":0,"OpeningBal21GreaterThanOrEqualTo":0,"OpeningBal21GreaterThan":0,"OpeningBal21LessThan":0,"OpeningBal21LessThanOrEqualTo":0,"OpeningBal21NotEqualTo":0,"OpeningBal21Between":[0],"OpeningBal21In":[0],"OpeningBal22":0,"OpeningBal22GreaterThanOrEqualTo":0,"OpeningBal22GreaterThan":0,"OpeningBal22LessThan":0,"OpeningBal22LessThanOrEqualTo":0,"OpeningBal22NotEqualTo":0,"OpeningBal22Between":[0],"OpeningBal22In":[0],"OpeningBal23":0,"OpeningBal23GreaterThanOrEqualTo":0,"OpeningBal23GreaterThan":0,"OpeningBal23LessThan":0,"OpeningBal23LessThanOrEqualTo":0,"OpeningBal23NotEqualTo":0,"OpeningBal23Between":[0],"OpeningBal23In":[0],"OpeningBal24":0,"OpeningBal24GreaterThanOrEqualTo":0,"OpeningBal24GreaterThan":0,"OpeningBal24LessThan":0,"OpeningBal24LessThanOrEqualTo":0,"OpeningBal24NotEqualTo":0,"OpeningBal24Between":[0],"OpeningBal24In":[0],"OpeningBal25":0,"OpeningBal25GreaterThanOrEqualTo":0,"OpeningBal25GreaterThan":0,"OpeningBal25LessThan":0,"OpeningBal25LessThanOrEqualTo":0,"OpeningBal25NotEqualTo":0,"OpeningBal25Between":[0],"OpeningBal25In":[0],"OpeningBal26":0,"OpeningBal26GreaterThanOrEqualTo":0,"OpeningBal26GreaterThan":0,"OpeningBal26LessThan":0,"OpeningBal26LessThanOrEqualTo":0,"OpeningBal26NotEqualTo":0,"OpeningBal26Between":[0],"OpeningBal26In":[0],"OpeningBal27":0,"OpeningBal27GreaterThanOrEqualTo":0,"OpeningBal27GreaterThan":0,"OpeningBal27LessThan":0,"OpeningBal27LessThanOrEqualTo":0,"OpeningBal27NotEqualTo":0,"OpeningBal27Between":[0],"OpeningBal27In":[0],"OpeningBal28":0,"OpeningBal28GreaterThanOrEqualTo":0,"OpeningBal28GreaterThan":0,"OpeningBal28LessThan":0,"OpeningBal28LessThanOrEqualTo":0,"OpeningBal28NotEqualTo":0,"OpeningBal28Between":[0],"OpeningBal28In":[0],"OpeningBal29":0,"OpeningBal29GreaterThanOrEqualTo":0,"OpeningBal29GreaterThan":0,"OpeningBal29LessThan":0,"OpeningBal29LessThanOrEqualTo":0,"OpeningBal29NotEqualTo":0,"OpeningBal29Between":[0],"OpeningBal29In":[0],"OpeningBal30":0,"OpeningBal30GreaterThanOrEqualTo":0,"OpeningBal30GreaterThan":0,"OpeningBal30LessThan":0,"OpeningBal30LessThanOrEqualTo":0,"OpeningBal30NotEqualTo":0,"OpeningBal30Between":[0],"OpeningBal30In":[0],"OpeningBal31":0,"OpeningBal31GreaterThanOrEqualTo":0,"OpeningBal31GreaterThan":0,"OpeningBal31LessThan":0,"OpeningBal31LessThanOrEqualTo":0,"OpeningBal31NotEqualTo":0,"OpeningBal31Between":[0],"OpeningBal31In":[0],"OpeningBal32":0,"OpeningBal32GreaterThanOrEqualTo":0,"OpeningBal32GreaterThan":0,"OpeningBal32LessThan":0,"OpeningBal32LessThanOrEqualTo":0,"OpeningBal32NotEqualTo":0,"OpeningBal32Between":[0],"OpeningBal32In":[0],"OpeningBal33":0,"OpeningBal33GreaterThanOrEqualTo":0,"OpeningBal33GreaterThan":0,"OpeningBal33LessThan":0,"OpeningBal33LessThanOrEqualTo":0,"OpeningBal33NotEqualTo":0,"OpeningBal33Between":[0],"OpeningBal33In":[0],"OpeningBal34":0,"OpeningBal34GreaterThanOrEqualTo":0,"OpeningBal34GreaterThan":0,"OpeningBal34LessThan":0,"OpeningBal34LessThanOrEqualTo":0,"OpeningBal34NotEqualTo":0,"OpeningBal34Between":[0],"OpeningBal34In":[0],"OpeningBal35":0,"OpeningBal35GreaterThanOrEqualTo":0,"OpeningBal35GreaterThan":0,"OpeningBal35LessThan":0,"OpeningBal35LessThanOrEqualTo":0,"OpeningBal35NotEqualTo":0,"OpeningBal35Between":[0],"OpeningBal35In":[0],"OpeningBal36":0,"OpeningBal36GreaterThanOrEqualTo":0,"OpeningBal36GreaterThan":0,"OpeningBal36LessThan":0,"OpeningBal36LessThanOrEqualTo":0,"OpeningBal36NotEqualTo":0,"OpeningBal36Between":[0],"OpeningBal36In":[0],"OpeningBal37":0,"OpeningBal37GreaterThanOrEqualTo":0,"OpeningBal37GreaterThan":0,"OpeningBal37LessThan":0,"OpeningBal37LessThanOrEqualTo":0,"OpeningBal37NotEqualTo":0,"OpeningBal37Between":[0],"OpeningBal37In":[0],"OpeningBal38":0,"OpeningBal38GreaterThanOrEqualTo":0,"OpeningBal38GreaterThan":0,"OpeningBal38LessThan":0,"OpeningBal38LessThanOrEqualTo":0,"OpeningBal38NotEqualTo":0,"OpeningBal38Between":[0],"OpeningBal38In":[0],"OpeningBal39":0,"OpeningBal39GreaterThanOrEqualTo":0,"OpeningBal39GreaterThan":0,"OpeningBal39LessThan":0,"OpeningBal39LessThanOrEqualTo":0,"OpeningBal39NotEqualTo":0,"OpeningBal39Between":[0],"OpeningBal39In":[0],"OpeningBal40":0,"OpeningBal40GreaterThanOrEqualTo":0,"OpeningBal40GreaterThan":0,"OpeningBal40LessThan":0,"OpeningBal40LessThanOrEqualTo":0,"OpeningBal40NotEqualTo":0,"OpeningBal40Between":[0],"OpeningBal40In":[0],"OpeningBal41":0,"OpeningBal41GreaterThanOrEqualTo":0,"OpeningBal41GreaterThan":0,"OpeningBal41LessThan":0,"OpeningBal41LessThanOrEqualTo":0,"OpeningBal41NotEqualTo":0,"OpeningBal41Between":[0],"OpeningBal41In":[0],"OpeningBal42":0,"OpeningBal42GreaterThanOrEqualTo":0,"OpeningBal42GreaterThan":0,"OpeningBal42LessThan":0,"OpeningBal42LessThanOrEqualTo":0,"OpeningBal42NotEqualTo":0,"OpeningBal42Between":[0],"OpeningBal42In":[0],"OpeningBal43":0,"OpeningBal43GreaterThanOrEqualTo":0,"OpeningBal43GreaterThan":0,"OpeningBal43LessThan":0,"OpeningBal43LessThanOrEqualTo":0,"OpeningBal43NotEqualTo":0,"OpeningBal43Between":[0],"OpeningBal43In":[0],"OpeningBal44":0,"OpeningBal44GreaterThanOrEqualTo":0,"OpeningBal44GreaterThan":0,"OpeningBal44LessThan":0,"OpeningBal44LessThanOrEqualTo":0,"OpeningBal44NotEqualTo":0,"OpeningBal44Between":[0],"OpeningBal44In":[0],"OpeningBal45":0,"OpeningBal45GreaterThanOrEqualTo":0,"OpeningBal45GreaterThan":0,"OpeningBal45LessThan":0,"OpeningBal45LessThanOrEqualTo":0,"OpeningBal45NotEqualTo":0,"OpeningBal45Between":[0],"OpeningBal45In":[0],"OpeningBal46":0,"OpeningBal46GreaterThanOrEqualTo":0,"OpeningBal46GreaterThan":0,"OpeningBal46LessThan":0,"OpeningBal46LessThanOrEqualTo":0,"OpeningBal46NotEqualTo":0,"OpeningBal46Between":[0],"OpeningBal46In":[0],"OpeningBal47":0,"OpeningBal47GreaterThanOrEqualTo":0,"OpeningBal47GreaterThan":0,"OpeningBal47LessThan":0,"OpeningBal47LessThanOrEqualTo":0,"OpeningBal47NotEqualTo":0,"OpeningBal47Between":[0],"OpeningBal47In":[0],"OpeningBal48":0,"OpeningBal48GreaterThanOrEqualTo":0,"OpeningBal48GreaterThan":0,"OpeningBal48LessThan":0,"OpeningBal48LessThanOrEqualTo":0,"OpeningBal48NotEqualTo":0,"OpeningBal48Between":[0],"OpeningBal48In":[0],"OpeningBal49":0,"OpeningBal49GreaterThanOrEqualTo":0,"OpeningBal49GreaterThan":0,"OpeningBal49LessThan":0,"OpeningBal49LessThanOrEqualTo":0,"OpeningBal49NotEqualTo":0,"OpeningBal49Between":[0],"OpeningBal49In":[0],"OpeningBal50":0,"OpeningBal50GreaterThanOrEqualTo":0,"OpeningBal50GreaterThan":0,"OpeningBal50LessThan":0,"OpeningBal50LessThanOrEqualTo":0,"OpeningBal50NotEqualTo":0,"OpeningBal50Between":[0],"OpeningBal50In":[0],"OpeningBal51":0,"OpeningBal51GreaterThanOrEqualTo":0,"OpeningBal51GreaterThan":0,"OpeningBal51LessThan":0,"OpeningBal51LessThanOrEqualTo":0,"OpeningBal51NotEqualTo":0,"OpeningBal51Between":[0],"OpeningBal51In":[0],"OpeningBal52":0,"OpeningBal52GreaterThanOrEqualTo":0,"OpeningBal52GreaterThan":0,"OpeningBal52LessThan":0,"OpeningBal52LessThanOrEqualTo":0,"OpeningBal52NotEqualTo":0,"OpeningBal52Between":[0],"OpeningBal52In":[0],"OpeningBal53":0,"OpeningBal53GreaterThanOrEqualTo":0,"OpeningBal53GreaterThan":0,"OpeningBal53LessThan":0,"OpeningBal53LessThanOrEqualTo":0,"OpeningBal53NotEqualTo":0,"OpeningBal53Between":[0],"OpeningBal53In":[0],"PeriodType":0,"PeriodTypeGreaterThanOrEqualTo":0,"PeriodTypeGreaterThan":0,"PeriodTypeLessThan":0,"PeriodTypeLessThanOrEqualTo":0,"PeriodTypeNotEqualTo":0,"PeriodTypeBetween":[0],"PeriodTypeIn":[0],"TermsDays":0,"TermsDaysGreaterThanOrEqualTo":0,"TermsDaysGreaterThan":0,"TermsDaysLessThan":0,"TermsDaysLessThanOrEqualTo":0,"TermsDaysNotEqualTo":0,"TermsDaysBetween":[0],"TermsDaysIn":[0],"TermsType":0,"TermsTypeGreaterThanOrEqualTo":0,"TermsTypeGreaterThan":0,"TermsTypeLessThan":0,"TermsTypeLessThanOrEqualTo":0,"TermsTypeNotEqualTo":0,"TermsTypeBetween":[0],"TermsTypeIn":[0],"ABN":"String","ABNStartsWith":"String","ABNEndsWith":"String","ABNContains":"String","ABNLike":"String","ABNBetween":["String"],"ABNIn":["String"],"ExcludeFromAging":false,"BPayReference":"String","BPayReferenceStartsWith":"String","BPayReferenceEndsWith":"String","BPayReferenceContains":"String","BPayReferenceLike":"String","BPayReferenceBetween":["String"],"BPayReferenceIn":["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","TradingName":"String","CompanyName":"String","ACN":"String","ProprietorsName":"String","FaxHeader":"String","D1":"String","D2":"String","D3":"String","D4":"String","D5":"String","D6":"String","D7":"String","D8":"String","D9":"String","D10":"String","D11":"String","PeriodType":0,"TermsDays":0,"TermsType":0,"ABN":"String","BPayReference":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}