Zap, tweet e repita! Como usar o Zapier com o MongoDB

1
{
2
    "created_at": "Tue Feb 02 20:31:58 +0000 2021",
3
    "id": "1356701917603238000",
4
    "id_str": "1356701917603237888",
5
    "full_text": "In case anyone is interested in learning about how to work with streaming data using Node.js, I wrote a tutorial about it on the @MongoDB Developer Hub. https://t.co/Dxt80lD8xj #javascript",
6
    "truncated": false,
7
    "display_text_range": [0, 188],
8
    "metadata": {
9
        "iso_language_code": "en",
10
        "result_type": "recent"
11
    },
12
    "source": "<a href='https://about.twitter.com/products/tweetdeck' rel='nofollow'>TweetDeck</a>",
13
    "in_reply_to_status_id": null,
14
    "in_reply_to_status_id_str": null,
15
    "in_reply_to_user_id": null,
16
    "in_reply_to_user_id_str": null,
17
    "in_reply_to_screen_name": null,
18
    "user": {
19
        "id": "227546834",
20
        "id_str": "227546834",
21
        "name": "Nic Raboy",
22
        "screen_name": "nraboy",
23
        "location": "Tracy, CA",
24
        "description": "Advocate of modern web and mobile development technologies. I write tutorials and speak at events to make app development easier to understand. I work @MongoDB.",
25
        "url": "https://t.co/mRqzaKrmvm",
26
        "entities": {
27
            "url": {
28
                "urls": [
29
                    {
30
                        "url": "https://t.co/mRqzaKrmvm",
31
                        "expanded_url": "https://www.thepolyglotdeveloper.com",
32
                        "display_url": "thepolyglotdeveloper.com",
33
                        "indices": [0, 23]
34
                    }
35
                ]
36
            },
37
            "description": {
38
                "urls": ""
39
            }
40
        },
41
        "protected": false,
42
        "followers_count": 4599,
43
        "friends_count": 551,
44
        "listed_count": 265,
45
        "created_at": "Fri Dec 17 03:33:03 +0000 2010",
46
        "favourites_count": 4550,
47
        "verified": false
48
    },
49
    "lang": "en",
50
    "url": "https://twitter.com/227546834/status/1356701917603237888",
51
    "text": "In case anyone is interested in learning about how to work with streaming data using Node.js, I wrote a tutorial about it on the @MongoDB Developer Hub. https://t.co/Dxt80lD8xj #javascript"
52
}

1
{
2
    "created_at": "Tue Feb 02 20:31:58 +0000 2021",
3
    "user": {
4
        "screen_name": "nraboy",
5
        "location": "Tracy, CA",
6
        "followers_count": 4599,
7
        "friends_count": 551
8
    },
9
    "text": "In case anyone is interested in learning about how to work with streaming data using Node.js, I wrote a tutorial about it on the @MongoDB Developer Hub. https://t.co/Dxt80lD8xj #javascript"
10
}

1
exports = function (payload, response) {
2
3
    const tweet = EJSON.parse(payload.body.text());
4
5
    const collection = context.services.get("mongodb-atlas").db("zapier").collection("tweets");
6
7
    return collection.insertOne(tweet);
8
9
};

1
url:developer.mongodb.com -filter:retweets filter:safe lang:en -from:mongodb -from:realm

1
{
2
    "created_at": "Tue Feb 02 20:31:58 +0000 2021",
3
    "username": "nraboy",
4
    "location": "Tracy, CA",
5
    "follower_count": "4599",
6
    "following_count": "551",
7
    "message": "In case anyone is interested in learning about how to work with streaming data using Node.js, I wrote a tutorial about it on the @MongoDB Developer Hub. https://t.co/Dxt80lD8xj #javascript"
8
}

1
[
2
    {
3
        "$addFields": {
4
            "follower_count": {
5
                "$toInt": "$follower_count"
6
            },
7
            "following_count": {
8
                "$toInt": "$following_count"
9
            }
10
        }
11
    }, {
12
        "$match": {
13
            "follower_count": {
14
                "$gt": 1000
15
            }
16
        }
17
    }, {
18
        "$group": {
19
            "_id": {
20
                "location": "$location"
21
            },
22
            "location": {
23
                "$sum": 1
24
            }
25
        }
26
    }
27
]