V8 usage alert
From DreamFactory
Toddappleton (Talk | contribs) (Created page with "Seeing a suspicious pattern of data usage? Send a notification email to an admin. Using a 'TransactionHistory' table, count the number of API calls in the last 5 minutes and s...") |
Toddappleton (Talk | contribs) |
||
| Line 1: | Line 1: | ||
Seeing a suspicious pattern of data usage? Send a notification email to an admin. Using a 'TransactionHistory' table, count the number of API calls in the last 5 minutes and send an email alert to the specified email address if the number of API calls exceeds a specific threshold, say 1,000 API calls. THis script could be triggered by API calls or scheduled to run periodically. | Seeing a suspicious pattern of data usage? Send a notification email to an admin. Using a 'TransactionHistory' table, count the number of API calls in the last 5 minutes and send an email alert to the specified email address if the number of API calls exceeds a specific threshold, say 1,000 API calls. THis script could be triggered by API calls or scheduled to run periodically. | ||
| + | |||
| + | <source lang="javascript"> | ||
| + | // We need a way to convert js date to mysql date format. | ||
| + | // That's what the following two functions do. | ||
| + | |||
| + | function twoDigits(d) { | ||
| + | if (0 <= d && d < 10) return "0" + d.toString(); | ||
| + | if (-10 < d && d < 0) return "-0" + (-1 * d).toString(); | ||
| + | return d.toString(); | ||
| + | } | ||
| + | |||
| + | var toMysqlFormat = function (x) { | ||
| + | return x.getUTCFullYear() + "-" + twoDigits(1 + x.getUTCMonth()) + "-" + twoDigits(x.getUTCDate()) + " " + twoDigits(x.getUTCHours()) + ":" + twoDigits(x.getUTCMinutes()) + ":" + twoDigits(x.getUTCSeconds()); | ||
| + | }; | ||
| + | |||
| + | var timelapse = 5; // how many minutes to count | ||
| + | |||
| + | var threshold = 1000; // how many api calls are allowed | ||
| + | |||
| + | var query = "timestamp%3c" + toMysqlFormat(new Date(Date.now() - timelapse * 60000)); | ||
| + | |||
| + | result = platform.api.get("db/_table/TransactionHistory?filter=(" + query + ")"); | ||
| + | |||
| + | if (result.content.resource.length >= threshold) { | ||
| + | |||
| + | var email = { | ||
| + | |||
| + | "to": [ | ||
| + | { | ||
| + | "name": "John Doe", | ||
| + | "email": "johndoe@mailinator.com" | ||
| + | } | ||
| + | ], | ||
| + | "subject": "Usage alert", | ||
| + | "body_text": "API usage has exceeded the alert threshold.", | ||
| + | "from_name": "John Doe", | ||
| + | "from_email": "johndoe@mailinator.com", | ||
| + | "reply_to_name": "John Doe", | ||
| + | "reply_to_email": "johndoe@mailinator.com" | ||
| + | }; | ||
| + | |||
| + | platform.api.post("email", email); | ||
| + | } | ||
| + | </source> | ||
Revision as of 19:03, 29 June 2016
Seeing a suspicious pattern of data usage? Send a notification email to an admin. Using a 'TransactionHistory' table, count the number of API calls in the last 5 minutes and send an email alert to the specified email address if the number of API calls exceeds a specific threshold, say 1,000 API calls. THis script could be triggered by API calls or scheduled to run periodically.
// We need a way to convert js date to mysql date format. // That's what the following two functions do. function twoDigits(d) { if (0 <= d && d < 10) return "0" + d.toString(); if (-10 < d && d < 0) return "-0" + (-1 * d).toString(); return d.toString(); } var toMysqlFormat = function (x) { return x.getUTCFullYear() + "-" + twoDigits(1 + x.getUTCMonth()) + "-" + twoDigits(x.getUTCDate()) + " " + twoDigits(x.getUTCHours()) + ":" + twoDigits(x.getUTCMinutes()) + ":" + twoDigits(x.getUTCSeconds()); }; var timelapse = 5; // how many minutes to count var threshold = 1000; // how many api calls are allowed var query = "timestamp%3c" + toMysqlFormat(new Date(Date.now() - timelapse * 60000)); result = platform.api.get("db/_table/TransactionHistory?filter=(" + query + ")"); if (result.content.resource.length >= threshold) { var email = { "to": [ { "name": "John Doe", "email": "johndoe@mailinator.com" } ], "subject": "Usage alert", "body_text": "API usage has exceeded the alert threshold.", "from_name": "John Doe", "from_email": "johndoe@mailinator.com", "reply_to_name": "John Doe", "reply_to_email": "johndoe@mailinator.com" }; platform.api.post("email", email); }
