Here is what is returned from a API: [ { "id": "63c576504988e70xx", "value": { "text": "638dfbd58b3dde05xx" }, "idCustomField": "62ed5fa43601c14xxx", "idModel": "63c576504988e70249xxx", "modelType": "card" }, { "id": "63c576504988e71xx", "value": { "number": "8" }, "idCustomField": "62ed5fa43601c13xxx", "idModel": "63c576504988e70249xxx", "modelType": "card" }, {…
I'm looking for breaking nested JSON file and trying to flatten them to fit into a SQL database. Current JSON: { "content": { "failedPerProductLineAndReason": { "Product1": { "Downsizing licenses is not allowed": 1 } } } } Expected outcome: {…
I need to add new key/value pair into nested object array. this is exisiting array [{ "featureId": "67d6e1bf-3919-4dcc-b636-236ab41d431b", "featureName": "Test name 1", "rules": [ { "ruleId": "a9ab3ce2-e69c-4c0c-b561-1107baed1e68", "ruleName": "Sub test 1", }, { "ruleId": "a9ab3ce2-e69c-4c0c-b561-1107baed1e68", "ruleName": "Sub Test 2", },…
I have a column in the form of a dictionary: {"black": false, "white": true, "green": true, "blue": false, "red": true, "yellow": false, "pink": false, "orange": true} I want to turn it into a list of keys that has a true…
For a class similar to the following: class A{ @JsonProperty("hello_world") private String helloWorld; public String getHelloWorld(){...} public void setHelloWorld(String s){...} } When I try to convert it to a Json object via Obejct Mapper or GSON. new ObjectMapper().writeValueAsString(object); or gson.toJson(object);…
I am new to JOLT and I don't know much about it, and I need the JOLT spec to convert my below JSON to CSV file: { "bigRecords": [ { "Records": { "Name": "R1", "Id": "1P02XV425KCASEZGQLB8LPQMF4ZXCUBCTA01", "Type": "New", "Area": "Eng",…
I have the following function: func executeGet( completion: @escaping (Data?, Error?) -> Void) { AF.request("https:URL", method:.get, headers:headers).response{ response in debugPrint(response) if let error = response.error { completion(nil, error) } else if let jsonArray = response.value as? Data{ completion(jsonArray, nil) }…
I have a list of strings, printing out: ["TEST1","TEST2","TEST3"] How would I go about transforming this data to this JSON formatting? [ { "value": "TEST1" }, { "value": "TEST2" }, { "value": "TEST3" } ] I do not plan on…
I'm trying to replace newline characters in a JSON string, because Postgres' COPY function won't work otherwise. I've been trying different combinations of sed, such as: gsed -z 's/\n/\\n/g' gsed -E ':a;N;$!ba;s/r{0,1}n/\n/g' gsed '/}$/{N; s/}n{/},n{/} But it either replaces all…
I need to merge array data from two different arrays from the Input JSON and make a flat list of items in the Output JSON. The first array contains the key required for the output and the second array contains…