# How to save single flow in my local database

**URL:** <https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315>\
**Category:** Core Development\
**Created:** [15 April 2022 03:58 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315 "2022-04-15T03:58:19Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![weber\_j](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/weber_j/32/60113_2.png) [@weber\_j](https://discourse.nodered.org/u/weber_j)\
**Post date:** [15 April 2022 03:58 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/1 "2022-04-15T03:58:19Z")

</div>

i want to save every single flow (tab`s flow) into my local database, how can i do or what plugin can i use? Thank to help

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [15 April 2022 07:29 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/2 "2022-04-15T07:29:51Z")

</div>

I have a (rudimentary) subflow that uses the node-red admin api, it assumes you have setup adminAuth in your settings.js.

Note this will try to get the bearer access token and write it to a flow variable. If access fails, the flow might end up in a loop (which is why it is rudimentary ;))

Import the flow below, it adds a "node-red-api" subflow to the palette  
Drag it into the flow  
Doubleclick the node, enter your credentials and the url of the node-red instance.  
Attach an inject node and a debug node.  
Deploy.

It will output each flow tab as a msg.payload, which contains the flow as an object.

```auto
[{"id":"032dd27dda5cb68c","type":"subflow","name":"node-red-api","info":"","category":"","in":[{"x":72,"y":72,"wires":[{"id":"644ad4ea5196ed50"}]}],"out":[{"x":1340,"y":72,"wires":[{"id":"cce6ce997d307379","port":0},{"id":"b22a1eadbf4bdd26","port":0}]}],"env":[{"name":"username","type":"str","value":"","ui":{"label":{"en-US":"Username"},"type":"input","opts":{"types":["str"]}}},{"name":"password","type":"cred","ui":{"label":{"en-US":"Password"}}},{"name":"url","type":"str","value":"http://<ip>:1880","ui":{"label":{"en-US":"node-red-url"},"type":"input","opts":{"types":["str"]}}}],"meta":{},"credentials":{"password":""},"color":"#87A980","icon":"node-red/redis.png"},{"id":"16a2e08a3a5bec35","type":"function","z":"032dd27dda5cb68c","name":"","func":"msg.method = \"POST\"\nmsg.payload = {\n \n client_id:\"node-red-admin\",\n grant_type:\"password\",\n scope:\"read\",\n username:env.get(\"username\"),\n password:env.get(\"password\")\n}\nmsg.url = `${env.get(\"url\")}/auth/token`\n\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":420,"y":24,"wires":[["dfa1e2b905edcc46"]]},{"id":"a5e1d338a25671de","type":"http request","z":"032dd27dda5cb68c","name":"","method":"use","ret":"obj","paytoqs":"ignore","url":"","tls":"","persist":false,"proxy":"","authType":"","senderr":false,"x":602,"y":120,"wires":[["3d14412c41abe1f2"]]},{"id":"c4dd11976e8f6754","type":"function","z":"032dd27dda5cb68c","name":"","func":"msg.method = \"GET\"\nmsg.headers = {\n \"Authorization\": `Bearer ${flow.get(\"nr_api_token\")}`\n}\nmsg.url = `${env.get(\"url\")}/flows`\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":444,"y":120,"wires":[["a5e1d338a25671de"]]},{"id":"644ad4ea5196ed50","type":"switch","z":"032dd27dda5cb68c","name":"check token","property":"nr_api_token","propertyType":"flow","rules":[{"t":"null"},{"t":"nnull"}],"checkall":"true","repair":false,"outputs":2,"x":194,"y":72,"wires":[["16a2e08a3a5bec35"],["c4dd11976e8f6754"]]},{"id":"cce6ce997d307379","type":"change","z":"032dd27dda5cb68c","name":"set token","rules":[{"t":"set","p":"nr_api_token","pt":"flow","to":"payload.access_token","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":732,"y":24,"wires":[["c4dd11976e8f6754"]]},{"id":"3d14412c41abe1f2","type":"switch","z":"032dd27dda5cb68c","name":"","property":"statusCode","propertyType":"msg","rules":[{"t":"eq","v":"401","vt":"num"},{"t":"else"}],"checkall":"true","repair":false,"outputs":2,"x":746,"y":120,"wires":[["16a2e08a3a5bec35"],["17dfeaf4dd4b5b71"]]},{"id":"dfa1e2b905edcc46","type":"http request","z":"032dd27dda5cb68c","name":"","method":"use","ret":"obj","paytoqs":"ignore","url":"","tls":"","persist":false,"proxy":"","authType":"","senderr":false,"x":574,"y":24,"wires":[["cce6ce997d307379"]]},{"id":"17dfeaf4dd4b5b71","type":"change","z":"032dd27dda5cb68c","name":"","rules":[{"t":"set","p":"tabs","pt":"msg","to":"payload[type='tab'].id","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":918,"y":120,"wires":[["040e7a2e99c6da14"]]},{"id":"040e7a2e99c6da14","type":"function","z":"032dd27dda5cb68c","name":"","func":"method = \"GET\"\nheaders = {\n \"Authorization\": `Bearer ${flow.get(\"nr_api_token\")}`\n}\n\nmsg.tabs.forEach(t => {\n url = `${env.get(\"url\")}/flow/${t}`\n node.send({method,headers,url})\n})\n\n\n\nreturn null","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1068,"y":120,"wires":[["b22a1eadbf4bdd26"]]},{"id":"b22a1eadbf4bdd26","type":"http request","z":"032dd27dda5cb68c","name":"","method":"use","ret":"obj","paytoqs":"ignore","url":"","tls":"","persist":false,"proxy":"","authType":"","senderr":false,"x":1222,"y":120,"wires":[[]]},{"id":"8abf87dadc5b1c7e","type":"subflow:032dd27dda5cb68c","z":"dd68845f3195d3c5","name":"","x":574,"y":816,"wires":[[]]}]

```

---

<div class="post-metadata">

**Author:** ![hardillb](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hardillb/32/12373_2.png) [@hardillb](https://discourse.nodered.org/u/hardillb)\
**Post date:** [15 April 2022 07:37 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/3 "2022-04-15T07:37:25Z")

</div>

You will have to build your own storage plugin ([Storage API : Node-RED](https://nodered.org/docs/api/storage/)) that supports what ever database you want to use.

There are some example versions out there e.g. here is one I wrote to store flows in mongodb [Node-RED Storage Plugin – Ben's Place](https://www.hardill.me.uk/wordpress/2020/10/05/node-red-storage-plugin/)

And you will need to parse the single JSON object which represents the entire application into seperate tabs if you want to store them separately (you will also need to recombine them for any load event as the API expect yo get the whole object back, not just a single tab).

---

<div class="post-metadata">

**Author:** ![weber\_j](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/weber_j/32/60113_2.png) [@weber\_j](https://discourse.nodered.org/u/weber_j)\
**Post date:** [15 April 2022 08:12 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/4 "2022-04-15T08:12:33Z")

</div>

ok, that means i need to change too many model and function, thats difficult, thank u for answer 😁

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [15 April 2022 11:09 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/5 "2022-04-15T11:09:09Z")

</div>

Not sure who you are responding to, but my api approach is quite simple. Every payload you can store as a string into a database you can make relations mappings where needed.

---

<div class="post-metadata">

**Author:** ![weber\_j](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/weber_j/32/60113_2.png) [@weber\_j](https://discourse.nodered.org/u/weber_j)\
**Post date:** [18 April 2022 07:21 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/6 "2022-04-18T07:21:55Z")

</div>

Think you , i have tried your way, that can solve to save flows into database ,but how can i modify my single flow every opeartion and save it into database , i think i need to edit code logic when i save flow, i only need to save flow which flow has modified , but its connect so many model

---

<div class="post-metadata">

**Author:** ![weber\_j](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/weber_j/32/60113_2.png) [@weber\_j](https://discourse.nodered.org/u/weber_j)\
**Post date:** [18 April 2022 07:29 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/7 "2022-04-18T07:29:54Z")

</div>

this question means i hope to add/delete/edit/find flows by database-storage

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [18 April 2022 12:06 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/8 "2022-04-18T12:06:39Z")

</div>

Ben has already given you the answer but you don't want to do it.

---

<div class="post-metadata">

**Author:** ![weber\_j](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/weber_j/32/60113_2.png) [@weber\_j](https://discourse.nodered.org/u/weber_j)\
**Post date:** [18 April 2022 12:42 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/9 "2022-04-18T12:42:33Z")

</div>

thank for his answer again  
i have tried this plugin ,but it saves all json, i wish to save single flow every data

 ![1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/b/8bd76bda5c8b714bcfb4cc81794c3367f8c6430b.png)

---

<div class="post-metadata">

**Author:** ![hardillb](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hardillb/32/12373_2.png) [@hardillb](https://discourse.nodered.org/u/hardillb)\
**Post date:** [20 April 2022 11:50 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/10 "2022-04-20T11:50:26Z")

</div>

> And you will need to parse the single JSON object which represents the entire application into seperate tabs if you want to store them separately (you will also need to recombine them for any load event as the API expect yo get the whole object back, not just a single tab).

As I clearly stated, that is an example to get you started, you WILL have to edit it to do what you want.

---

<div class="post-metadata">

**Author:** ![weber\_j](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/weber_j/32/60113_2.png) [@weber\_j](https://discourse.nodered.org/u/weber_j)\
**Post date:** [21 April 2022 03:47 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/11 "2022-04-21T03:47:14Z")

</div>

ok i understand it thanks a lot

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [20 June 2022 03:47 UTC](https://discourse.nodered.org/t/how-to-save-single-flow-in-my-local-database/61315/12 "2022-06-20T03:47:59Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.