| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| GLLedgerID | query | string | No | |
| GLLedgerIDStartsWith | query | string | No | |
| GLLedgerIDEndsWith | query | string | No | |
| GLLedgerIDContains | query | string | No | |
| GLLedgerIDLike | query | string | No | |
| GLLedgerIDBetween | query | string[] | No | |
| GLLedgerIDIn | 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 | |
| GLCategoryID | query | string | No | |
| GLCategoryIDStartsWith | query | string | No | |
| GLCategoryIDEndsWith | query | string | No | |
| GLCategoryIDContains | query | string | No | |
| GLCategoryIDLike | query | string | No | |
| GLCategoryIDBetween | query | string[] | No | |
| GLCategoryIDIn | 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 | |
| Seg1 | query | string | No | |
| Seg1StartsWith | query | string | No | |
| Seg1EndsWith | query | string | No | |
| Seg1Contains | query | string | No | |
| Seg1Like | query | string | No | |
| Seg1Between | query | string[] | No | |
| Seg1In | query | string[] | No | |
| Seg2 | query | string | No | |
| Seg2StartsWith | query | string | No | |
| Seg2EndsWith | query | string | No | |
| Seg2Contains | query | string | No | |
| Seg2Like | query | string | No | |
| Seg2Between | query | string[] | No | |
| Seg2In | query | string[] | No | |
| Seg3 | query | string | No | |
| Seg3StartsWith | query | string | No | |
| Seg3EndsWith | query | string | No | |
| Seg3Contains | query | string | No | |
| Seg3Like | query | string | No | |
| Seg3Between | query | string[] | No | |
| Seg3In | query | string[] | No | |
| Seg4 | query | string | No | |
| Seg4StartsWith | query | string | No | |
| Seg4EndsWith | query | string | No | |
| Seg4Contains | query | string | No | |
| Seg4Like | query | string | No | |
| Seg4Between | query | string[] | No | |
| Seg4In | query | string[] | No | |
| Seg5 | query | string | No | |
| Seg5StartsWith | query | string | No | |
| Seg5EndsWith | query | string | No | |
| Seg5Contains | query | string | No | |
| Seg5Like | query | string | No | |
| Seg5Between | query | string[] | No | |
| Seg5In | query | string[] | No | |
| Seg6 | query | string | No | |
| Seg6StartsWith | query | string | No | |
| Seg6EndsWith | query | string | No | |
| Seg6Contains | query | string | No | |
| Seg6Like | query | string | No | |
| Seg6Between | query | string[] | No | |
| Seg6In | query | string[] | 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 | |
| LastYearOpen | query | decimal? | No | |
| LastYearOpenGreaterThanOrEqualTo | query | decimal? | No | |
| LastYearOpenGreaterThan | query | decimal? | No | |
| LastYearOpenLessThan | query | decimal? | No | |
| LastYearOpenLessThanOrEqualTo | query | decimal? | No | |
| LastYearOpenNotEqualTo | query | decimal? | No | |
| LastYearOpenBetween | query | Nullable<Decimal>[] | No | |
| LastYearOpenIn | query | Nullable<Decimal>[] | No | |
| CurrYearOpen | query | decimal? | No | |
| CurrYearOpenGreaterThanOrEqualTo | query | decimal? | No | |
| CurrYearOpenGreaterThan | query | decimal? | No | |
| CurrYearOpenLessThan | query | decimal? | No | |
| CurrYearOpenLessThanOrEqualTo | query | decimal? | No | |
| CurrYearOpenNotEqualTo | query | decimal? | No | |
| CurrYearOpenBetween | query | Nullable<Decimal>[] | No | |
| CurrYearOpenIn | query | Nullable<Decimal>[] | No | |
| CurrBal | query | decimal? | No | |
| CurrBalGreaterThanOrEqualTo | query | decimal? | No | |
| CurrBalGreaterThan | query | decimal? | No | |
| CurrBalLessThan | query | decimal? | No | |
| CurrBalLessThanOrEqualTo | query | decimal? | No | |
| CurrBalNotEqualTo | query | decimal? | No | |
| CurrBalBetween | query | Nullable<Decimal>[] | No | |
| CurrBalIn | query | Nullable<Decimal>[] | No | |
| ExpSign | query | byte? | No | |
| ExpSignGreaterThanOrEqualTo | query | byte? | No | |
| ExpSignGreaterThan | query | byte? | No | |
| ExpSignLessThan | query | byte? | No | |
| ExpSignLessThanOrEqualTo | query | byte? | No | |
| ExpSignNotEqualTo | query | byte? | No | |
| ExpSignBetween | query | Nullable<Byte>[] | No | |
| ExpSignIn | query | Nullable<Byte>[] | No | |
| AccClass | query | short? | No | |
| AccClassGreaterThanOrEqualTo | query | short? | No | |
| AccClassGreaterThan | query | short? | No | |
| AccClassLessThan | query | short? | No | |
| AccClassLessThanOrEqualTo | query | short? | No | |
| AccClassNotEqualTo | query | short? | No | |
| AccClassBetween | query | short[] | No | |
| AccClassIn | query | short[] | No | |
| DistributionAcc | query | bool? | No | |
| ShortCut | query | string | No | |
| ShortCutStartsWith | query | string | No | |
| ShortCutEndsWith | query | string | No | |
| ShortCutContains | query | string | No | |
| ShortCutLike | query | string | No | |
| ShortCutBetween | query | string[] | No | |
| ShortCutIn | query | string[] | No | |
| PostingAcc | query | short? | No | |
| PostingAccGreaterThanOrEqualTo | query | short? | No | |
| PostingAccGreaterThan | query | short? | No | |
| PostingAccLessThan | query | short? | No | |
| PostingAccLessThanOrEqualTo | query | short? | No | |
| PostingAccNotEqualTo | query | short? | No | |
| PostingAccBetween | query | short[] | No | |
| PostingAccIn | query | short[] | No | |
| ParentAccNo | query | string | No | |
| ParentAccNoStartsWith | query | string | No | |
| ParentAccNoEndsWith | query | string | No | |
| ParentAccNoContains | query | string | No | |
| ParentAccNoLike | query | string | No | |
| ParentAccNoBetween | query | string[] | No | |
| ParentAccNoIn | query | string[] | No | |
| UseTransCode1 | query | bool? | No | |
| UseTransCode2 | query | bool? | No | |
| UseTransCode3 | query | bool? | No | |
| UseStaffCode | query | bool? | No | |
| ClearingAccountID | query | string | No | |
| ClearingAccountIDStartsWith | query | string | No | |
| ClearingAccountIDEndsWith | query | string | No | |
| ClearingAccountIDContains | query | string | No | |
| ClearingAccountIDLike | query | string | No | |
| ClearingAccountIDBetween | query | string[] | No | |
| ClearingAccountIDIn | query | string[] | No | |
| Details | query | string | No | |
| DetailsStartsWith | query | string | No | |
| DetailsEndsWith | query | string | No | |
| DetailsContains | query | string | No | |
| DetailsLike | query | string | No | |
| DetailsBetween | query | string[] | No | |
| DetailsIn | query | string[] | No | |
| IsEnabled | query | bool? | No | |
| AccType | query | byte? | No | |
| AccTypeGreaterThanOrEqualTo | query | byte? | No | |
| AccTypeGreaterThan | query | byte? | No | |
| AccTypeLessThan | query | byte? | No | |
| AccTypeLessThanOrEqualTo | query | byte? | No | |
| AccTypeNotEqualTo | query | byte? | No | |
| AccTypeBetween | query | Nullable<Byte>[] | No | |
| AccTypeIn | query | Nullable<Byte>[] | 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 |
|---|---|---|---|---|
| GLLedgerID | form | string | No | |
| LastSavedDateTime | form | DateTime? | No | |
| GLCategoryID | form | string | No | |
| AccountNo | form | string | No | |
| Seg1 | form | string | No | |
| Seg2 | form | string | No | |
| Seg3 | form | string | No | |
| Seg4 | form | string | No | |
| Seg5 | form | string | No | |
| Seg6 | form | string | No | |
| Description | form | string | No | |
| LastYearOpen | form | decimal? | No | |
| CurrYearOpen | form | decimal? | No | |
| CurrBal | form | decimal? | No | |
| ExpSign | form | byte? | No | |
| AccClass | form | short | No | |
| DistributionAcc | form | bool? | No | |
| ShortCut | form | string | No | |
| PostingAcc | form | short | No | |
| ParentAccNo | form | string | No | |
| UseTransCode1 | form | bool? | No | |
| UseTransCode2 | form | bool? | No | |
| UseTransCode3 | form | bool? | No | |
| UseStaffCode | form | bool? | No | |
| ClearingAccountID | form | string | No | |
| Details | form | string | No | |
| IsEnabled | form | bool? | No | |
| AccType | form | byte? | 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/v_GL_LedgerQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"GLLedgerID":"String","GLLedgerIDStartsWith":"String","GLLedgerIDEndsWith":"String","GLLedgerIDContains":"String","GLLedgerIDLike":"String","GLLedgerIDBetween":["String"],"GLLedgerIDIn":["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"],"GLCategoryID":"String","GLCategoryIDStartsWith":"String","GLCategoryIDEndsWith":"String","GLCategoryIDContains":"String","GLCategoryIDLike":"String","GLCategoryIDBetween":["String"],"GLCategoryIDIn":["String"],"AccountNo":"String","AccountNoStartsWith":"String","AccountNoEndsWith":"String","AccountNoContains":"String","AccountNoLike":"String","AccountNoBetween":["String"],"AccountNoIn":["String"],"Seg1":"String","Seg1StartsWith":"String","Seg1EndsWith":"String","Seg1Contains":"String","Seg1Like":"String","Seg1Between":["String"],"Seg1In":["String"],"Seg2":"String","Seg2StartsWith":"String","Seg2EndsWith":"String","Seg2Contains":"String","Seg2Like":"String","Seg2Between":["String"],"Seg2In":["String"],"Seg3":"String","Seg3StartsWith":"String","Seg3EndsWith":"String","Seg3Contains":"String","Seg3Like":"String","Seg3Between":["String"],"Seg3In":["String"],"Seg4":"String","Seg4StartsWith":"String","Seg4EndsWith":"String","Seg4Contains":"String","Seg4Like":"String","Seg4Between":["String"],"Seg4In":["String"],"Seg5":"String","Seg5StartsWith":"String","Seg5EndsWith":"String","Seg5Contains":"String","Seg5Like":"String","Seg5Between":["String"],"Seg5In":["String"],"Seg6":"String","Seg6StartsWith":"String","Seg6EndsWith":"String","Seg6Contains":"String","Seg6Like":"String","Seg6Between":["String"],"Seg6In":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"LastYearOpen":0,"LastYearOpenGreaterThanOrEqualTo":0,"LastYearOpenGreaterThan":0,"LastYearOpenLessThan":0,"LastYearOpenLessThanOrEqualTo":0,"LastYearOpenNotEqualTo":0,"LastYearOpenBetween":[0],"LastYearOpenIn":[0],"CurrYearOpen":0,"CurrYearOpenGreaterThanOrEqualTo":0,"CurrYearOpenGreaterThan":0,"CurrYearOpenLessThan":0,"CurrYearOpenLessThanOrEqualTo":0,"CurrYearOpenNotEqualTo":0,"CurrYearOpenBetween":[0],"CurrYearOpenIn":[0],"CurrBal":0,"CurrBalGreaterThanOrEqualTo":0,"CurrBalGreaterThan":0,"CurrBalLessThan":0,"CurrBalLessThanOrEqualTo":0,"CurrBalNotEqualTo":0,"CurrBalBetween":[0],"CurrBalIn":[0],"ExpSign":0,"ExpSignGreaterThanOrEqualTo":0,"ExpSignGreaterThan":0,"ExpSignLessThan":0,"ExpSignLessThanOrEqualTo":0,"ExpSignNotEqualTo":0,"ExpSignBetween":[0],"ExpSignIn":[0],"AccClass":0,"AccClassGreaterThanOrEqualTo":0,"AccClassGreaterThan":0,"AccClassLessThan":0,"AccClassLessThanOrEqualTo":0,"AccClassNotEqualTo":0,"AccClassBetween":[0],"AccClassIn":[0],"DistributionAcc":false,"ShortCut":"String","ShortCutStartsWith":"String","ShortCutEndsWith":"String","ShortCutContains":"String","ShortCutLike":"String","ShortCutBetween":["String"],"ShortCutIn":["String"],"PostingAcc":0,"PostingAccGreaterThanOrEqualTo":0,"PostingAccGreaterThan":0,"PostingAccLessThan":0,"PostingAccLessThanOrEqualTo":0,"PostingAccNotEqualTo":0,"PostingAccBetween":[0],"PostingAccIn":[0],"ParentAccNo":"String","ParentAccNoStartsWith":"String","ParentAccNoEndsWith":"String","ParentAccNoContains":"String","ParentAccNoLike":"String","ParentAccNoBetween":["String"],"ParentAccNoIn":["String"],"UseTransCode1":false,"UseTransCode2":false,"UseTransCode3":false,"UseStaffCode":false,"ClearingAccountID":"String","ClearingAccountIDStartsWith":"String","ClearingAccountIDEndsWith":"String","ClearingAccountIDContains":"String","ClearingAccountIDLike":"String","ClearingAccountIDBetween":["String"],"ClearingAccountIDIn":["String"],"Details":"String","DetailsStartsWith":"String","DetailsEndsWith":"String","DetailsContains":"String","DetailsLike":"String","DetailsBetween":["String"],"DetailsIn":["String"],"IsEnabled":false,"AccType":0,"AccTypeGreaterThanOrEqualTo":0,"AccTypeGreaterThan":0,"AccTypeLessThan":0,"AccTypeLessThanOrEqualTo":0,"AccTypeNotEqualTo":0,"AccTypeBetween":[0],"AccTypeIn":[0],"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":[{"GLLedgerID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","GLCategoryID":"String","AccountNo":"String","Seg1":"String","Seg2":"String","Seg3":"String","Seg4":"String","Seg5":"String","Seg6":"String","Description":"String","LastYearOpen":0,"CurrYearOpen":0,"CurrBal":0,"ExpSign":0,"DistributionAcc":false,"ShortCut":"String","ParentAccNo":"String","UseTransCode1":false,"UseTransCode2":false,"UseTransCode3":false,"UseStaffCode":false,"ClearingAccountID":"String","Details":"String","IsEnabled":false,"AccType":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}