JiwaAPI

<back to all web services

SO_EmailLogQuery

Requires Authentication
SO_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
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
ReportTypequeryshort?No
ReportTypeGreaterThanOrEqualToqueryshort?No
ReportTypeGreaterThanqueryshort?No
ReportTypeLessThanqueryshort?No
ReportTypeLessThanOrEqualToqueryshort?No
ReportTypeNotEqualToqueryshort?No
ReportTypeBetweenqueryNullable<Int16>[]No
ReportTypeInqueryNullable<Int16>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SO_EmailLog Parameters:
NameParameterData TypeRequiredDescription
EmailLogIDformstringNo
InvoiceHistoryIDformstringNo
EmailDateTimeformDateTimeNo
FromformstringNo
ToformstringNo
CCformstringNo
BCCformstringNo
AttachmentsformstringNo
SubjectformstringNo
BodyformstringNo
InvoiceIDformstringNo
StaffIDformstringNo
EM_Main_RecIDformstringNo
RequestReadReceiptformbool?No
ReportTypeformshort?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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /json/reply/SO_EmailLogQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
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"],"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,"ReportType":0,"ReportTypeGreaterThanOrEqualTo":0,"ReportTypeGreaterThan":0,"ReportTypeLessThan":0,"ReportTypeLessThanOrEqualTo":0,"ReportTypeNotEqualTo":0,"ReportTypeBetween":[0],"ReportTypeIn":[0],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"EmailLogID":"String","InvoiceHistoryID":"String","From":"String","To":"String","CC":"String","BCC":"String","Attachments":"String","Subject":"String","Body":"String","InvoiceID":"String","StaffID":"String","EM_Main_RecID":"String","RequestReadReceipt":false,"ReportType":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}