# Save JSON to database

**URL:** <https://forum.bubble.io/t/save-json-to-database/139369>\
**Category:** Database\
**Created:** [March 3, 2021, 8:00pm UTC](https://forum.bubble.io/t/save-json-to-database/139369 "2021-03-03T20:00:11Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![fplassistant](https://avatars.discourse-cdn.com/v4/letter/f/8e7dd6/32.png) [@fplassistant](https://forum.bubble.io/u/fplassistant)\
**Post date:** [March 3, 2021, 8:00pm UTC](https://forum.bubble.io/t/save-json-to-database/139369/1 "2021-03-03T20:00:11Z")

</div>

I have an API call that returns multiple objects with matching variables but different values for those variables.  
E.g.  
name = John  
id = 1  
name = Kate  
id =2

Now the API call recognises Name, ID etc as the variables but when I try to make a workflow to get name = John into my database it actually returns John, Kate under the name field.

What I want to do is have a workflow that, for each of the objects returned from the API call, create a new entry and assign the name to the name field and the id to the id field…

---

<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:** [March 3, 2021, 8:10pm UTC](https://forum.bubble.io/t/save-json-to-database/139369/2 "2021-03-03T20:10:15Z")

</div>

You need to use Backend WF on a list and set the list type of the JSON Payload type

---

<div class="post-metadata">

**Author:** ![fplassistant](https://avatars.discourse-cdn.com/v4/letter/f/8e7dd6/32.png) [@fplassistant](https://forum.bubble.io/u/fplassistant)\
**Post date:** [March 3, 2021, 8:14pm UTC](https://forum.bubble.io/t/save-json-to-database/139369/3 "2021-03-03T20:14:44Z")

</div>

Sorry what is Backend WF and JSON Payload type?

---

<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:** [March 3, 2021, 8:18pm UTC](https://forum.bubble.io/t/save-json-to-database/139369/4 "2021-03-03T20:18:57Z")

</div>

Backend WF are wf that are processed server side. You need to activate this in Settings tabs API.  
By JSON Payload I mean that if your API Call is set to “DATA” not action, you will have the type created by Bubble automatically like if this was a Bubble DB. You can use this in your setting for Backend WF. Bubble will create a list type from the JSON.

---

<div class="post-metadata">

**Author:** ![fplassistant](https://avatars.discourse-cdn.com/v4/letter/f/8e7dd6/32.png) [@fplassistant](https://forum.bubble.io/u/fplassistant)\
**Post date:** [March 3, 2021, 8:33pm UTC](https://forum.bubble.io/t/save-json-to-database/139369/5 "2021-03-03T20:33:57Z")

</div>

Are the any examples as I can’t find anything really? I’m new to bubble and don’t really understand what you’re getting at. I have enabled the setting and the API call is set to DATA and not action but I don’t know what the next step would be?

Thanks for your help 🙂

---

<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:** [March 3, 2021, 8:47pm UTC](https://forum.bubble.io/t/save-json-to-database/139369/6 "2021-03-03T20:47:49Z")

</div>

You can search for “API Workflow” that was the previous name of “Backend WF”. You might find some information here on forum or some good tutorials. I don’t know one that I can recommend but maybe @cmarchan have some links

---

<div class="post-metadata">

**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\
**Post date:** [March 3, 2021, 8:54pm UTC](https://forum.bubble.io/t/save-json-to-database/139369/7 "2021-03-03T20:54:07Z")

</div>

Sure @Jici @fplassistant

These two should provide a good amount of material on API calls and Endpoints

[![](https://img.youtube.com/vi/DXsL4FjAhd8/maxresdefault.jpg "Bubble Webinar 2 - The API Connector") ](https://www.youtube.com/watch?v=DXsL4FjAhd8)

https://www.youtube.com/embed/zoPCX34Y8Io?feature=oembed&wmode=opaque&list=PLoNVJrdvQQYkI8BTpIbRsVISG-YY-L0z3

---

<div class="post-metadata">

**Author:** ![ryanck](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@ryanck](https://forum.bubble.io/u/ryanck)\
**Post date:** [March 23, 2022, 6:54am UTC](https://forum.bubble.io/t/save-json-to-database/139369/8 "2022-03-23T06:54:04Z")

</div>

Hey @Jici

Do you mind taking a look at this post so you can tell us your thoughts about it?

[http://forum.bubble.io/t/xano-database-bubble-demo/196758/59?u=ryanck](http://forum.bubble.io/t/xano-database-bubble-demo/196758/59)
