Executionid To Xls And Send
vaclavrut/executionid-to-xls-and-send
The act takes a JSON input, starts the act which creates a xls from execution id result and after that send the link via mail. The resulting XLSX URL will be following: https://api.apifier.com/v2/key-value-stores/{defaultStoreID}/records/results.xlsx?rawBody=1&disableRedirect=1 Alternatively you can obtain the result from default OUTPUT value where it is stored like this: {output: "result XLSX URL"} The URL is also outputted in the log. Solving how to attach the xls to the mail.
- API
- Source code
To run the code examples, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21const Apify = require('apify'); // Set API token Apify.client.setOptions({ token: '<YOUR_API_TOKEN>' }); // Prepare actor input const input = {}; // Run the actor const run = await Apify.call('vaclavrut/executionid-to-xls-and-send', input); // Print actor output (if any) console.log('Output'); console.dir(run.output); // Fetch and print actor results from the run's dataset (if any) console.log('Results from dataset'); const dataset = await Apify.openDataset(run.defaultDatasetId, { forceCloud: true }); await dataset.forEach(async (item, index) => { console.log(JSON.stringify(item)); });
