I am using a API to query results from Amazon using a search term and then store those results (around 60 per search) into Air Table.
Each result outputs as a collection (1 through 65) which is parsed but only one record gets inserted into the table.
It’s been a while since I used Make and I know I’m missing a step (module). Any help would be appreciated.
Hello @Tim_B,
I believe you will need to iterate search_results which will input one record at a time into Airtable.
Or you can iterate 10 at a time (Airtable’s limit), aggregate, then bulk add to Airtable in groups of up to 10.
Thanks for the quick reply. Maybe I missed something as I tried using the iterator node but it looks like my output needs to be a bundle for each record returned.
My output is one bundle and 60 collections within the bundle (my image from the original post).
Yea so after HTTP, place an Iterator, in the Iterator map in search_results, then map the elements from the Iterator to Airtable.
Hey @Tim_B
You need to use first “iterator” to extract all records from array. Then the next module will cost 60 operations per each bundle. Hence, to save those operation, put array aggregator and then map the array from aggregator to “create bulk records” module in airtable.
Now you will ask why again convert to array??? Every module has some specific structure to accepts the data, so you need to aggregate the results in that structure.
In array aggregator, after connecting bulk create records module, you might can see that module in “target structure type”. If not, then you will need to create JSON.
Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation
