Bits and pieces of this service work. The first service to return the email address based on the inputs works, but it retrieves them as an infotable. Everything else in between works to find failures and create the email works. It just wont send my email since i'm not putting in the emails from the first service correctly. Hardcoding the emails into the address input will work as well but I need to select the emails based on area and shift.
//First gather email list based on area and shift of the audit
// result: INFOTABLE dataShape: "AuditEmailList.DS"
var EmailList = Things["AuditEmailList.DT"].GetEmailList({
Shift: Shift /* INTEGER */,
Area: Area /* STRING */
});
var params = {
t:EmailList /* INFOTABLE */,
columns: "Email" /* STRING */
};
var result = Resources["InfoTableFunctions"].Distinct(params);
var tableLength = result.rows.length;
for (var x=0; x < tableLength; x++) {
var row = result.rows[x];
//First check for and get failure information by AuditID
var failureinfo = Things["MSSQLConnector.AuditForms"].GetFailInfoPieceCheck({
AuditID: AuditID /* INTEGER */
});
var params = {
t:failureinfo /* INFOTABLE */,
columns: "UserID,TOE,Shift,LineID,Item,PassFailNa,Notes" /* STRING */
};
//Second, if failures exist send one email with all the failure info from infotable above.
result: INFOTABLE
var result = Resources["InfoTableFunctions"].Distinct(params);
var tableLength = result.rows.length;
var emailContent="<html><body><table>";
Add heading row (column names)
emailContent = emailContent + "<tr><th>UserID</th><th>TOE</th><th>Shift</th><th>LineID</th><th>Item</th>";
emailContent = emailContent + "<th>PassFailNa</th><th>Notes</th>";
emailContent = emailContent + "</tr>"; // End heading row
if (tableLength > 0) {
for (var x=0; x < tableLength; x++) {
var row = result.rows[x]; // Get Row Data
emailContent =emailContent +"<tr><td>"+row.UserID+"</td><td>"+row.TOE+"</td><td>"+row.Shift+"</td>";
emailContent =emailContent + "<td>"+row.LineID+"</td><td>"+row.Item+"</td><td>"+row.PassFailNa+"</td>";
emailContent =emailContent + "<td>"+row.Notes+"</td>";
// Add closing tag to row.
emailContent =emailContent + "</tr>";
} // Next Row
emailContent = emailContent + "</table></body></html>"; // Add Closing HTML tags to body content.
Things["MailServer"].SendMessage({
cc: undefined /* STRING */,
bcc: undefined /* STRING */,
subject: "Piece Check Audit Failure" /* STRING */,
from: undefined /* STRING */,
to: EmailList,
body: emailContent /* HTML */
});
}
}
