Help on listing the "Get" Data

Questions
#1

Hi,

I want to get the details of active servers and send it via email. My get Data is showing lot of details and some times only one server is active and sometimes 100 servers will be active. In my send email node I am using the previous workflow data as expression which is like below.
{{$node[“Server info”].json[“servers”][0][“hostname”]}}

[0] is sending only the first server in the list and ignoring all others. Is there a way I can list all of them with single expression.

#2

Hi @mahesh,

I recommend you adding a “Function” node and composing available servers with this snippet:

return [
{
json: {
  servers: $['Server info'].json['servers'].map(function(server) {
 return server.hostname;
}).join(",")
  }
}
]

You will be able to access to the “servers” property in the following nodes.

Hope this helps,

1 Like
#3

Hi Miquel,

I have created the function with the snippet you shared after the ‘Server Info’ node. I am getting the below error.

ERROR: $ is not defined

ReferenceError: $ is not defined
#4

You are right. It is my fault.

Replace $ by $node and it will work.

#5

Thanks @Miquel_Colomer
It worked. I added a list to the return to fetch other details like server ip.

return [server.hostname, server.ip]

I am getting the data output like below.

server1,ip1,server2,ip2

Any way to put this in table?

I don’t have programming skill. Can you suggest if we need to learn Node.js to understand and write these functions in the future? or any other programming?

#6

Yes. Just do this:

return $node['Server info'].json['servers'].map(function(server) {
 return {json: {server: server.hostname}};
}) ;

Let me know if works.

#7

This is giving the same problem as I mentioned in the first post.

#8

Hey @mahesh!

Welcome to the community :slightly_smiling_face:

Can you please share the exact response you get? A screenshot of the output will be helpful.

#9

Ok. I get you.
What you need is generate a table output in html code to send it by email. Try this:

var content = "<tr>" + ($node['Server info'].json['servers'].map(function(server) {
 return "<td>" + server.hostname + "</td><td>" + server.ip + "</td>";
}).join("</tr><tr>")) + "</tr>";

return [
  {
  json: {
    output: "<table><tr><th>Hostname</th><th>Ip</th></tr>" + content + "</table>"
    }
  }
]

I recommend you to read any Javascript tutorial like this

or check existing js snippets done by n8n team at

Hope this works.

1 Like
#10

This is perfect @Miquel_Colomer. Thanks a lot !!

I will read on javascript and thanks for sharing the links.

1 Like
#11

You are welcome.

Enjoy n8n!

1 Like