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 .xml suffix or ?format=xml

HTTP + XML

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

POST /xml/reply/QO_EmailLogQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<QO_EmailLogQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
  <Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
  <Include xmlns="http://schemas.servicestack.net/types">String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
  <OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
  <Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
  <Take xmlns="http://schemas.servicestack.net/types">0</Take>
  <Attachments>String</Attachments>
  <AttachmentsBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AttachmentsBetween>
  <AttachmentsContains>String</AttachmentsContains>
  <AttachmentsEndsWith>String</AttachmentsEndsWith>
  <AttachmentsIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AttachmentsIn>
  <AttachmentsLike>String</AttachmentsLike>
  <AttachmentsStartsWith>String</AttachmentsStartsWith>
  <BCC>String</BCC>
  <BCCBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BCCBetween>
  <BCCContains>String</BCCContains>
  <BCCEndsWith>String</BCCEndsWith>
  <BCCIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BCCIn>
  <BCCLike>String</BCCLike>
  <BCCStartsWith>String</BCCStartsWith>
  <Body>String</Body>
  <BodyBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BodyBetween>
  <BodyContains>String</BodyContains>
  <BodyEndsWith>String</BodyEndsWith>
  <BodyIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BodyIn>
  <BodyLike>String</BodyLike>
  <BodyStartsWith>String</BodyStartsWith>
  <CC>String</CC>
  <CCBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CCBetween>
  <CCContains>String</CCContains>
  <CCEndsWith>String</CCEndsWith>
  <CCIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CCIn>
  <CCLike>String</CCLike>
  <CCStartsWith>String</CCStartsWith>
  <EM_Main_RecID>String</EM_Main_RecID>
  <EM_Main_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EM_Main_RecIDBetween>
  <EM_Main_RecIDContains>String</EM_Main_RecIDContains>
  <EM_Main_RecIDEndsWith>String</EM_Main_RecIDEndsWith>
  <EM_Main_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EM_Main_RecIDIn>
  <EM_Main_RecIDLike>String</EM_Main_RecIDLike>
  <EM_Main_RecIDStartsWith>String</EM_Main_RecIDStartsWith>
  <EmailDateTime>0001-01-01T00:00:00</EmailDateTime>
  <EmailDateTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EmailDateTimeBetween>
  <EmailDateTimeGreaterThan>0001-01-01T00:00:00</EmailDateTimeGreaterThan>
  <EmailDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</EmailDateTimeGreaterThanOrEqualTo>
  <EmailDateTimeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EmailDateTimeIn>
  <EmailDateTimeLessThan>0001-01-01T00:00:00</EmailDateTimeLessThan>
  <EmailDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</EmailDateTimeLessThanOrEqualTo>
  <EmailDateTimeNotEqualTo>0001-01-01T00:00:00</EmailDateTimeNotEqualTo>
  <EmailLogID>String</EmailLogID>
  <EmailLogIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EmailLogIDBetween>
  <EmailLogIDContains>String</EmailLogIDContains>
  <EmailLogIDEndsWith>String</EmailLogIDEndsWith>
  <EmailLogIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EmailLogIDIn>
  <EmailLogIDLike>String</EmailLogIDLike>
  <EmailLogIDStartsWith>String</EmailLogIDStartsWith>
  <FileID>String</FileID>
  <FileIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FileIDBetween>
  <FileIDContains>String</FileIDContains>
  <FileIDEndsWith>String</FileIDEndsWith>
  <FileIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FileIDIn>
  <FileIDLike>String</FileIDLike>
  <FileIDStartsWith>String</FileIDStartsWith>
  <From>String</From>
  <FromBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FromBetween>
  <FromContains>String</FromContains>
  <FromEndsWith>String</FromEndsWith>
  <FromIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FromIn>
  <FromLike>String</FromLike>
  <FromStartsWith>String</FromStartsWith>
  <InvoiceHistoryID>String</InvoiceHistoryID>
  <InvoiceHistoryIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceHistoryIDBetween>
  <InvoiceHistoryIDContains>String</InvoiceHistoryIDContains>
  <InvoiceHistoryIDEndsWith>String</InvoiceHistoryIDEndsWith>
  <InvoiceHistoryIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceHistoryIDIn>
  <InvoiceHistoryIDLike>String</InvoiceHistoryIDLike>
  <InvoiceHistoryIDStartsWith>String</InvoiceHistoryIDStartsWith>
  <InvoiceID>String</InvoiceID>
  <InvoiceIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceIDBetween>
  <InvoiceIDContains>String</InvoiceIDContains>
  <InvoiceIDEndsWith>String</InvoiceIDEndsWith>
  <InvoiceIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InvoiceIDIn>
  <InvoiceIDLike>String</InvoiceIDLike>
  <InvoiceIDStartsWith>String</InvoiceIDStartsWith>
  <RequestReadReceipt>false</RequestReadReceipt>
  <StaffID>String</StaffID>
  <StaffIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StaffIDBetween>
  <StaffIDContains>String</StaffIDContains>
  <StaffIDEndsWith>String</StaffIDEndsWith>
  <StaffIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StaffIDIn>
  <StaffIDLike>String</StaffIDLike>
  <StaffIDStartsWith>String</StaffIDStartsWith>
  <Subject>String</Subject>
  <SubjectBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SubjectBetween>
  <SubjectContains>String</SubjectContains>
  <SubjectEndsWith>String</SubjectEndsWith>
  <SubjectIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SubjectIn>
  <SubjectLike>String</SubjectLike>
  <SubjectStartsWith>String</SubjectStartsWith>
  <To>String</To>
  <ToBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ToBetween>
  <ToContains>String</ToContains>
  <ToEndsWith>String</ToEndsWith>
  <ToIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ToIn>
  <ToLike>String</ToLike>
  <ToStartsWith>String</ToStartsWith>
