# How do I get data from database and send it to postman using postman
**URL:** https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072
**Category:** General
**Created:** [5 March 2021 09:13 UTC](https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072 "2021-03-05T09:13:00Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Darshil](https://discourse.nodered.org/u/Darshil)
#### Post date: [5 March 2021 09:13 UTC](https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072/1 "2021-03-05T09:13:00Z")
I have recently started using Node-Red.
I want to understand how could I send data from my MySQL database to postman using Node-Red.
I was advised to use GET option in http in node to send data to postman.
I not sure how it works.
Thanks in advance
---
### Author:  [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [5 March 2021 09:20 UTC](https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072/2 "2021-03-05T09:20:38Z")
Perhaps I am missing something, but isn't postman just an API (dev/testing) client ? This is what the http request node can do as well.
The cookbook has [some examples](https://cookbook.nodered.org) about get/post requests.
---
### Author:  [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [5 March 2021 09:28 UTC](https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072/3 "2021-03-05T09:28:51Z")
As Mr Backman says, Postman is simply a tool for issuing API calls and seeing the responses. I stopped using it in favour of an extension for VScode that lets me create a suitable file, click to issue commands and get responses back, all inside VScode which is very convenient.
The simplest way to create an API with Node-RED is to use a combination of the http-in and http-out nodes. The -in node defines the API endpoint (URL and Type - e.g. GET/PUT/...). The -out node provides the response back to the requestor. In between, you can add other nodes that formulate the required output.
---
### Author:  [@Darshil](https://discourse.nodered.org/u/Darshil)
#### Post date: [5 March 2021 09:35 UTC](https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072/4 "2021-03-05T09:35:34Z")
Okay,
So how can I get the URL for connecting my database??
---
### Author:  [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [5 March 2021 09:50 UTC](https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072/5 "2021-03-05T09:50:51Z")
Database connections go over tcp and ports, not over url's.
So if you know the host (ip/fqdn) your database is running on and it is mysql, it is port 3306. For this you will need to have something like [the mysql node](https://flows.nodered.org/node/node-red-node-mysql) installed.
---
### Author:  [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [5 March 2021 15:22 UTC](https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072/6 "2021-03-05T15:22:19Z")
I think we are talking at cross-purposes.
Node-RED provides the URL - you define it when you use the http-in node.
You then need to write a flow that fits between the http-in and http-out nodes that queries your db, returning the results to the msg.payload that you then pass to the http-out node.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [4 May 2021 15:22 UTC](https://discourse.nodered.org/t/how-do-i-get-data-from-database-and-send-it-to-postman-using-postman/42072/7 "2021-05-04T15:22:23Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.