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…
Say I have a use case for my config file like this: function generateText(thisIsAVariable) { return `This is a sentence with a variable somewhere in the string ${thisIsAVariable} then more string... or not`; } I want to be able to…
Need to create a function which takes input of CLOB and I need to remove array matching the condition. CREATE OR REPLACE FUNCTION remove_config_node_by_key ( p_in_json IN CLOB, p_in_key IN VARCHAR2 ) RETURN CLOB IS l_ja json_array_t; l_po json_object_t; l_key…