Scheduler From Spreadsheet avatar
Scheduler From Spreadsheet
Try for free

No credit card required

View all Actors
Scheduler From Spreadsheet

Scheduler From Spreadsheet

juansgaitan/scheduler-from-spreadsheet
Try for free

No credit card required

Extract the schedule extraction for one or more acts.

Dockerfile

1# This is a template for a Dockerfile used to run acts in Actor system.
2# The base image name below is set during the act build, based on user settings.
3# IMPORTANT: The base image must set a correct working directory, such as /usr/src/app or /home/user
4FROM apify/actor-node-basic:v0.21.10
5
6# Second, copy just package.json and package-lock.json since it should be
7# the only file that affects "npm install" in the next step, to speed up the build
8COPY package*.json ./
9
10# Install NPM packages, skip optional and development dependencies to
11# keep the image small. Avoid logging too much and print the dependency
12# tree for debugging
13RUN npm --quiet set progress=false \
14 && npm install --only=prod --no-optional \
15 && echo "Installed NPM packages:" \
16 && (npm list --all || true) \
17 && echo "Node.js version:" \
18 && node --version \
19 && echo "NPM version:" \
20 && npm --version
21
22# Copy source code to container
23# Do this in the last step, to have fast build if only the source code changed
24COPY  . ./
25
26# NOTE: The CMD is already defined by the base image.
27# Uncomment this for local node inspector debugging:
28# CMD [ "node", "--inspect=0.0.0.0:9229", "main.js" ]

package.json

1{
2    "name": "apify-project",
3    "version": "0.0.1",
4    "description": "",
5    "author": "It's not you it's me",
6    "license": "ISC",
7    "dependencies": {
8        "apify": "0.21.10",
9        "moment": "latest",
10        "request-promise": "latest"
11    },
12    "scripts": {
13        "start": "node main.js"
14    }
15}

main.js

1const Apify = require('apify');
2const moment = require('moment');
3const requestPromise = require('request-promise');
4
5Apify.main(async () => {
6  // const { sheetId } = await Apify.getValue('INPUT');
7  const sheetId = '1-vpSVo1WjKheduG4YjXoOUfZ6mWaoeSekaiVRVoNV-8';
8
9  if (!sheetId) {
10    throw new Error('Invalid input, must be a JSON object with the "sheetId" field!');
11  }
12  const spreadSheetUrl = `
13    https://spreadsheets.google.com/feeds/list/${sheetId}/od6/public/basic?alt=json
14  `;
15  console.log('Extracting info from:', spreadSheetUrl);
16
17  let json;
18  try {
19    const response = await requestPromise(spreadSheetUrl);
20    json = JSON.parse(response);
21  } catch (err) {
22    throw new Error('Error while getting spread sheet!', err);
23  }
24  const now = moment().startOf('hour');
25  const afterAnHour = now.clone().add(1, 'hour');
26  const defaultTime = moment().startOf('day');
27
28  const { entry } = json.feed;
29  const hashtags = entry.map(({ title, content }) => {
30    const hashtag = title.$t;
31    const [frequency] = [content.$t.match(/\d{1,2}:\d{2}:\d{2} [apm]{2}/i) || defaultTime];
32    const time = moment(frequency, 'HH:mm:ss a');
33    if (time.isBetween(now, afterAnHour)) {
34      console.log('Calling Extractor for', hashtag);
35      Apify.call('juansgaitan/instagram-extract-posts', { hashtag });
36    }
37    return { hashtag, time };
38  });
39  console.log(hashtags);
40  console.log('Done.');
41});
Developer
Maintained by Community
Actor metrics
  • 0 monthly users
  • 0.0 days response time
  • Created in Jan 2018
  • Modified almost 2 years ago
Categories