I'm trying to compare this array of object : "platforms": [ { "id": 1, "name": "KF", "bankAccounts": [ { "id": 22, "balance": -100, "lendingPlatformId": 3 }, { "id": 27, "balance": 500, "lendingPlatformId": 4 } ], }, { "id": 3, "name":…
I'm working with Snowflake. I'm executing these statements: create table test( src varchar ); insert into test values ('{"value": {"evaluation_forms": [ {"evaluations": [ {"channel_meta": {"after_call_work_time": [], "agent_first_name": ["KATRINA"], "agent_hung_up": [], "agent_last_name": ["COX"], "agent_unique_id": ["LO_00130604"], "agent_username": [], "alternate_call_id": [], "total_time": []…
I have a json file (estate.json) that looks like this: { "type": "FeatureCollection", "features": [ { "type": "Feature", "id": "724543e2-bd9d-4bef-b9d6-a3ae73d330b7", "properties": { "objektidentitet": "724543e2-bd9d-4bef-b9d6-a3ae73d330b7", "adressplatsattribut": { "adressplatstyp": "Gatuadressplats", "insamlingslage": "Infart" } } }, { "type": "Feature", "id": "1209dd85-d454-46be-bf9c-f2472095fcdc", "properties": {…
{ "results": [ { "content1": { "prop1" : "value1", "prop2" : "value2" }, "content2": { "prop1" : "value1", "prop2" : "value2" }, "contentn": { "prop1" : "value1", "prop2" : "value2" } } ] } I am having trouble converting this…
Input JSON value : { "age": [ { "r": "r1", "d": "{}" } ] } Desired Output : { "age": [ { "r": "r1", "d": {} } ] } I tried using modify-overwrite-beta but unable to replace string by empty…
Not quite getting it. I can produce multiple lines but cannot get multiple entries to combine. Looking to take Source JSON and output to CSV as shown: Source JSON: [{"State": "NewYork","Drivers": [ {"Car": "Jetta","Users": [{"Name": "Steve","Details": {"Location": "Home","Time": "9a-7p"}}]}, {"Car":…
My messages generator output $ ./messages.sh {"a":"v1"} {"b":"v2"} {"c":"v3"} ... Required output $ ./messages.sh | jq xxxxxx [{"a":"v1"},{"b":"v2"}] [{"c":"v3"},{"d":"v4"}] ...
I want to transform a JSON array using a JOLT specification. My input: [ { "list": [ "item1" ] } ] My desired output: [ { "list": [ { "listType": "1", "listValue": "item1" } ] } ] The goal is…
Is it possible to return matching values by comparing JSON arrays. For example; 0 : ['cat1', 'cat2'] 1 : ['cat2', 'cat3'] 2 : ['cat2', 'cat4'] The above should return 'cat2' as that exists in all 3 arrays. EDIT: I found…
I have a folder structure that looks like this: 1. data 1.1. ABC 1.1.1 monday_data monday.json 1.1.2 tuesday_data tuesday.json 1.2. YXZ 1.2.1 wednesday_data wednesday.json 1.2.2 etc I want to unpack all of these json files into a pandas dataframe in…