JiwaAPI

<back to all web services

v_GL_TransactionsQuery

Requires Authentication
v_GL_TransactionsQuery Parameters:
NameParameterData TypeRequiredDescription
Seg1querystringNo
Seg1StartsWithquerystringNo
Seg1EndsWithquerystringNo
Seg1ContainsquerystringNo
Seg1LikequerystringNo
Seg1Betweenquerystring[]No
Seg1Inquerystring[]No
Seg2querystringNo
Seg2StartsWithquerystringNo
Seg2EndsWithquerystringNo
Seg2ContainsquerystringNo
Seg2LikequerystringNo
Seg2Betweenquerystring[]No
Seg2Inquerystring[]No
Seg3querystringNo
Seg3StartsWithquerystringNo
Seg3EndsWithquerystringNo
Seg3ContainsquerystringNo
Seg3LikequerystringNo
Seg3Betweenquerystring[]No
Seg3Inquerystring[]No
Seg4querystringNo
Seg4StartsWithquerystringNo
Seg4EndsWithquerystringNo
Seg4ContainsquerystringNo
Seg4LikequerystringNo
Seg4Betweenquerystring[]No
Seg4Inquerystring[]No
Seg5querystringNo
Seg5StartsWithquerystringNo
Seg5EndsWithquerystringNo
Seg5ContainsquerystringNo
Seg5LikequerystringNo
Seg5Betweenquerystring[]No
Seg5Inquerystring[]No
Seg6querystringNo
Seg6StartsWithquerystringNo
Seg6EndsWithquerystringNo
Seg6ContainsquerystringNo
Seg6LikequerystringNo
Seg6Betweenquerystring[]No
Seg6Inquerystring[]No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
TransPostDateTimequeryDateTime?No
TransPostDateTimeGreaterThanOrEqualToqueryDateTime?No
TransPostDateTimeGreaterThanqueryDateTime?No
TransPostDateTimeLessThanqueryDateTime?No
TransPostDateTimeLessThanOrEqualToqueryDateTime?No
TransPostDateTimeNotEqualToqueryDateTime?No
TransPostDateTimeBetweenqueryNullable<DateTime>[]No
TransPostDateTimeInqueryNullable<DateTime>[]No
CategoryquerystringNo
CategoryStartsWithquerystringNo
CategoryEndsWithquerystringNo
CategoryContainsquerystringNo
CategoryLikequerystringNo
CategoryBetweenquerystring[]No
CategoryInquerystring[]No
AccountDescriptionquerystringNo
AccountDescriptionStartsWithquerystringNo
AccountDescriptionEndsWithquerystringNo
AccountDescriptionContainsquerystringNo
AccountDescriptionLikequerystringNo
AccountDescriptionBetweenquerystring[]No
AccountDescriptionInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
v_GL_Transactions Parameters:
NameParameterData TypeRequiredDescription
Seg1formstringNo
Seg2formstringNo
Seg3formstringNo
Seg4formstringNo
Seg5formstringNo
Seg6formstringNo
Amountformdecimal?No
TransPostDateTimeformDateTime?No
CategoryformstringNo
AccountDescriptionformstringNo
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/v_GL_TransactionsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"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"],"Amount":0,"AmountGreaterThanOrEqualTo":0,"AmountGreaterThan":0,"AmountLessThan":0,"AmountLessThanOrEqualTo":0,"AmountNotEqualTo":0,"AmountBetween":[0],"AmountIn":[0],"TransPostDateTime":"0001-01-01T00:00:00.0000000","TransPostDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","TransPostDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","TransPostDateTimeLessThan":"0001-01-01T00:00:00.0000000","TransPostDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","TransPostDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","TransPostDateTimeBetween":["0001-01-01T00:00:00.0000000"],"TransPostDateTimeIn":["0001-01-01T00:00:00.0000000"],"Category":"String","CategoryStartsWith":"String","CategoryEndsWith":"String","CategoryContains":"String","CategoryLike":"String","CategoryBetween":["String"],"CategoryIn":["String"],"AccountDescription":"String","AccountDescriptionStartsWith":"String","AccountDescriptionEndsWith":"String","AccountDescriptionContains":"String","AccountDescriptionLike":"String","AccountDescriptionBetween":["String"],"AccountDescriptionIn":["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":[{"Seg1":"String","Seg2":"String","Seg3":"String","Seg4":"String","Seg5":"String","Seg6":"String","Amount":0,"TransPostDateTime":"0001-01-01T00:00:00.0000000","Category":"String","AccountDescription":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}