json Questions

Javascript Adding a new key value pair in the JSON array

September 1, 2023
SteveS
3 Answers

I have below json string & want to create new Json Array from this data Raw Data: [ ["yrxqBHmPkNhZ60_eab97ebf-c2a3-40a5-972a-91597ad9a4ca_99371", "SUCCEEDED", "2023-08-31T21:59:31.325000+05:30", "2023-08-31T22:13:42.165000+05:30"], ["yrxqBHmPkNhZ60_f42702be-16c3-44bf-bc3b-6719c740a5e3_98405", "SUCCEEDED", "2023-08-31T21:43:25.581000+05:30", "2023-08-31T21:57:47.681000+05:30"], ["rk9QMf81WrT7DO_edd6e8de-9de4-4885-b970-9311443d81d5_98750", "SUCCEEDED", "2023-08-31T21:49:10.578000+05:30", "2023-08-31T21:56:20.197000+05:30"] ] I have tried below code to convert this into…

VIEW QUESTION

Javascript – Fetch and display json object from api in the project

September 1, 2023
Mac S
3 Answers

import React, { useEffect, useState } from "react"; import { v4 as uuidv4 } from "uuid"; export default function Aapi() { const [record, setRecords] = useState([]); var arr = []; useEffect(() => { fetch("https://ipinfo.io/json?token=93ogbcdhee0a74") .then((response) => response.json()) .then((jsonResponse) => {…

VIEW QUESTION

Jsonata filter group by parent element

September 1, 2023
Amit Chauhan
2 Answers

I have json object as follows {"resources":[{"srno":"1","name":"name1","projects":[{"prjname":"abc"}]},{"srno":"1","name":"name1","projects":[{"prjname":"def"}]},{"srno":"2","name":"name2","projects":[{"prjname":"abc"}]},{"srno":"4","name":"name4","projects":[{"prjname":"prq"}]},{"srno":"4","name":"name4","projects":[{"prjname":"stu"}]},{"srno":"4","name":"name4","projects":[{"prjname":"uvw"}]},{"srno":"5","name":"name5"}]} How can I get resources grouped by id,name - each of that should contain list of projects? basically,flattened to structured i.e. {"resources":[{"srno":"1","name":"name1","projects":[{"prjname":"abc"},{"prjname":"def"}]},{"srno":"2","name":"name2","projects":[{"prjname":"abc"}]},{"srno":"4","name":"name4","projects":[{"prjname":"prq"},{"prjname":"stu"},{"prjname":"uvw"}]},{"srno":"5","name":"name5"}]} can someone share jsonata expression to create same

VIEW QUESTION

JQ logic for json modification

September 1, 2023
infotechsups
2 Answers

I have system that output multiple types of JSON file with data Is there any chance to implement above three conditions using JQ package? I am exploring map, arg and argjson command. But I am having tough time First JSON…

VIEW QUESTION

How to iterate JSON array in Ballerina

September 1, 2023
Kavindu Gimhan Zoysa
2 Answers

json data = {"vals": ["a", "b", "c"]}; How to iterate above JSON and get a,b,c?

VIEW QUESTION

Postgresql – Mapping json column keys onto matching column values from 2nd table

September 1, 2023
equallyhero
2 Answers

I have a table A, where data is a json column, and timestamp is a timestamp with timezone column: timestamp data 2023-08-29 13:00:00-04 { "a_123":{ "temp":85, "uv":5, "rain":0 }, "b_123":{ "temp":85, "uv":5, "rain":0 } } 2023-08-29 14:00:00-04 { "a_123":{ "temp":70,…

VIEW QUESTION

Merge 2 json files with python adding new "key":"value"

September 1, 2023
dilbar
2 Answers

Have 2 JSON files: First file is: { "Bob": { "tags": ["theme1", "theme2", "theme3" ]}, "John": { "tags": ["theme2", "theme3" ]} } and second file is: { "level1": { "level2": { "level3": { "Bob": { "gear": "Yes" }, "John": {…

VIEW QUESTION

Javascript – Regex for converting object notation to array values

August 31, 2023
Mr. Polywhirl
2 Answers

I am trying to convert objects defined within a file into arrays. I am using JSON.parse on the matched objects. Some of the multi-line objects are not being replaced. const txtara = document.querySelector('#demo'); const fixJSON = (invalidJson) => invalidJson .replace(/(w+)(?=s*:)/g,…

VIEW QUESTION

Conversion of JSON to XML using XSLT1.0

August 31, 2023
ven
3 Answers

I would like convert JSON which is part of XML to XML structure using XSLT1.0(reason is our aplication only supports XSLT1.0 version). Could someone be able to check and let me know on the same. Thank you XML(with JSON): Fom…

VIEW QUESTION

Json – Fastapi displays different output than original function with HuggingFace transformers' NER

August 31, 2023
chancar
2 Answers

I have created a API script with FastAPI to run a HF transformers' NER model. However I am puzzled to see that the output returning from the API doesn't match the output I get if run the model directly (the…

VIEW QUESTION