# API workflow mass data

**URL:** <https://forum.bubble.io/t/api-workflow-mass-data/66845>\
**Category:** APIs\
**Created:** [September 13, 2019, 7:21pm UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845 "2019-09-13T19:21:17Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![a.v.krikunenko](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@a.v.krikunenko](https://forum.bubble.io/u/a.v.krikunenko)\
**Post date:** [September 13, 2019, 7:21pm UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/1 "2019-09-13T19:21:17Z")

</div>

Dear colleagues,  
I am on my way learning Bubble and stuck with the following issue.

I am trying to download data from external web site and save it to database.  
As a result I would like to receive something like this (sorry for excel):

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/1/d/1d25854a745f8b9c9cb6c9a97855462c60144a52.png)

But using my API workflow I am receiving mass of data:

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/c/a/ca8cf592f58a6a63f041b7deb0f502e8c1f401ad.png)

Could you help me understand where I am mistaken.

My API Workflow settings here:

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/1/8/18e6acd210ee6f587dfc31e085e4de1ea709cae2.png)  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/9/c/9c6b69e080ad2533ae913ccc2b14aeb04ab26b26.png)  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/b/1/b170bd42793b9c7e8d70aa40f4e53d0f8ede0df7.png)

---

<div class="post-metadata">

**Author:** ![Jici](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jici/32/30722_2.png) [@Jici](https://forum.bubble.io/u/Jici)\
**Post date:** [September 13, 2019, 7:42pm UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/2 "2019-09-13T19:42:03Z")

</div>

You should schedule api workflow on a list.  
But this depend on how you get data (should be a list too).

---

<div class="post-metadata">

**Author:** ![a.v.krikunenko](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@a.v.krikunenko](https://forum.bubble.io/u/a.v.krikunenko)\
**Post date:** [September 14, 2019, 2:34am UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/4 "2019-09-14T02:34:32Z")

</div>

Oh, almost 6 hours spent without result but everything remains the same.  
I have tried to schedule API workflow on a list.

 ![image.png](https://us1.discourse-cdn.com/bubble/original/3X/6/e/6e1bb212095903d095e13c4a8035f17281d45df2.png)  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/d/f/dfbda477c903ebedd7f0711120fa1a355aba540a.png)  
 ![image.png](https://us1.discourse-cdn.com/bubble/original/3X/7/5/75b03eb22469711d2ca464d2fea8d06ab8065e13.png)

Reslut:

 ![image.png](https://us1.discourse-cdn.com/bubble/original/3X/a/6/a6d08bc15ef46bd66167f1daed1290fb154f40a8.png)

---

<div class="post-metadata">

**Author:** ![Jici](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jici/32/30722_2.png) [@Jici](https://forum.bubble.io/u/Jici)\
**Post date:** [September 14, 2019, 3:30am UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/5 "2019-09-14T03:30:39Z")

</div>

I don’t think that the the list you schedule on should be of type text but a type related to the API call array.  
Can you show the result of the api call (the popup window after the initialize call. Can be this window or the raw data)  
At first sight, should be …Items (not with ID). And the list to run on with be Agency test - API Call’s items

---

<div class="post-metadata">

**Author:** ![a.v.krikunenko](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@a.v.krikunenko](https://forum.bubble.io/u/a.v.krikunenko)\
**Post date:** [September 14, 2019, 9:14am UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/6 "2019-09-14T09:14:34Z")

</div>

Changed type of thing to “API call item” and “List to run on” to Agency Test - API Call Items".

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/b/4/b4dff9f176c256b07dbe5ca6e540160315685a5d.png)  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/6/2/62efddd968a8216f46e6927d2014f3da6e18488f.png)

The result is still:

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/1/6/162a3eaa55d954febe5df85b291867b34c9ed230.png)

Other thins stay the same

 ![image.png](https://us1.discourse-cdn.com/bubble/original/3X/6/e/6e1bb212095903d095e13c4a8035f17281d45df2.png)  
 ![image.png](https://us1.discourse-cdn.com/bubble/original/3X/7/5/75b03eb22469711d2ca464d2fea8d06ab8065e13.png)

---

<div class="post-metadata">

**Author:** ![a.v.krikunenko](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@a.v.krikunenko](https://forum.bubble.io/u/a.v.krikunenko)\
**Post date:** [September 14, 2019, 1:46pm UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/7 "2019-09-14T13:46:30Z")

</div>

Thank you very much!!! After certain attempts I finaly solved this problem, the result is perfect.

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/b/9/b9f140b45f236ae8004e09a645f82495756811b1.png)

The main mistake was in Schedule API Workflow. Wrong settings:  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/0/0/00c861218b115996c8bb230fbd9b9331bffcaed9.png)

Current Right Settings:

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/3/8/38f776a2a96403ce98311e2d7028af519bea3b76.png)

Also to solve this issue I read this really helpful case (really similar to mine):

> [@Create list of things from API - I'm stuck frowning](http://forum.bubble.io/t/create-list-of-things-from-api-im-stuck/47932):
>
> Hi Everyone! @romanmg I am trying to create a list of things from my external API. The API is returning the correct values, but I am getting all the values returned into a single thing as opposed to each value returned into a new row. Here is my API setup: Here is what is saving to the database: I would like it to save like this: Here is my API/workflows: Any help here would be greatly appreciated!! Thank you, Kyle

---

<div class="post-metadata">

**Author:** ![Jici](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jici/32/30722_2.png) [@Jici](https://forum.bubble.io/u/Jici)\
**Post date:** [September 14, 2019, 2:04pm UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/8 "2019-09-14T14:04:11Z")

</div>

Yes. On the previou post, I should tell you to use THIS… in the bottom parameters  
“This” is use to send the current item data. If you use the Agency test - API Call’s data’s id (for example), this will send all ID not just the ID of the current item. So the list will not run correctly.

---

<div class="post-metadata">

**Author:** ![evkostromskoy](https://avatars.discourse-cdn.com/v4/letter/e/7ba0ec/32.png) [@evkostromskoy](https://forum.bubble.io/u/evkostromskoy)\
**Post date:** [January 12, 2021, 10:36pm UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/9 "2021-01-12T22:36:17Z")

</div>

Hi,

I am sorry, am I missing something? Could you please help me with this?

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/1/b/1b08cc15b3b7becd959f0a40c7423c68a697ccd0.png)

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/0/3/03c78b552b52179e50864a2b57545ec9c0544449.png)

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/f/5/f57f46b0219b232584d92b772c8c6fb1e3f3efe8.png)

![image](https://us1.discourse-cdn.com/bubble/original/3X/9/0/908ed7e20b2c989d1725c6c32de81ee05441bb50.png)

---

<div class="post-metadata">

**Author:** ![evkostromskoy](https://avatars.discourse-cdn.com/v4/letter/e/7ba0ec/32.png) [@evkostromskoy](https://forum.bubble.io/u/evkostromskoy)\
**Post date:** [January 12, 2021, 10:54pm UTC](https://forum.bubble.io/t/api-workflow-mass-data/66845/10 "2021-01-12T22:54:52Z")

</div>

Never mind! Just solved it.
