I have the following json: { "virtual_machines": [ { "guest_name": "guest1", "mac_address": [ "00:01:02:03:04:05" ], "vm_network": { "00:01:02:03:04:05": { "ipv4": [ "192.168.2.23" ], "ipv6": [ "fe80::896:2e12:c059:4237" ] }, "c2:e3:7c:ac:60:c5": { "ipv4": [ "10.42.0.0" ], "ipv6": [] }, "5a:00:fb:5e:3d:65": { "ipv4":…
I have a string like this var string = "1234|Tom|NYC|Student|Active" and I want to map to something like in typescript NodeJS API { "Id": 1234, "Name": "Tom", "City": "NYC", "Title": "Student", "Status": "Active", } Here the key comes from a…
I have a snowflake table as below table name: raw_data id conv_type transcript 1 chat [{"by":"sys", "text":" can I help you?", "time":"2023-01-01 11:11:11", "comments":""},{"by":"person1", "text":" yes tell me", "time":"2023-01-01 11:12:11", "comments":""}] 2 phone [{"by":"sys", "text":" can I help you with?",…
I have a console C# app and i use Google Sheets API to get data from spreadsheet. API returns me the following: {"majorDimension":"ROWS","range":"Sheet1!A2:H1000","values":[["Test1","20/07/2023","21/07/2023"],["Test2","10/08/2023","12/08/2023"]],"ETag":null} These "values" are actually the values from the cells, and I need to loop through those values…
How to replace text between 2 characters MULTIPLE TIMES in a huge string (50,000 characters) in T-SQL? I have a JSON output from my Azure Pipeline which we drop into a single cell in a table ready for the stored…
How can I transform(remove in this case) flowfile if one of the fields of the object is null using JoltTransformJson processor in nifi here below is my data. emp.json: [ { "Name" : "john Smith", "DOB" : "2000-07-14", "Salary" :…
I have this data: [ { "key": 111, "studentInfo": [ { "details": { "calculated_fields": null, "status": false } } ] }, { "key": 222, "studentInfo": [ { "details": { "calculated_fields": null, "status": false } } ] }, { "confidential": {…
I have been using Youtube to help me with learning how to use API and converting to JSON using SwiftUI. This is my first time actually using it and could use help, if possible please... this Is what my code…
I have a requirement to store the content of proto to mongoDB for which I am converting proto to json string and then converting to Document object. Some time the proto will have so much data upto 14mb which makes…
In my hive table T the field A is a string in json format and A stores a value of {"c_e_i":"{"e_c_f":1}"}. I want to get c_e_i."e_c_f" So I used get_json_object(T.A, '$.c_e_i.\"e_c_f\"') but it doesn't work. what should I do? I…