Pricing
Pay per usage
This actor takes JSON at input, creates it as XLS from the execution ID result and then sends a link by email. The URL is also outputted in the log. Solves attaching XLS files to emails.
0.0 (0)
Pricing
Pay per usage
3
3
1
Last modified
3 years ago
# This is a template for a Dockerfile used to run acts in Actor system.# The base image name below is set during the act build, based on user settings.# IMPORTANT: The base image must set a correct working directory, such as /usr/src/app or /home/userFROM apify/actor-node-basic:v0.21.10
# Second, copy just package.json and package-lock.json since it should be# the only file that affects "npm install" in the next step, to speed up the buildCOPY package*.json ./
# Install NPM packages, skip optional and development dependencies to# keep the image small. Avoid logging too much and print the dependency# tree for debuggingRUN npm --quiet set progress=false \ && npm install --only=prod --no-optional \ && echo "Installed NPM packages:" \ && (npm list --all || true) \ && echo "Node.js version:" \ && node --version \ && echo "NPM version:" \ && npm --version
# Copy source code to container# Do this in the last step, to have fast build if only the source code changedCOPY . ./
# NOTE: The CMD is already defined by the base image.# Uncomment this for local node inspector debugging:# CMD [ "node", "--inspect=0.0.0.0:9229", "main.js" ]{ "name": "apify-project", "version": "0.0.1", "description": "", "author": "It's not you it's me", "license": "ISC", "dependencies": { "xlsx": "latest", "apify": "0.21.10", "underscore": "latest", "bluebird": "latest", "request-promise": "latest" }, "scripts": { "start": "node main.js" }}1const XLSX = require('xlsx');2const Apify = require('apify');3const _ = require('underscore');4const Promise = require('bluebird');5const request = require('request-promise');6
7Apify.main(async () => {8 Apify.setPromisesDependency(Promise);9 console.log("Start");10 const attachments = [];11 12 // get Act input and validate it13 let input = await Apify.getValue('INPUT');14 let finishWebhookData;15 console.log(JSON.stringify(input));16 if(input.data){17 //run from webhook18 finishWebhookData = JSON.parse(input.data);19 finishWebhookData._id = input._id20 }else if(input){21 //manual run from console22 finishWebhookData = input;23 }else{24 throw new Error('Input is missing!');25 }26
27 console.log("ID is -> "+ finishWebhookData._id)28 console.log("Create XLS from json.");29 30 const run = await Apify.call(31 'petr_cermak/execution-to-xlsx',32 {"_id": finishWebhookData._id});33 34 35 const xlsUrl = run.output.body.output;36 console.log(JSON.stringify(run));37 38 const xlsSize = parseFloat(run.output.size);39 console.log("We have XLS url: "+xlsUrl);40 console.log("Size of XLS is: "+xlsSize);41 const runMail = await Apify.call(42 'apify/send-mail',43 {to: finishWebhookData.reciever,44 subject: finishWebhookData.subjectText,45 text: "Hello, here is the link for XLS result: "+ xlsUrl,46 attachments: attachments47 },48 {});49 50 51 /*52 //Next step to attach the file if the size is ok53 if(xlsSize < 10000000){54 console.log("Creating attachement, size is ok.")55 var attachement = await request({ url: xlsUrl, encoding: null });56 attachments.push({57 filename: `data.xls`,58 data: attachement,59 });60 }else{61 console.log("We cant send it as attachement, file is too big.") 62 }63 */64 /*65 console.log("Now we can send the mail.");66 await Apify.setValue('OUTPUT', {output: xlsUrl});67 const runMail = await Apify.call({68 actId: 'apify/send-mail',69 input: {70 contentType: 'application/json; charset=utf-8',71 body: JSON.stringify({72 to: finishWebhookData.reciever,73 subject: finishWebhookData.subjectText,74 text: "Hello, here is the link for XLS result: "+ xlsUrl,75 attachments: attachments76 })77 78 }79 });80 console.log("Mail sent, done.")81 */82});