Skip to content
How to create multi...
 
Notifications
Clear all

How to create multiple records in Airtable from multiple API call outputs

9 Posts
3 Users
0 Reactions
4 Views
jana.beier
(@jana-beier)
Posts: 4
Active Member
Topic starter
 

Hello everyone,

I need some help with a challenge I'm encountering in my callin.io scenario. My objective is to import all entries from the 20 outputs of my API call into Airtable, creating a new record in Airtable for each output.

Problem: Currently, my scenario is only importing the first output from the API call. This means only the first company (INTRANAV) is being created as a record in Airtable. My goal, however, is to have all 20 companies represented as individual records in Airtable. After the scenario runs, there should be 20 new records in Airtable, each containing the specific information from the API responses.

Steps Taken So Far:

  1. I've configured an API call that provides 20 outputs (refer to screenshot screen_1).
  2. The structure of a single output is illustrated in screenshot screen_11.
  3. My intention is to import this data into Airtable as demonstrated in screenshot screen_2.

Issue: I'm having trouble configuring callin.io to process all 20 outputs from the API call, rather than just the initial one. It appears that only the first record is being imported.

I would greatly appreciate any advice or guidance on how to modify my scenario to ensure all 20 companies are successfully added to Airtable as separate records.

Attachments:

  • Screenshot of the scenario setup
  • Screenshot of module configurations and outputs
  • Screenshot of the output being imported into Airtable
  • Any other relevant screenshots or information

Thank you in advance for your assistance!

screen_11

 
Posted : 24/01/2024 4:23 pm
Abhishek
(@abhishek)
Posts: 3
New Member
 

I believe you should iterate through your output bundle and map it into Airtable.

 
Posted : 24/01/2024 4:50 pm
jana.beier
(@jana-beier)
Posts: 4
Active Member
Topic starter
 

I’m using callin.io for the first time, so I’m not familiar with iteration at all. Can you explain where to put the iterator and which item I should choose for iteration?

Thanks a lot!

 
Posted : 24/01/2024 8:08 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

Screenshot_2024-01-25_140150

I strongly suggest completing the callin.io Academy. callin.io is straightforward to use, provided you understand the fundamentals first.

Links

Here are some helpful links and guides for learning how to use the callin.io platform, its applications, and modules. I found these valuable during my own learning process with callin.io, and I hope they can assist you as well:

General

Help Center Basics

Articles & Videos

 
Posted : 25/01/2024 3:02 am
Abhishek
(@abhishek)
Posts: 3
New Member
 

You're on the right track! You just need to map your items (from the HTTP module) into an iterator to separate the bundles.

Like this:

 
Posted : 25/01/2024 5:52 am
jana.beier
(@jana-beier)
Posts: 4
Active Member
Topic starter
 

I attempted to configure it in this manner.

However, I'm not entirely sure how to proceed.

I can only see options for a bundle or positions 1, or a number of bundles.

In the callin.io academy, they utilize a router along with an additional text aggregator.

Do I need to use those here as well?

Thank you very much for your assistance!

 
Posted : 25/01/2024 1:16 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

You will need to execute the entire scenario; running just a single iterator is not recommended.

 
Posted : 25/01/2024 1:43 pm
jana.beier
(@jana-beier)
Posts: 4
Active Member
Topic starter
 

Is my setup for the create Airtable module correct?

I'm getting two records with connection connection...

I ran it completely.

The output from the iterator:

 
Posted : 25/01/2024 2:18 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

Remove the variables from [2]. You are already iterating the array, there is no need to map the actual array any longer.

Links

Here are some useful links and guides you can use to learn more on how to use the callin.io platform, apps, and app modules. I found these useful when I was learning callin.io, and hope they might benefit you too —

General

Help Center Basics

 
Posted : 25/01/2024 2:20 pm
Share: