Airtable batch update via API call

If you need to separate your items into batches of 10 (or any other quantity), the initial step should involve using an array aggregator.

After the data is converted into a JSON string, it can no longer be divided.

Could you elaborate on that further, please?

For further assistance, please provide the following:

1. Screenshots of module fields and filters

Please share screenshots of the relevant module fields and filters in question. This would greatly assist other community members in understanding your context.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to enable others to review the mappings and settings. You can find the Export Blueprint option by clicking the three dots at the bottom of the scenario editor.

^{(Note: Exporting your scenario will not include private information or connection keys)}

Uploading it here will appear as follows:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles from the modules. Run the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.

A.

Save the bundle contents to a bundle.txt file using your text editor, and upload it to this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, you can alternatively paste the formatted output bundle using one of these methods:

• Add three backticks ``` before and after the code, like this:

  ```
  <sup>input/output bundle content goes here</sup>
  ```

• Or use the format code button in the editor:
  

Providing the output bundles will enable others to replicate the scenario's behavior, even without access to the external service.

Following these steps will facilitate assistance from the community. Thank you!

9airtable.json (3.8 KB)
12json.json (1.4 KB)
7airtable.json (125 Bytes)
blueprint (7).json (23.7 KB)

Here you go, thanks in advance

Could you assist me with this? That would be greatly appreciated.

Also, if you don't mind, I have another question: can I scrape websites using ScrapeNinja if the website requires a login, for example?

I need to extract the data behind this interface and then input it into a Google Sheets module.

Thanks in advance!

Hello Karim,

Within your search record, you can utilize the Airtable query with embedded variables. This will group your 10 records (you'll need to define the grouping logic). Subsequently, you can loop this search module to execute for each of the 10 distinct records, perhaps by using an iterator that shares the variables for your query search.

Hi, thanks for the response.

Could you please provide more details? To be candid, I'm not entirely grasping your point.

Is this what you were referring to?

Screenshot 2024-02-16 at 13.56.461654×192 32.6 KB

You can explore using a formula field to filter your records and isolate a smaller subset of your table. The preceding module can iterate and pass a variable into this formula, enabling you to segment your table into chunks of 10 records maximum.
For instance, add a new column in Airtable named "index", populated with an integer incrementing from 1 to xx for each row.
Then, utilize an Airtable formula to search for records where the {index} falls between x and y.
Here, x and y represent your variables, which will change for each operation based on the preceding iterating module.