How can I make a key value dictionary using jq? If I do: cat api_fm.json | jq -r "[ .[].name, .[].status ]" I receive: [ "plugin", "c_docker_2", "c_docker_5", "c_docker_4", "c_docker_3", "c_docker_1", "Started", "Started", "Started", "Started", "Started", "Started" ] So, I…
This is the POJO: public class MyPojo { String id; double myNumber; } This is my JSON: { "id": "id1", "my_number": 10.0 } This is my conversion code: // from is the JSON String from Above Map<String, Object> myData =…
So I can read a json file with serde_json: use std::fs::File; use std::io::Read; use serde_json::Value; use crate::scene_builder::SceneBuilder; fn json_hello_world() { // Some JSON input data as a &str. Maybe this comes from the user. let data = r#" { "name":…
I am using TRestClient>TRestRequest>TRestResponse>TRESTResponseDataSetAdapter to retrieve JSON data from a Rest API. This works well and I create a TClientDataset in memory: // Create a new in memory dataset gStaffTable := TClientDataset.Create(nil); with gStaffTable do begin // Add some fields…
To use only 5 comma separated string values at a time in an API endpoint. I am putting all the string values of a list in a variable(val) using .join method to only get 5 values at a time. values…
I am using Oracle Apex 22.2 and Oracle Database XE 21c on CentOS 7. I want to loop through all the nested elements in a JSON document/CLOB and achieve the Canonical String (shown below). Also, any suggestions on improving my…
Trying to figure out how to convert multiple rows of data to a single row of KeyValue array Setup: using MS SQL SERVER 2017 raw data: Select s.id, s.FkId, s.name ,s.value from tbl s where FkId = 1024180 id |…
I have the following struct that I need to encode into JSON and output to an io.Writer object: type Data struct { FieldA string `json:"field_a"` FieldB int `json:"field_b"` Rows io.Reader `json:"rows"` } Rows is an io.Reader object that will return…
I have a json that is like the following: [ {"id":1,"nome":"smartform","url":"smartform.php","label":"Dashboard","icon":"fas fa-th-large","data_attribute":"","parent":"Smartform"}, {"id":2,"nome":"form_wizard","url":"form_wizard.php","label":"Crea uno Smartform","icon":"fas fa-plus","data_attribute":"data-action="create" data-step="0" data-token="0"","parent":"Smartform"}, {"id":3,"nome":"fullcalendar","url":"fullcalendar.php","label":"Calendario","icon":"far fa-calendar","data_attribute":"","parent":"Tools"}, {"id":4,"nome":"gantt","url":"gantt.php","label":"Gantt","icon":"fas fa-stream","data_attribute":"","parent":"Tools"}, {"id":5,"nome":"timesheet","url":"timesheet.php","label":"Timesheet","icon":"fas fa-hourglass","data_attribute":"","parent":"Tools"}, {"id":6,"nome":"kanban","url":"kanban.php","label":"Kanban","icon":"fas fa-list-ul","data_attribute":"","parent":"Tools"}, {"id":7,"nome":"openpoints","url":"items.php?tipo=openpoints","label":"Open Points","icon":"fas fa-keyboard","data_attribute":"","parent":"Risk Management"}, {"id":8,"nome":"risks","url":"items.php?tipo=risks","label":"Rischi","icon":"fas fa-exclamation","data_attribute":"","parent":"Risk Management"}, {"id":9,"nome":"issues","url":"items.php?tipo=issues","label":"Issue","icon":"fas fa-fire","data_attribute":"","parent":"Risk Management"}, {"id":10,"nome":"changerequests","url":"items.php?tipo=changerequests","label":"Change Requests","icon":"fas fa-plus","data_attribute":"","parent":"Risk Management"}…
I am trying to split the below array { "Base/Brand/0101-color-brand-primary-red": "#fe414d", "Base/Brand/0106-color-brand-secondary-green": "#00e6c3", "Base/Brand/0102-color-brand-primary-light-gray": "#eaecf0", "Base/Brand/0107-color-brand-secondary-black": "#000000", "Base/Brand/0103-color-brand-primary-white": "#ffffff", "Base/Brand/0108-color-brand-secondary-dark-gray": "#b4b4b4", "Base/Brand/0104-color-brand-secondary-blue": "#079fff", "Base/Light/Extended/Red/0201-color-extended-900-red": "#7f1d1d", "Base/Brand/0105-color-brand-secondary-yellow": "#ffe63b", "Base/Light/Extended/Red/0202-color-extended-800-red": "#991b1b" } to something like this { "Base": { "Brand": { "0101-color-brand-primary-red":…