Execution ID To XLS Send

# 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/user
FROM 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 build
COPY 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 debugging
RUN 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 changed
COPY  . ./

# 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 it
13    let input = await Apify.getValue('INPUT');
14    let finishWebhookData;
15    console.log(JSON.stringify(input));
16    if(input.data){
17        //run from webhook
18        finishWebhookData = JSON.parse(input.data);
19        finishWebhookData._id = input._id
20    }else if(input){
21        //manual run from console
22        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: attachments
47        },
48        {});
49    
50    
51    /*
52    //Next step to attach the file if the size is ok
53    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: attachments
76            })
77          
78        }
79    });
80    console.log("Mail sent, done.")
81    */
82});