# Hello! Is it possible to extract data with an htpp request from a database based on id you provide in an insert field and the result to be an table that contains that id. Node-RED v3.0.2, docker

**URL:** <https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125>\
**Category:** General\
**Tags:** http-request\
**Created:** [23 November 2023 09:02 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125 "2023-11-23T09:02:05Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![JanIwnl](https://avatars.discourse-cdn.com/v4/letter/j/b3f665/32.png) [@JanIwnl](https://discourse.nodered.org/u/JanIwnl)\
**Post date:** [23 November 2023 09:02 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125/1 "2023-11-23T09:02:05Z")

</div>

i want dynamically the flow to search and extract (based on the id i give in the insert field) the table containg that id.  
This is the format of the table:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/9/e927b22a5fce0b5d126ebeebd937cdd3ca2ada08.png)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 November 2023 09:36 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125/2 "2023-11-23T09:36:30Z")

</div>

Do you want node-red to do an http request on an external server, or do you want an external client to perform an http request into node red to get the data? If the latter then you need to use HTTP In and HTTP Response nodes in node red.

---

<div class="post-metadata">

**Author:** ![JanIwnl](https://avatars.discourse-cdn.com/v4/letter/j/b3f665/32.png) [@JanIwnl](https://discourse.nodered.org/u/JanIwnl)\
**Post date:** [23 November 2023 10:13 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125/3 "2023-11-23T10:13:41Z")

</div>

i want node-red to do an http request on an external server, is an oracle server.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 November 2023 11:19 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125/4 "2023-11-23T11:19:01Z")

</div>

What don't you know how to do?

---

<div class="post-metadata">

**Author:** ![JanIwnl](https://avatars.discourse-cdn.com/v4/letter/j/b3f665/32.png) [@JanIwnl](https://discourse.nodered.org/u/JanIwnl)\
**Post date:** [23 November 2023 11:24 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125/5 "2023-11-23T11:24:02Z")

</div>

In the http req i have something like this /CRISTI\_TEST?klt\_id={{KLT\_ID}} where CRISTI\_TEST is the actual table and that klt\_id is the id that i insert in the insert field. What i actually want is when i insert an id from another table not CRISTI\_TEST the flow to go automatically based on id that i will insert and retrive me the table in the dashboard. Is there any solution to this? I dont know how to make the function that dynamically get the table name and call it after i insert the id.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 November 2023 20:39 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125/6 "2023-11-23T20:39:19Z")

</div>

Sorry, I do not understand what you mean.

In terms of building the query it may be that a template node is the easiest way to do it (not ui\_template).

---

<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:** [22 January 2024 20:39 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125/7 "2024-01-22T20:39:29Z")

</div>

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