I am creating a jsonb object using jsonb_build_object in PostgreSQL. The problem is that it adds jsonb_build_object column in the output. Please refer to the screenshot and query below: select jsonb_build_object( 'country_name', country_name, 'country_code', country_code, 'currency_code', currency_code ) from table…
"name" : "a", "type": "container", "kids": [{ "name": "a1", "type": "container", "kids": [{ "name": "a2", "type": "leaf", "when": "../a" }] }] } in when condition i want to validate in node ->parent ->parent is "a" Now how to validate that…
I have data coming into NiFi in JSON format. Below is the sample { "company_name": "mycompany", "companytyp": "producer", "Welcomemes": "welcome_message1", "logo": "//somepath/to/logo URL " } I have been trying to apply a JOLT transformation for the following condition: If the…
Is it possible to implement follow: I have a controller, that contains several methods and using as API. For GET requests I can just send params in url query and use it in a method body, but for POST method…
Consider the following file.json where "x" is a known string. Two questions: I want to obtain a list of all the unique values in the child arrays. What I have is jq -r '.x[][] file.json | sort | uniq. Is…
So inside my table, I have a column named "data" that is varchar(3000). This is basically a json blob, and this is example of what it holds: {"homeWidgetToShow":"chat_and_notes","official":false,"nationalFederation":false,"categories":[],"activities":{"0":2,"2":7,"1":3},"clubsBlackList":[],"privateMembers":false,"alwaysShowDescription":false,"restrictMembersFromPositingForums":false} Now I need to make a query that basically finds if inside…
I have a JSON dataset and it is in array format. I have to make a table in Postgres-SQL and then store the data into it. I haven't ever worked with this complex data. I am trying to figure out…
i wanted to create a id for my list of objects which i am storing it in a .json file(just wanted it as a dummy database which stored info), i wanted to give the id as 1,2,3,4... for each object…
I am making an api call and receiving the response. I would like to parse the response, as it is an array of objects. For example the json looks like this { "totalSize": "56", "sortedKeys": [ { "size": "12", "key":…
I am facing a problem, transforming a very complex nested JSON using jolt transformation. Input and output detail is given below. Input [ { "metadata": { "event_time": "2023-09-04T08:46:15.0842Z" }, "payload": [ { "plant": "0DE1", "store": "", "t_objectandcharvalcomb": [ { "productalloccharacteristic01":…