I have a response with nested array and I need to extract id's for objects which have attribute "isFolder" = false. How can I do that? I've tried using JSON extractor with pattern $.data.tileGrid.items[?(@.isFolder == false)][1].id also tried get an…
I have the following JSON and I would like to transform it with Jolt. JSON Input { "orderNo": "4800001", "resourceCode": "test", "createdBy": "27150173", "action": "R", "personId": "R", "userId": "test", "extraFields": { "a": "test", "b": "test" } } Jolt Transform tried…
A response.json() returns a JSON in the following format: { "workbooks": [ { "name": "WORKBOOK_A", "embeddedDatasources": [ { "upstreamTables": [ {"name": "WORKBOOK_A_TABLE_A"}]}, { "upstreamTables": [ {"name": "WORKBOOK_A_TABLE_B"}, {"name": "WORKBOOK_A_TABLE_C"}]}, { "upstreamTables": []}]}, { "name": "WORKBOOK_B", "embeddedDatasources": [ { "upstreamTables": […
I was able to format the json data as I expected and here's the code snippet that I tried so far: const data = [ { "id": 654298, "included": [ { "id": 654298, "levelColumn": "DIM4_COL5", "levelColumnName": "Region", "isIncluded": true, "tabs":…
I have a CSV file in which each row is a string that is already formatted for JSON. Some of the elements are nested within a given key. Here is a simplified sample row: {"key1":"string_value","key2":["string_value"],"key4":integer,"key5":[{"nested_key1":"string_value","nested_key2":boolean}],"key6":integer} I need to take each…
I created a dictionary of ansible packages filtered from ansible.package_facts, to only contain packages of a specific version. (example shown below) "filtered_ansible_packages": { "cool_package1": [ { "arch": "noarch", "epoch": "null", "name": "cool_package1", "release": "el7", "version": "1.2.6" } ], "cool_package2": […
We are doing an In-Place Upgrade from RHEL 7 to RHEL 8 in my organization and we've come to find out that not all RHEL 7 packages are removed after an OS Upgrade. I've been asked to report on all…
I have result.json - saved data from Telegram. how do I find a message containing a specific text and messages by id? code: import json with open('result.json', encoding="utf8") as f: msgs = json.load(f) for reply_to_message_id, text in msgs.items(): if 'sometext'…
I'm trying to decode this JSON called Menu.json [ { "day": "Monday", "locationName": "Memorial Union Quad", "coordinate": [38.54141, -121.74845], "menu": { "Penne Pasta w/ Bolognese" : ["🌾","🐷"], "Penne Pasta w/ Roasted Mushrooms" : ["🌾","V"] } }, { "day": "Tuesday", "locationName":…
I currently have a graphQL endpoint that has a request body with two json objects, variables and query. The request body should look like below: { "variables": {}, "query": "{n uploadQueueSummary {n fileNamen createdByn salesIdn completedRowsn totalRowsn uploadUUIDn uploadTimen statusn…