| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| CreditorClassificationID | query | string | No | |
| CreditorClassificationIDStartsWith | query | string | No | |
| CreditorClassificationIDEndsWith | query | string | No | |
| CreditorClassificationIDContains | query | string | No | |
| CreditorClassificationIDLike | query | string | No | |
| CreditorClassificationIDBetween | query | string[] | No | |
| CreditorClassificationIDIn | 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 | |
| Description | query | string | No | |
| DescriptionStartsWith | query | string | No | |
| DescriptionEndsWith | query | string | No | |
| DescriptionContains | query | string | No | |
| DescriptionLike | query | string | No | |
| DescriptionBetween | query | string[] | No | |
| DescriptionIn | query | string[] | No | |
| LedgerIDCreditorControl | query | string | No | |
| LedgerIDCreditorControlStartsWith | query | string | No | |
| LedgerIDCreditorControlEndsWith | query | string | No | |
| LedgerIDCreditorControlContains | query | string | No | |
| LedgerIDCreditorControlLike | query | string | No | |
| LedgerIDCreditorControlBetween | query | string[] | No | |
| LedgerIDCreditorControlIn | query | string[] | No | |
| LedgerIDCreditorPurchases | query | string | No | |
| LedgerIDCreditorPurchasesStartsWith | query | string | No | |
| LedgerIDCreditorPurchasesEndsWith | query | string | No | |
| LedgerIDCreditorPurchasesContains | query | string | No | |
| LedgerIDCreditorPurchasesLike | query | string | No | |
| LedgerIDCreditorPurchasesBetween | query | string[] | No | |
| LedgerIDCreditorPurchasesIn | query | string[] | No | |
| LedgerIDCreditorDiscounts | query | string | No | |
| LedgerIDCreditorDiscountsStartsWith | query | string | No | |
| LedgerIDCreditorDiscountsEndsWith | query | string | No | |
| LedgerIDCreditorDiscountsContains | query | string | No | |
| LedgerIDCreditorDiscountsLike | query | string | No | |
| LedgerIDCreditorDiscountsBetween | query | string[] | No | |
| LedgerIDCreditorDiscountsIn | query | string[] | No | |
| LedgerIDCreditorSourcedPayments | query | string | No | |
| LedgerIDCreditorSourcedPaymentsStartsWith | query | string | No | |
| LedgerIDCreditorSourcedPaymentsEndsWith | query | string | No | |
| LedgerIDCreditorSourcedPaymentsContains | query | string | No | |
| LedgerIDCreditorSourcedPaymentsLike | query | string | No | |
| LedgerIDCreditorSourcedPaymentsBetween | query | string[] | No | |
| LedgerIDCreditorSourcedPaymentsIn | query | string[] | No | |
| LedgerIDCreditorSourcedDebitAdjustment | query | string | No | |
| LedgerIDCreditorSourcedDebitAdjustmentStartsWith | query | string | No | |
| LedgerIDCreditorSourcedDebitAdjustmentEndsWith | query | string | No | |
| LedgerIDCreditorSourcedDebitAdjustmentContains | query | string | No | |
| LedgerIDCreditorSourcedDebitAdjustmentLike | query | string | No | |
| LedgerIDCreditorSourcedDebitAdjustmentBetween | query | string[] | No | |
| LedgerIDCreditorSourcedDebitAdjustmentIn | query | string[] | No | |
| LedgerIDCreditorSourcedPurchase | query | string | No | |
| LedgerIDCreditorSourcedPurchaseStartsWith | query | string | No | |
| LedgerIDCreditorSourcedPurchaseEndsWith | query | string | No | |
| LedgerIDCreditorSourcedPurchaseContains | query | string | No | |
| LedgerIDCreditorSourcedPurchaseLike | query | string | No | |
| LedgerIDCreditorSourcedPurchaseBetween | query | string[] | No | |
| LedgerIDCreditorSourcedPurchaseIn | query | string[] | No | |
| LedgerIDCreditorSourcedCreditAdjustment | query | string | No | |
| LedgerIDCreditorSourcedCreditAdjustmentStartsWith | query | string | No | |
| LedgerIDCreditorSourcedCreditAdjustmentEndsWith | query | string | No | |
| LedgerIDCreditorSourcedCreditAdjustmentContains | query | string | No | |
| LedgerIDCreditorSourcedCreditAdjustmentLike | query | string | No | |
| LedgerIDCreditorSourcedCreditAdjustmentBetween | query | string[] | No | |
| LedgerIDCreditorSourcedCreditAdjustmentIn | query | string[] | No | |
| LedgerIDCreditorFreight | query | string | No | |
| LedgerIDCreditorFreightStartsWith | query | string | No | |
| LedgerIDCreditorFreightEndsWith | query | string | No | |
| LedgerIDCreditorFreightContains | query | string | No | |
| LedgerIDCreditorFreightLike | query | string | No | |
| LedgerIDCreditorFreightBetween | query | string[] | No | |
| LedgerIDCreditorFreightIn | query | string[] | No | |
| LedgerIDCreditorInsurance | query | string | No | |
| LedgerIDCreditorInsuranceStartsWith | query | string | No | |
| LedgerIDCreditorInsuranceEndsWith | query | string | No | |
| LedgerIDCreditorInsuranceContains | query | string | No | |
| LedgerIDCreditorInsuranceLike | query | string | No | |
| LedgerIDCreditorInsuranceBetween | query | string[] | No | |
| LedgerIDCreditorInsuranceIn | query | string[] | No | |
| LedgerIDCreditorDuty | query | string | No | |
| LedgerIDCreditorDutyStartsWith | query | string | No | |
| LedgerIDCreditorDutyEndsWith | query | string | No | |
| LedgerIDCreditorDutyContains | query | string | No | |
| LedgerIDCreditorDutyLike | query | string | No | |
| LedgerIDCreditorDutyBetween | query | string[] | No | |
| LedgerIDCreditorDutyIn | query | string[] | No | |
| LedgerIDCreditorRealisedGainLoss | query | string | No | |
| LedgerIDCreditorRealisedGainLossStartsWith | query | string | No | |
| LedgerIDCreditorRealisedGainLossEndsWith | query | string | No | |
| LedgerIDCreditorRealisedGainLossContains | query | string | No | |
| LedgerIDCreditorRealisedGainLossLike | query | string | No | |
| LedgerIDCreditorRealisedGainLossBetween | query | string[] | No | |
| LedgerIDCreditorRealisedGainLossIn | query | string[] | No | |
| LedgerIDCreditorUnRealisedGainLoss | query | string | No | |
| LedgerIDCreditorUnRealisedGainLossStartsWith | query | string | No | |
| LedgerIDCreditorUnRealisedGainLossEndsWith | query | string | No | |
| LedgerIDCreditorUnRealisedGainLossContains | query | string | No | |
| LedgerIDCreditorUnRealisedGainLossLike | query | string | No | |
| LedgerIDCreditorUnRealisedGainLossBetween | query | string[] | No | |
| LedgerIDCreditorUnRealisedGainLossIn | query | string[] | No | |
| TermsDays | query | short? | No | |
| TermsDaysGreaterThanOrEqualTo | query | short? | No | |
| TermsDaysGreaterThan | query | short? | No | |
| TermsDaysLessThan | query | short? | No | |
| TermsDaysLessThanOrEqualTo | query | short? | No | |
| TermsDaysNotEqualTo | query | short? | No | |
| TermsDaysBetween | query | Nullable<Int16>[] | No | |
| TermsDaysIn | query | Nullable<Int16>[] | No | |
| TermsType | query | short? | No | |
| TermsTypeGreaterThanOrEqualTo | query | short? | No | |
| TermsTypeGreaterThan | query | short? | No | |
| TermsTypeLessThan | query | short? | No | |
| TermsTypeLessThanOrEqualTo | query | short? | No | |
| TermsTypeNotEqualTo | query | short? | No | |
| TermsTypeBetween | query | short[] | No | |
| TermsTypeIn | query | short[] | No | |
| PO_Workflows_RecID | query | string | No | |
| PO_Workflows_RecIDStartsWith | query | string | No | |
| PO_Workflows_RecIDEndsWith | query | string | No | |
| PO_Workflows_RecIDContains | query | string | No | |
| PO_Workflows_RecIDLike | query | string | No | |
| PO_Workflows_RecIDBetween | query | string[] | No | |
| PO_Workflows_RecIDIn | query | string[] | No | |
| IsDefault | query | bool? | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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 |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| CreditorClassificationID | form | string | No | |
| LastSavedDateTime | form | DateTime? | No | |
| Description | form | string | No | |
| LedgerIDCreditorControl | form | string | No | |
| LedgerIDCreditorPurchases | form | string | No | |
| LedgerIDCreditorDiscounts | form | string | No | |
| LedgerIDCreditorSourcedPayments | form | string | No | |
| LedgerIDCreditorSourcedDebitAdjustment | form | string | No | |
| LedgerIDCreditorSourcedPurchase | form | string | No | |
| LedgerIDCreditorSourcedCreditAdjustment | form | string | No | |
| LedgerIDCreditorFreight | form | string | No | |
| LedgerIDCreditorInsurance | form | string | No | |
| LedgerIDCreditorDuty | form | string | No | |
| LedgerIDCreditorRealisedGainLoss | form | string | No | |
| LedgerIDCreditorUnRealisedGainLoss | form | string | No | |
| TermsDays | form | short? | No | |
| TermsType | form | short | No | |
| PO_Workflows_RecID | form | string | No | |
| IsDefault | form | bool | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /csv/reply/CR_ClassificationQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"CreditorClassificationID":"String","CreditorClassificationIDStartsWith":"String","CreditorClassificationIDEndsWith":"String","CreditorClassificationIDContains":"String","CreditorClassificationIDLike":"String","CreditorClassificationIDBetween":["String"],"CreditorClassificationIDIn":["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"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"LedgerIDCreditorControl":"String","LedgerIDCreditorControlStartsWith":"String","LedgerIDCreditorControlEndsWith":"String","LedgerIDCreditorControlContains":"String","LedgerIDCreditorControlLike":"String","LedgerIDCreditorControlBetween":["String"],"LedgerIDCreditorControlIn":["String"],"LedgerIDCreditorPurchases":"String","LedgerIDCreditorPurchasesStartsWith":"String","LedgerIDCreditorPurchasesEndsWith":"String","LedgerIDCreditorPurchasesContains":"String","LedgerIDCreditorPurchasesLike":"String","LedgerIDCreditorPurchasesBetween":["String"],"LedgerIDCreditorPurchasesIn":["String"],"LedgerIDCreditorDiscounts":"String","LedgerIDCreditorDiscountsStartsWith":"String","LedgerIDCreditorDiscountsEndsWith":"String","LedgerIDCreditorDiscountsContains":"String","LedgerIDCreditorDiscountsLike":"String","LedgerIDCreditorDiscountsBetween":["String"],"LedgerIDCreditorDiscountsIn":["String"],"LedgerIDCreditorSourcedPayments":"String","LedgerIDCreditorSourcedPaymentsStartsWith":"String","LedgerIDCreditorSourcedPaymentsEndsWith":"String","LedgerIDCreditorSourcedPaymentsContains":"String","LedgerIDCreditorSourcedPaymentsLike":"String","LedgerIDCreditorSourcedPaymentsBetween":["String"],"LedgerIDCreditorSourcedPaymentsIn":["String"],"LedgerIDCreditorSourcedDebitAdjustment":"String","LedgerIDCreditorSourcedDebitAdjustmentStartsWith":"String","LedgerIDCreditorSourcedDebitAdjustmentEndsWith":"String","LedgerIDCreditorSourcedDebitAdjustmentContains":"String","LedgerIDCreditorSourcedDebitAdjustmentLike":"String","LedgerIDCreditorSourcedDebitAdjustmentBetween":["String"],"LedgerIDCreditorSourcedDebitAdjustmentIn":["String"],"LedgerIDCreditorSourcedPurchase":"String","LedgerIDCreditorSourcedPurchaseStartsWith":"String","LedgerIDCreditorSourcedPurchaseEndsWith":"String","LedgerIDCreditorSourcedPurchaseContains":"String","LedgerIDCreditorSourcedPurchaseLike":"String","LedgerIDCreditorSourcedPurchaseBetween":["String"],"LedgerIDCreditorSourcedPurchaseIn":["String"],"LedgerIDCreditorSourcedCreditAdjustment":"String","LedgerIDCreditorSourcedCreditAdjustmentStartsWith":"String","LedgerIDCreditorSourcedCreditAdjustmentEndsWith":"String","LedgerIDCreditorSourcedCreditAdjustmentContains":"String","LedgerIDCreditorSourcedCreditAdjustmentLike":"String","LedgerIDCreditorSourcedCreditAdjustmentBetween":["String"],"LedgerIDCreditorSourcedCreditAdjustmentIn":["String"],"LedgerIDCreditorFreight":"String","LedgerIDCreditorFreightStartsWith":"String","LedgerIDCreditorFreightEndsWith":"String","LedgerIDCreditorFreightContains":"String","LedgerIDCreditorFreightLike":"String","LedgerIDCreditorFreightBetween":["String"],"LedgerIDCreditorFreightIn":["String"],"LedgerIDCreditorInsurance":"String","LedgerIDCreditorInsuranceStartsWith":"String","LedgerIDCreditorInsuranceEndsWith":"String","LedgerIDCreditorInsuranceContains":"String","LedgerIDCreditorInsuranceLike":"String","LedgerIDCreditorInsuranceBetween":["String"],"LedgerIDCreditorInsuranceIn":["String"],"LedgerIDCreditorDuty":"String","LedgerIDCreditorDutyStartsWith":"String","LedgerIDCreditorDutyEndsWith":"String","LedgerIDCreditorDutyContains":"String","LedgerIDCreditorDutyLike":"String","LedgerIDCreditorDutyBetween":["String"],"LedgerIDCreditorDutyIn":["String"],"LedgerIDCreditorRealisedGainLoss":"String","LedgerIDCreditorRealisedGainLossStartsWith":"String","LedgerIDCreditorRealisedGainLossEndsWith":"String","LedgerIDCreditorRealisedGainLossContains":"String","LedgerIDCreditorRealisedGainLossLike":"String","LedgerIDCreditorRealisedGainLossBetween":["String"],"LedgerIDCreditorRealisedGainLossIn":["String"],"LedgerIDCreditorUnRealisedGainLoss":"String","LedgerIDCreditorUnRealisedGainLossStartsWith":"String","LedgerIDCreditorUnRealisedGainLossEndsWith":"String","LedgerIDCreditorUnRealisedGainLossContains":"String","LedgerIDCreditorUnRealisedGainLossLike":"String","LedgerIDCreditorUnRealisedGainLossBetween":["String"],"LedgerIDCreditorUnRealisedGainLossIn":["String"],"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],"PO_Workflows_RecID":"String","PO_Workflows_RecIDStartsWith":"String","PO_Workflows_RecIDEndsWith":"String","PO_Workflows_RecIDContains":"String","PO_Workflows_RecIDLike":"String","PO_Workflows_RecIDBetween":["String"],"PO_Workflows_RecIDIn":["String"],"IsDefault":false,"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":[{"CreditorClassificationID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","Description":"String","LedgerIDCreditorControl":"String","LedgerIDCreditorPurchases":"String","LedgerIDCreditorDiscounts":"String","LedgerIDCreditorSourcedPayments":"String","LedgerIDCreditorSourcedDebitAdjustment":"String","LedgerIDCreditorSourcedPurchase":"String","LedgerIDCreditorSourcedCreditAdjustment":"String","LedgerIDCreditorFreight":"String","LedgerIDCreditorInsurance":"String","LedgerIDCreditorDuty":"String","LedgerIDCreditorRealisedGainLoss":"String","LedgerIDCreditorUnRealisedGainLoss":"String","TermsDays":0,"PO_Workflows_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"}}}