JiwaAPI

<back to all web services

DB_AutoTranQuery

Requires Authentication
DB_AutoTranQuery Parameters:
NameParameterData TypeRequiredDescription
DBAutoTranIDquerystringNo
DBAutoTranIDStartsWithquerystringNo
DBAutoTranIDEndsWithquerystringNo
DBAutoTranIDContainsquerystringNo
DBAutoTranIDLikequerystringNo
DBAutoTranIDBetweenquerystring[]No
DBAutoTranIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
RunDateTimequeryDateTime?No
RunDateTimeGreaterThanOrEqualToqueryDateTime?No
RunDateTimeGreaterThanqueryDateTime?No
RunDateTimeLessThanqueryDateTime?No
RunDateTimeLessThanOrEqualToqueryDateTime?No
RunDateTimeNotEqualToqueryDateTime?No
RunDateTimeBetweenqueryNullable<DateTime>[]No
RunDateTimeInqueryNullable<DateTime>[]No
UserNamequerystringNo
UserNameStartsWithquerystringNo
UserNameEndsWithquerystringNo
UserNameContainsquerystringNo
UserNameLikequerystringNo
UserNameBetweenquerystring[]No
UserNameInquerystring[]No
RunNoquerystringNo
RunNoStartsWithquerystringNo
RunNoEndsWithquerystringNo
RunNoContainsquerystringNo
RunNoLikequerystringNo
RunNoBetweenquerystring[]No
RunNoInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
DB_AutoTran Parameters:
NameParameterData TypeRequiredDescription
DBAutoTranIDformstringNo
LastSavedDateTimeformDateTime?No
RunDateTimeformDateTime?No
UserNameformstringNo
RunNoformstringNo
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_AutoTranQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"DBAutoTranID":"String","DBAutoTranIDStartsWith":"String","DBAutoTranIDEndsWith":"String","DBAutoTranIDContains":"String","DBAutoTranIDLike":"String","DBAutoTranIDBetween":["String"],"DBAutoTranIDIn":["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"],"RunDateTime":"0001-01-01T00:00:00.0000000","RunDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","RunDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","RunDateTimeLessThan":"0001-01-01T00:00:00.0000000","RunDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","RunDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","RunDateTimeBetween":["0001-01-01T00:00:00.0000000"],"RunDateTimeIn":["0001-01-01T00:00:00.0000000"],"UserName":"String","UserNameStartsWith":"String","UserNameEndsWith":"String","UserNameContains":"String","UserNameLike":"String","UserNameBetween":["String"],"UserNameIn":["String"],"RunNo":"String","RunNoStartsWith":"String","RunNoEndsWith":"String","RunNoContains":"String","RunNoLike":"String","RunNoBetween":["String"],"RunNoIn":["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":[{"DBAutoTranID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","RunDateTime":"0001-01-01T00:00:00.0000000","UserName":"String","RunNo":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}