JiwaAPI

<back to all web services

QO_EmailLogQuery

Requires Authentication
QO_EmailLogQuery Parameters:
NameParameterData TypeRequiredDescription
EmailLogIDquerystringNo
EmailLogIDStartsWithquerystringNo
EmailLogIDEndsWithquerystringNo
EmailLogIDContainsquerystringNo
EmailLogIDLikequerystringNo
EmailLogIDBetweenquerystring[]No
EmailLogIDInquerystring[]No
InvoiceHistoryIDquerystringNo
InvoiceHistoryIDStartsWithquerystringNo
InvoiceHistoryIDEndsWithquerystringNo
InvoiceHistoryIDContainsquerystringNo
InvoiceHistoryIDLikequerystringNo
InvoiceHistoryIDBetweenquerystring[]No
InvoiceHistoryIDInquerystring[]No
EmailDateTimequeryDateTime?No
EmailDateTimeGreaterThanOrEqualToqueryDateTime?No
EmailDateTimeGreaterThanqueryDateTime?No
EmailDateTimeLessThanqueryDateTime?No
EmailDateTimeLessThanOrEqualToqueryDateTime?No
EmailDateTimeNotEqualToqueryDateTime?No
EmailDateTimeBetweenqueryDateTime[]No
EmailDateTimeInqueryDateTime[]No
FromquerystringNo
FromStartsWithquerystringNo
FromEndsWithquerystringNo
FromContainsquerystringNo
FromLikequerystringNo
FromBetweenquerystring[]No
FromInquerystring[]No
ToquerystringNo
ToStartsWithquerystringNo
ToEndsWithquerystringNo
ToContainsquerystringNo
ToLikequerystringNo
ToBetweenquerystring[]No
ToInquerystring[]No
CCquerystringNo
CCStartsWithquerystringNo
CCEndsWithquerystringNo
CCContainsquerystringNo
CCLikequerystringNo
CCBetweenquerystring[]No
CCInquerystring[]No
BCCquerystringNo
BCCStartsWithquerystringNo
BCCEndsWithquerystringNo
BCCContainsquerystringNo
BCCLikequerystringNo
BCCBetweenquerystring[]No
BCCInquerystring[]No
AttachmentsquerystringNo
AttachmentsStartsWithquerystringNo
AttachmentsEndsWithquerystringNo
AttachmentsContainsquerystringNo
AttachmentsLikequerystringNo
AttachmentsBetweenquerystring[]No
AttachmentsInquerystring[]No
FileIDquerystringNo
FileIDStartsWithquerystringNo
FileIDEndsWithquerystringNo
FileIDContainsquerystringNo
FileIDLikequerystringNo
FileIDBetweenquerystring[]No
FileIDInquerystring[]No
SubjectquerystringNo
SubjectStartsWithquerystringNo
SubjectEndsWithquerystringNo
SubjectContainsquerystringNo
SubjectLikequerystringNo
SubjectBetweenquerystring[]No
SubjectInquerystring[]No
BodyquerystringNo
BodyStartsWithquerystringNo
BodyEndsWithquerystringNo
BodyContainsquerystringNo
BodyLikequerystringNo
BodyBetweenquerystring[]No
BodyInquerystring[]No
InvoiceIDquerystringNo
InvoiceIDStartsWithquerystringNo
InvoiceIDEndsWithquerystringNo
InvoiceIDContainsquerystringNo
InvoiceIDLikequerystringNo
InvoiceIDBetweenquerystring[]No
InvoiceIDInquerystring[]No
StaffIDquerystringNo
StaffIDStartsWithquerystringNo
StaffIDEndsWithquerystringNo
StaffIDContainsquerystringNo
StaffIDLikequerystringNo
StaffIDBetweenquerystring[]No
StaffIDInquerystring[]No
EM_Main_RecIDquerystringNo
EM_Main_RecIDStartsWithquerystringNo
EM_Main_RecIDEndsWithquerystringNo
EM_Main_RecIDContainsquerystringNo
EM_Main_RecIDLikequerystringNo
EM_Main_RecIDBetweenquerystring[]No
EM_Main_RecIDInquerystring[]No
RequestReadReceiptquerybool?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
QO_EmailLog Parameters:
NameParameterData TypeRequiredDescription
EmailLogIDformstringNo
InvoiceHistoryIDformstringNo
EmailDateTimeformDateTimeNo
FromformstringNo
ToformstringNo
CCformstringNo
BCCformstringNo
AttachmentsformstringNo
FileIDformstringNo
SubjectformstringNo
BodyformstringNo
InvoiceIDformstringNo
StaffIDformstringNo
EM_Main_RecIDformstringNo
RequestReadReceiptformbool?No
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/QO_EmailLogQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"EmailLogID":"String","EmailLogIDStartsWith":"String","EmailLogIDEndsWith":"String","EmailLogIDContains":"String","EmailLogIDLike":"String","EmailLogIDBetween":["String"],"EmailLogIDIn":["String"],"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["String"],"EmailDateTime":"0001-01-01T00:00:00.0000000","EmailDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","EmailDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","EmailDateTimeLessThan":"0001-01-01T00:00:00.0000000","EmailDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","EmailDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","EmailDateTimeBetween":["0001-01-01T00:00:00.0000000"],"EmailDateTimeIn":["0001-01-01T00:00:00.0000000"],"From":"String","FromStartsWith":"String","FromEndsWith":"String","FromContains":"String","FromLike":"String","FromBetween":["String"],"FromIn":["String"],"To":"String","ToStartsWith":"String","ToEndsWith":"String","ToContains":"String","ToLike":"String","ToBetween":["String"],"ToIn":["String"],"CC":"String","CCStartsWith":"String","CCEndsWith":"String","CCContains":"String","CCLike":"String","CCBetween":["String"],"CCIn":["String"],"BCC":"String","BCCStartsWith":"String","BCCEndsWith":"String","BCCContains":"String","BCCLike":"String","BCCBetween":["String"],"BCCIn":["String"],"Attachments":"String","AttachmentsStartsWith":"String","AttachmentsEndsWith":"String","AttachmentsContains":"String","AttachmentsLike":"String","AttachmentsBetween":["String"],"AttachmentsIn":["String"],"FileID":"String","FileIDStartsWith":"String","FileIDEndsWith":"String","FileIDContains":"String","FileIDLike":"String","FileIDBetween":["String"],"FileIDIn":["String"],"Subject":"String","SubjectStartsWith":"String","SubjectEndsWith":"String","SubjectContains":"String","SubjectLike":"String","SubjectBetween":["String"],"SubjectIn":["String"],"Body":"String","BodyStartsWith":"String","BodyEndsWith":"String","BodyContains":"String","BodyLike":"String","BodyBetween":["String"],"BodyIn":["String"],"InvoiceID":"String","InvoiceIDStartsWith":"String","InvoiceIDEndsWith":"String","InvoiceIDContains":"String","InvoiceIDLike":"String","InvoiceIDBetween":["String"],"InvoiceIDIn":["String"],"StaffID":"String","StaffIDStartsWith":"String","StaffIDEndsWith":"String","StaffIDContains":"String","StaffIDLike":"String","StaffIDBetween":["String"],"StaffIDIn":["String"],"EM_Main_RecID":"String","EM_Main_RecIDStartsWith":"String","EM_Main_RecIDEndsWith":"String","EM_Main_RecIDContains":"String","EM_Main_RecIDLike":"String","EM_Main_RecIDBetween":["String"],"EM_Main_RecIDIn":["String"],"RequestReadReceipt":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":[{"EmailLogID":"String","InvoiceHistoryID":"String","From":"String","To":"String","CC":"String","BCC":"String","Attachments":"String","FileID":"String","Subject":"String","Body":"String","InvoiceID":"String","StaffID":"String","EM_Main_RecID":"String","RequestReadReceipt":false}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}