How to get index of element in array in JSONata

Question

JSONata provides several functions to operate on array contents. However, I am at a loss to determine how to return the index of a found element (similar to the Array.indexOf function in JavaScript). I'm looking for something like:

$indexOf(Account.Order[OrderID="order103"])
or
Account.Order.indexOf(OrderID="order103")
or
Account.Order[OrderID="order103"].index

I have posted a proposed solution in the JSONata github issues that takes the form $indexOf(array, searchObject) to return the index if found, or -1 if not found or invalid parameters. — wnm3
– wnm3, Commented Apr 4, 2018 at 20:34

Andrew Coleman · Accepted Answer · 2018-10-31 11:24:44Z

2

Try this:

Account.Order ~> $map(function($v, $i) { $v.OrderID = 'order103' ? $i })

answered Oct 31, 2018 at 11:24

Andrew Coleman

1,61711 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

tonymayoral · Accepted Answer · 2018-06-11 16:30:30Z

2

You could merge map's index:

Account.Order ~> $map(function($v, $i) {
  $merge([{'Index': $i}, $v])
})~>function($x){$x[OrderID="order103"].Index}

answered Jun 11, 2018 at 16:30

tonymayoral

5,2872 gold badges28 silver badges27 bronze badges

Comments

Suraj Rao · Accepted Answer · 2023-02-14 05:28:04Z

1

Accout.Order.OrderId#$i["order103" in $].$i

This is a built in way so should be faster

edited Feb 14, 2023 at 5:28

Suraj Rao

29.7k11 gold badges96 silver badges104 bronze badges

answered Feb 14, 2023 at 5:26

Saqib Shakil

1111 silver badge4 bronze badges

1 Comment

wnm3 Over a year ago

While Account.Order.OrderID#$i["order103" in $].$i returns 0 Account.Order.OrderID#$i["order104" in $].$i also returns 0 but should be 1

wnm3 · Accepted Answer · 2019-01-08 22:33:21Z

0

Neither proposed solution ensured a valid response if not found but adding the additional test seems to do what I'd expected:

($x:=Account.Order ~> $map(function($v, $i) { $v.OrderID = 'order101' ? $i });
$exists($x)?$x:-1)

will return -1

($x:=Account.Order ~> $map(function($v, $i) { $v.OrderID = 'order103' ? $i });
$exists($x)?$x:-1)

will return 0

($x:=Account.Order ~> $map(function($v, $i) { $v.OrderID = 'order104' ? $i });
$exists($x)?$x:-1)

will return 1

answered Jan 8, 2019 at 22:33

wnm3

4416 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to get index of element in array in JSONata

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related