</QO_EmailLogQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfQO_EmailLog7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:QO_EmailLog>
      <d2p1:_x003C_Attachments_x003E_k__BackingField>String</d2p1:_x003C_Attachments_x003E_k__BackingField>
      <d2p1:_x003C_BCC_x003E_k__BackingField>String</d2p1:_x003C_BCC_x003E_k__BackingField>
      <d2p1:_x003C_Body_x003E_k__BackingField>String</d2p1:_x003C_Body_x003E_k__BackingField>
      <d2p1:_x003C_CC_x003E_k__BackingField>String</d2p1:_x003C_CC_x003E_k__BackingField>
      <d2p1:_x003C_EM_Main_RecID_x003E_k__BackingField>String</d2p1:_x003C_EM_Main_RecID_x003E_k__BackingField>
      <d2p1:_x003C_EmailDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_EmailDateTime_x003E_k__BackingField>
      <d2p1:_x003C_EmailLogID_x003E_k__BackingField>String</d2p1:_x003C_EmailLogID_x003E_k__BackingField>
      <d2p1:_x003C_FileID_x003E_k__BackingField>String</d2p1:_x003C_FileID_x003E_k__BackingField>
      <d2p1:_x003C_From_x003E_k__BackingField>String</d2p1:_x003C_From_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceHistoryID_x003E_k__BackingField>String</d2p1:_x003C_InvoiceHistoryID_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceID_x003E_k__BackingField>String</d2p1:_x003C_InvoiceID_x003E_k__BackingField>
      <d2p1:_x003C_RequestReadReceipt_x003E_k__BackingField>false</d2p1:_x003C_RequestReadReceipt_x003E_k__BackingField>
      <d2p1:_x003C_StaffID_x003E_k__BackingField>String</d2p1:_x003C_StaffID_x003E_k__BackingField>
      <d2p1:_x003C_Subject_x003E_k__BackingField>String</d2p1:_x003C_Subject_x003E_k__BackingField>
      <d2p1:_x003C_To_x003E_k__BackingField>String</d2p1:_x003C_To_x003E_k__BackingField>
    </d2p1:QO_EmailLog>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfQO_EmailLog7kRqkrSv>