# Add multi-row JSON response from API workflow to database?

**URL:** <https://forum.bubble.io/t/add-multi-row-json-response-from-api-workflow-to-database/5459>\
**Category:** Need help\
**Created:** [August 25, 2016, 12:05am UTC](https://forum.bubble.io/t/add-multi-row-json-response-from-api-workflow-to-database/5459 "2016-08-25T00:05:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sridharan.s](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/sridharan.s/32/17881_2.png) [@sridharan.s](https://forum.bubble.io/u/sridharan.s)\
**Post date:** [August 25, 2016, 12:05am UTC](https://forum.bubble.io/t/add-multi-row-json-response-from-api-workflow-to-database/5459/1 "2016-08-25T00:05:36Z")

</div>

Hi.

I have a POST JSON response that includes multiple values per field. How do I input these values as rows in my database?

The JSON looks like this…  
[  
{  
“event\_id”: “1471638833133x182831615355125760”,  
“user\_id”: “1471655244258x553992367349565060”,  
“user\_name”: “toad stool”,  
“user\_id\_other”: “1471642627948x481003036722540860”,  
“cur\_session”: 1,  
“paired\_with\_dummy”: “no”,  
“show\_break\_page”: “no”,  
“show\_survey\_page”: “no”,  
“response\_type”: “success”  
},  
{  
“event\_id”: “1471638833133x182831615355125760”,  
“user\_id”: “1471655182260x244606220396235600”,  
“user\_name”: “donkey kong”,  
“user\_id\_other”: “1471642668163x245075270999223000”,  
“cur\_session”: 1,  
“paired\_with\_dummy”: “no”,  
“show\_break\_page”: “no”,  
“show\_survey\_page”: “no”,  
“response\_type”: “success”  
},  
{  
“event\_id”: “1471638833133x182831615355125760”,  
“user\_id”: “1471655133758x590398509986698600”,  
“user\_name”: “yoshil”,  
“user\_id\_other”: “1471642704953x433251848211512000”,  
“cur\_session”: 1,  
“paired\_with\_dummy”: “no”,  
“show\_break\_page”: “no”,  
“show\_survey\_page”: “no”,  
“response\_type”: “success”  
}]

The endpoint is set up like so and is currently only populating my database with the first row. event\_id:25760…user\_id:235600…user\_name:.toad stool…"

 ![](https://us1.discourse-cdn.com/bubble/original/2X/d/d7822aad0740ecbca2ba368f5d3aaff97936a088.jpg)

How do I bring in all the rows, not just the first row?

---

<div class="post-metadata">

**Author:** ![happyholz123](https://avatars.discourse-cdn.com/v4/letter/h/ecccb3/32.png) [@happyholz123](https://forum.bubble.io/u/happyholz123)\
**Post date:** [June 7, 2020, 2:04am UTC](https://forum.bubble.io/t/add-multi-row-json-response-from-api-workflow-to-database/5459/2 "2020-06-07T02:04:50Z")

</div>

@sridharan.s were you able to get a solution to this ?

I am trying to do something similar which is I have a POST JSON from Postman which looks like the below. I am trying to post each array item as an individual row in the Bubble DB.

[  
{“heading” : “h1”,“description” : “d1”},

{“heading” : “h2”,“description” : “d2”}

]

I’m using schedule an “API workflow on a list” in backend workflows. However I do not know what parameters to define so the workflow event can detect the data from the oncoming JSON. I tried defining a parameter as type “list of things” I’m trying to post but it doesnt work (In the DB I have defined a thing called “posting” with fields heading and description).

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

I am running the API workflow on “post”

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

Postman gives an error saying “parameter post is missing”. However when I remove “post” parameter from workflow event and define no parameters, the error goes away but nothing is ofcourse created in the DB.

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

Would appreciate any help on how you managed to get around this.