# 1. Getting Data From the Data Warehouse

In this part of the workflow you will learn how to get data by making HTTP requests using the HTTP Request node.

First, let’s set up the scene for building Nathan’s workflow. Open your Editor UI and create a new workflow with one of the two possible commands:

  • Click Ctrl + Alt + N or Cmd + Option + N on your keyboard
  • Open the left menu and click on New under the Workflow section

Name this new workflow “Nathan’s workflow”.

The first thing we need to do is get data from Evil Corp’s old data warehouse.

In the previous chapter, we used a regular node for a specific app (Hacker News). However, not all apps or services have dedicated nodes – like the legacy data warehouse from Nathan’s company. Nathan mentioned that it’s not possible to directly export the data, however the data warehouse has a couple of API endpoints.

That’s all we need to access the data via the HTTP Request node (opens new window)in n8n.

💡 No node for that service?

The HTTP Request node is one of the most versatile nodes, allowing you to make HTTP requests which can be used to query data from apps and services. You can use it to access data from apps or services that don’t have a dedicated node in n8n.

Now, in your Editor UI, add an HTTP Request node like you learned in the lesson Adding nodes. The node window will open, where you need to configure some parameters.

HTTP Request node
HTTP Request node

In the left panel, select:

  • Authentication: Header Auth
  • URL: https://internal.users.n8n.cloud/webhook/custom-erp
  • Options > Add Option > Split Into Items: toggle to true. This option will output each element of an array as its own item.
  • Headers > Add Header:
    • Name: unique_id
    • Value: your_unique_id

Note: In case you don't already have your Unique ID, please sign-up here (opens new window) to obtain it.

Since you selected Header Authentication, now you need to enter your credentials (opens new window) in order to be able to access the data.

📖 Credentials

Credentials are unique pieces of information that identify a user or a service and enable them to access apps or services (in our case, represented as n8n nodes). A common form of credentials is a username and a password, but they can take other forms depending on the service.

Go to the top parameter Credentials and click on Create New. This will open the Credentials window where you need to add information to three fields:

  • Credentials Name: beginner_course

    You can name your credentials however you want. It’s good practice to give them descriptive names for the app/service, type, and purpose of the credential. A naming convention will make it easier for you to keep track of and identify your credentials.

  • Name: api_key

  • Value: j[vKYdY68H(:WFb

Your Credentials window should look like this:

HTTP Request node credentials
HTTP Request node credentials

Now click the Save button in the bottom right corner of the window.

In the HTTP Request node window, click the Execute Node button. The result of the HTTP request should look like this:

HTTP Request node window
HTTP Request node window

This view should be familiar to you from the Hacker News mini-workflow. This is the data from EvilCorp's data warehouse that Nathan needs to work with. This data set includes sales information of 30 customers with 5 features:

  • orderID: The unique id of each order.
  • customerID: The unique id of each customer.
  • employeeName: The name of Nathan’s colleagues who are responsible for each client.
  • orderPrice: The total price of the customer’s order.
  • orderStatus: Whether the customer’s order is booked or still in processing.

# What's next?

Nathan 🙋: This is great! You already automated an important part of my job with only one node. Now instead of manually accessing the data every time I need it, I can use the HTTP Node to automatically get the information.

You 👩‍🔧: Exactly! In the next step, I’ll help you one step further and insert the received data into Airtable, as you need it.