BlogUse Cases

How to Use the Array Aggregator to Save New Followers From Twitter to a Data Store

What this scenario does: Retrieves a list of Twitter followers stored in a Data Store, compares it to the latest list retrieved from Twitter and saves the new followers. 

Level Of Difficulty: Intermediate 

Implementation Time: Approximately 15 mins 

Assumptions: You have a Twitter account with the connection added and a Data Store created to store the Twitter followers. 

So your Twitter followers are blowing up and you need to keep track of them? We got you. This tutorial shows you how to use the Array Aggregator and a Data store to save all your new Twitter followers. 

As covered in the beginner tutorial on the Array Aggregator, the function of this tool is to combine multiple bundles of data into a single array containing collections of specified items. 

The purpose of the Array Aggregator in this specific scenario is to combine multiple records (keys containing screen names) retrieved from a Data Store into a single array which enables these keys to be compared to the latest list of screen names retrieved from Twitter. Let’s go.

Configuring the scenario


The scenario consists of the following modules:

  • Data Store > Search records
  • Array Aggregator
  • Twitter > List followers
  • Data Store > Add/replace a record

Here’s the scenario: Save new followers from Twitter integration Open the first module in the scenario is the Data Store > Search records module which has a simple configuration. Simply select an existing data store or click the Add button to add a new one. Leave the filter empty: Data store module configuration Next is the Array Aggregator that you need to configure. The Source module (Data store > Search records) and the Target structure type (Custom) are already pre-selected and can be left as is. Under aggregated fields, tick the Key option: Array aggregator Integromat module configuration Following the Array Aggregator is the Twitter > List followers module which retrieves the latest list of followers. To configure it, select By Screen Name under List Followers and enter a number under Limit as this is the maximum number of returned followers Integromat will generate during one cycle execution: Twitter Integromat module configuration The route between the Twitter > List follows and the Data Store > Add/replace a record modules contain a filter. The purpose of this filter is to verify if the Keys (Screen names) retrieved from the Data Store does not contain the Screen names outputted by the Twitter module. Only if the bundle meets the criteria of the filter will it pass through to the subsequent module. 

Click on the route to set up the filter. To extract an item (the key in this case) and/or extract the value of an item from an array of collections, you need to use the map() function found under the Functions for working with arrays tab: Map function Integromat preview Map the Array[] element outputted by the Array Aggregator within the brackets and type in the word key after the semicolon. 

It is important to note here that you should only enter the raw name of the element (key in this case) outputted by the Array Aggregator in the brackets after the semicolon. To view the raw name of the element, simply hover over it: Setting up a filter in Integromat Next, select the Does not contain text operator and map the Screen name element outputted by the Twitter module: Setting up a filter in Integromat Great! The filter is fully set up. If the bundles meet the filter’s criteria, it passes through to the Data Store > Add/replace a record module which adds the new followers to the Data Store. 

Simply select the Data Store and map the Screen name element outputted by the Twitter module to the Key field: Data store Integromat module settingsAll set! Below are 2 scenario executions. Let's take a look at the results.

Scenario execution 1

Here you see that the bundles retrieved from the Data store are aggregated, the keys (Screen names) do not contain the screen names outputted by the Twitter module and the new followers are added in the Data StoreSave new Twitter followers scenario

Scenario execution 2

In this execution, the keys contain all the screen names outputted by the Twitter module therefore do not meet the filter’s criteria and are stopped from proceeding to the subsequent module: Save new Twitter followers integrationTada! Now you know how to use an Array Aggregator to update your list of Twitter followers in a Data store.

Happy Automating!

Do you like this article?
Don't forget to share it!
Share

Learn how to make your business better.

Subscribe and get the best industry tips, app hacks, and automation insights straight to your inbox.

Get started now!

Sign up for a free Integromat account today!