Skip to main content
251 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
48 views

The context is the design of an AWS Step Function, using the Amazon States language. I want to call a lambda Task as a step. The state output of this step should be the merger of state input and a ...
Sean B. Durkin's user avatar
  • 12.8k
0 votes
1 answer
58 views

I am trying to use JSONata for my new step function and I am having issues setting the MessageGroupId and MessageDeduplicationId, for some reason they are not taken into account so it deduplicates the ...
David Marciel's user avatar
  • 947
0 votes
1 answer
66 views

I'm getting this type of JSON back from a system, and I need to combine it into an array of name-value pairs (typical to how, say, .NET would serialize DataTable). { "totalRows": 10, &...
L Szij's user avatar
  • 1
-1 votes
1 answer
93 views

I have UUIDs stored in DynamoDB. In the ddb table, they are stored as binary ('B' AttributeValues) 32 byte values. When queried with GetItem, this data is returned to the client as a base64 encoded ...
Nevo's user avatar
  • 968
0 votes
1 answer
29 views

Given a collection (not an array) like this: { "field1": { "type": "string", "value": "test" }, "field2": { "type&...
L Szij's user avatar
  • 1
2 votes
1 answer
71 views

I have an array of objects where each object has a timestamp. I need each object in the array to be given an additional property -- "elapsed" and have it assigned the milliseconds that ...
Shimbone's user avatar
  • 21
1 vote
1 answer
123 views

My JSON object has keys that are strings that are dynamically generated with the json is created. Trying to access the first key doesn't seem to work. This is my jsonata expression ( $firstDate := ...
Ritesh's user avatar
  • 13
1 vote
1 answer
91 views

Trying to filter out a specific string value in JSONata but getting unexpected results. JSON input: { "Account": { "Account Name": "Firefly", "Order": ...
Shree's user avatar
  • 25
1 vote
2 answers
89 views

I need to transform this json array: [ { "timestamp": "2025-01-19T17:00:00Z", "absoluteDeviationsX": [10, 11, 12 ] }, { "...
Martin Gonzalez's user avatar
  • 15
2 votes
2 answers
2k views

I want to evaluate jsonata expression in key in AWS Step functions. I tried this: { "ApplicationId": "ID", "SendUsersMessageRequest": { "MessageConfiguration&...
Hisham Syed's user avatar
  • 135
0 votes
1 answer
47 views

here I have to add price and quantity combined Excepted output: price 10+2=12 + Quantity2+1=3 combing both Excepted output as 12+3=15 (In JSONata how to do sum of the values) "Order": [ ...
Shree's user avatar
  • 25
0 votes
2 answers
64 views

How to add suffix like "st", "nd", or "rd" depending on number in JSONata? I want to achieve something like this: If number is 1, output "1st" If number is 2, ...
Shree's user avatar
  • 25
0 votes
2 answers
209 views

I am exploring JSONAta right now for fun and have a question on how to solve something. I would like to remove objects from an array that exist in another array based on a match of the entire object (...
rlk99's user avatar
  • 1
0 votes
1 answer
83 views

I would like to use JSONata to reformat a JSON response into a different structure grouped by values in the object. I've searched StackOverflow but cannot see an example that matches my needs. I ...
Stuart Marsh's user avatar
  • 17
0 votes
1 answer
95 views

I'm trying to get the results from a JSONata expression to print out using HTML and Javascript, but I'm not having any luck. The expression works in the JSONata playground and produces the array I ...
esstroud's user avatar
  • 1
0 votes
1 answer
46 views

Our company sells subscriptions. On renewal we want to get the subscription data, remove the discount rateplancharge, and maintain the entire data structure for other downstream processes. Here is ...
Alan Home's user avatar
  • 3
0 votes
3 answers
84 views

I am trying to remove an array object based on value of array object property by using JSONATA transform function but the array object is not getting removed. If pmtDtls.lnAprvlStatus ='D', the object ...
ashok jha's user avatar
  • 15
0 votes
2 answers
85 views

How can I merge the objects from "123" and "Trilby hat" { "123": { "Price": 68.9, "Qty": 2, "ProductID": 858383 }, "Trilby hat": ...
dags's user avatar
  • 31
1 vote
1 answer
117 views

I am trying to combine the information from two dictionaries into one. I have a JSON like this: { "First": { "example1": [ { "key": &...
Imaginary-Pea's user avatar
  • 27
0 votes
1 answer
232 views

Jsonata newbie here. I need help with Jsonata Transformation to extract a value from json element and make it as key . { "key-1":[{ "id":"a", "value":2.3 },{...
rage2spirit's user avatar
  • 3
1 vote
2 answers
509 views

How can I get the top 5 keys with the highest values from a JSON using JSONata? Let's say I have something like this. They keys aren't alphabetically ordered, but the values are descending and I want ...
Imaginary-Pea's user avatar
  • 27
0 votes
1 answer
544 views

For eg: if today's date is 03/39/2024, it should print after 60 days -05/28/2024 Code to get today's date: $fromMillis($toMillis($now()), '[M01]/[D01]/[Y0001]') But how to print for 60 calendar ...
Shree's user avatar
  • 25
0 votes
1 answer
328 views

i have a json object as in below { "_namespace": "kubernetes", "api_paths": [ { "api_action": "post", "api_path": "...
Venkat Akurathi's user avatar
  • 13
1 vote
1 answer
99 views

Given an example JSON data like this: { "payload": [ { "lspf_numlot": "22701-15", "prop_attrezzatura": "OP5 ...
Gippy73's user avatar
  • 13
1 vote
1 answer
71 views

The challenge arises when some entries have multiple categoryIds, resulting in difficulties in proper grouping I was able to group the data with the '$distinct' method, but some of the data has more ...
İsmail Can Karataş's user avatar
  • 77

1
2 3 4 5 6