python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - jsonata

How to loop through array JSONATA

Here is my array: { "tocontrol": [{"name": "john"},{"name": "doe"}] } I'm expecting below output: { "method": "OR", "mat...
test-img

Thomas Boulestin

json

node-red

jsonata

Votes: 0

Answers: 1

Latest Answer

In order to achieve the desired result, you need to use a . (map) expression: https://docs.jsonata.org/path-operators#-map This is what the finished result looks like: { "method": "...
test-img

Tomasz Łakomy

Display the data value after using jsonata

This is my json { "message":{ "Refno":"654" } } This is my jsonata file message.{ "data":"update/add", "Refno":($.data=update)?Refno:"&...
test-img

rama devi

jsonata

Votes: 0

Answers: 1

Latest Answer

I believe this is the proper JSONata expression for your problem: message.{ "data": $$.data, "Refno": ($$.data="update" ? $.Refno : "") } Note that I'm using $...
test-img

Tomasz Łakomy

Display the value depends on refrence number using jsonata

{ "message":{ "Data":"account/product", "Refno":"654" } } I need output like if data field is as account then Refno will be 64 If my data field is pro...
test-img

rama devi

jsonata

Votes: 0

Answers: 0

Only fields matching regexp

I wonder what is the best and more efficient way to filter out fields with regular expression. My jsons looks like: { "const": { "bt_L1": 1, "bt_L2": ...
test-img

Sebastian

grafana

jsonata

Votes: 0

Answers: 1

Latest Answer

This is not pretty, but it works: $spread(const)[* = 1].$keys() ~> $filter(λ($k) { $substring($k, 0, 4) = "bt_L" }) ~> $map(λ($k) { $substring($k, 3) }) ~> $join(", &q...
test-img

Chris Perkins

Posts

Questions

Blogs

Jobs