Remove duplicates in an object in JSONiq
This is an example object that I got: { "query1" : [ { "name" : "John", "id" : 1234 }, { "name" : "Rose", "id" : 3214 }, { "name" : "John", "id" : 1234 } ] } How can…
Can jq add objects in two JSON object lists sequentially?
I am seeking the simultaneous iteration of two lists. Input object list: First Input Object List { "k11": "v111", "k12": "v112" } { "k11": "v121", "k12": "v122" } { "k11": "v131", "k12": "v132" } Second Input Object List { "k21":…
Json – Conditional With Arrays on a JOLT Transformation
I am having trouble handling an if conditional mixed with an array in a shift operation with jolt. If the field "HMEmails" is an array with values, no transformation should be made. But if it is an empty array or…
Combining JSON and Regex in R
I am learning how to use the Reddit API - I am trying to learn how to extract all comments from a specific post. For example - consider this post:https://www.reddit.com/r/Homebrewing/comments/11dd5r3/worst_mistake_youve_made_as_a_homebrewer/ Using this R code, I think I was able to…
How to convert json file to csv file in python
I have this json file which contains a list of objects [ { "infos": [ { "localisation": "Kassel" }, { "date": "01.08.2023" }, { "places": "1 freier Platz" } ], "applying email": "[email protected]", "additional infos": { "name": "jhon", "position": "RH",…
json column with nested values
I have a JSON type SQL column in SQL table as below example. I want the below code to be converted into separate columns such as drugs as table name and other attribute as column name, how can I use…
Json – how to convert string to dictionary with a datetime.datetime object in it
I have a string, which I retrieved as a nested JSON field from a Mongo database "[{'actionId': '29df54c0-9f08-4231-8eb2-ca2457003f2d', 'actionName': 'Create a team', 'userActionStatus': 'COMPLETED', 'currentCount': 1, 'targetCount': 1, 'lastActionDate': datetime.datetime(2022, 6, 24, 14, 17, 17, 785000)}]" I'm unable to parse…
AWS(boto3) Rekognition: how to process all images in bucket and return in each JSON file? – Amazon Web Sevices
Below is a example of AWS Rekognition script to run object detection. Was wondering if I can get some help on modifyin it. import json import boto3 def lambda_handler(event, context): client = boto3.client("rekognition") #passing s3 bucket object file reference response…
Json schema, generic "one or more"
Imagine a user writing some config files with some of the properties accepting either a plain value or an array of values of the same type. The use case is convenience and readability from a user perspective where you don't…
Json – Select values that match an element in bash array in JQ
I need to run a script where I have an array of ids, and a json that contains elements with these ids and more data. I need to filter/select the values that matches the ones in the array. For some…