Help with JSONata

General
1

Hello everyone!

I am facing issues where I am trying to query specific data from an array, example, if i only want the names for both routers , how do i do it? As I searched up, using jsonata would be easier but i am still new to using JSONata.

It would be really great if you could guide me on this!

image

2

Personally I prefer to use a function node. Something like
const names = msg.payload.map(e => e.name)

3

Hi @Colin ,

Thanks for the suggestion , but when i enter the code into the function node, it didn't display anything.

4

What do you mean by didn't display anything? Feed the function node into a debug node to see what it sends. The line I posted puts the new array into a variable, did you put that in msg.payload?

5

Did you leave return msg at the bottom of the function?
Did you set the msg.payload?

e.g.

const names = msg.payload.map(e => e.name)
msg.payload = names
return msg
1 Like
6

ohh I forgotten about that my bad!

7

It works! I am able to get the data, but is there a way I can combine these two names into one sentence?

image

8

Exactly what do you want out?

9

What i would like out from the output is,

For example Type: "Router" Total_Quantity_left: "0", Type: "Bosch Router" Quantity: "0" as the output in a single line.

But not sure if it could be done.
image

10

That doesn't seem to be much related to the original question. For that I think you will need a forEach loop that builds up the string. Or Array.reduce() to do the same thing,

11

is there an example? where i can achieve this function.

12

You first ask "i only want the names for both routers" now you want text from multiple properties - all in one line!

Please be concise with your questions & avoid changing your mind as we all contribute our free time helping out.

Moving on...

You can achieve a single line of text by looping through the array and generating a new string consisting of the parts you want. Then join the resulting strings with a ", "

Here is the result (of some dummy data) in the format you request (the function code will follow)

image
image1034Ă—161 6.04 KB

Function code (ES6 way)

msg.payload = msg.payload.map(e => {
    return `Type: "${e.Type}"  Total_Quantity_left: "${e.Total_Quantity_left}"`
}).join(', ')
return msg;

Alternative Function code (long hand for beginners)

const inputData = msg.payload
const formattedData = [] // make a new empty array

// loop the input array and make a formatted string
// then add that string to the new array
for (let index = 0; index < inputData.length; index++) {
    const entry = inputData[index];
    const entryAsString = 'Type: "' + entry.Type + '"  Total_Quantity_left: "' + entry.Total_Quantity_left + '"'
    formattedData.push(entryAsString)
}
const singleString = formattedData.join(', ')
msg.payload = singleString //set the msg's payload to the result
return msg; // return the msg to next node
13

To answer the OG question for future readers that are looking for a JSONata answer

$$.payload.name

will return an array of names

And to output as post 9 example

$join(
   $$.payload.(
       'Type: "' & $.Type & '"  Total_Quantity_left: "' & $.Total_Quantity_left & '"'
   ),
   ", "
)
1 Like
14

I apologize for not correctly formatting my questions.

But Thank you so much for your guidance, I will try it out!

Once again Thank you very much! :sweat:

1 Like
15

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