GET breeze/Emails/GetAllWhere?SqlWhereClause={SqlWhereClause}
No documentation available.
Request Information
Parameters
| Name | Description | Additional information |
|---|---|---|
| SqlWhereClause | No documentation available. |
Define this parameter in the request URI. |
Response Information
Response body formats
application/json, text/json
Sample:
[
{
"MAILNO": 1,
"IMAPUID": 1,
"DATESENT": "2025-06-06T21:41:23.6088258+00:00",
"SUBJECT": "sample string 2",
"ISTEXT": "sample string 3",
"ISHTML": "sample string 4",
"ISRTF": "sample string 5",
"ISCYPHER": "sample string 6",
"IMPORTANCE": "sample string 7",
"FROMEMAIL": "sample string 8",
"FROMNAME": "sample string 9",
"ACCOUNTID": 1,
"FOLDER": "sample string 10",
"MAILATTACH": [
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILHTML": [
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILRTF": [
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILTEXT": [
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILRECEIP": [
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 11",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"IMAPUID": 1,
"DATESENT": "2025-06-06T21:41:23.6088258+00:00",
"SUBJECT": "sample string 2",
"ISTEXT": "sample string 3",
"ISHTML": "sample string 4",
"ISRTF": "sample string 5",
"ISCYPHER": "sample string 6",
"IMPORTANCE": "sample string 7",
"FROMEMAIL": "sample string 8",
"FROMNAME": "sample string 9",
"ACCOUNTID": 1,
"FOLDER": "sample string 10",
"MAILATTACH": [
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILHTML": [
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILRTF": [
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILTEXT": [
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILRECEIP": [
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 11",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"IMAPUID": 1,
"DATESENT": "2025-06-06T21:41:23.6088258+00:00",
"SUBJECT": "sample string 2",
"ISTEXT": "sample string 3",
"ISHTML": "sample string 4",
"ISRTF": "sample string 5",
"ISCYPHER": "sample string 6",
"IMPORTANCE": "sample string 7",
"FROMEMAIL": "sample string 8",
"FROMNAME": "sample string 9",
"ACCOUNTID": 1,
"FOLDER": "sample string 10",
"MAILATTACH": [
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"MIMETYPE": "sample string 3",
"DATA": "QEBA",
"FILENAME": "sample string 4",
"SIZE": 1,
"CID": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILHTML": [
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"HTMLBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILRTF": [
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"RTFBODY": "sample string 3",
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILTEXT": [
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"SEQNO": 2,
"TEXTBODY": "sample string 3",
"OVERFLOW": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"MAILRECEIP": [
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"MAILNO": 1,
"ADDRESS": "sample string 2",
"RTYPE": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 11",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
]
application/xml
Sample:
Sample not available.
text/xml
Sample:
Sample not available.