Category "json"

Difference in jsonb and jsonb[] in postgresql

I have been working over jsonb columns in postgresql. My problem statement is to store array of json objects, so i thought of jsonb[] datatype as it is a viable

Exporting Dependabot as JSON

Anyone know how one can export Dependabot findings in GitHub as JSON? I've seen this done before, however can't seem to find anything online about it.

Variation: Find the object with the highest value in Javascript [duplicate]

In Finding the max value of an attribute in an array of objects there are many (great) answers that report the highest value in an array, but

del builtin not functioning on list

So I'm trying to create a program that deletes the cells in jupyter notebook that are code cells and delete go into the cells that have the word solution and re

Passing in empty string breaks Input Transformer if I want to enforce double quotes on all values

This is my very simple scenario. I'm passing in a JSON to an Input Transformer within EventBridge, and I'd like for the output template to be a transformed JSO

How to save JSON to CSV?

I am trying to use a raw data output from mixpanel API and save all events to a .csv. Mixpanel gives me the following data as <class 'str'>: {"event":"Te

DevOps Pipeline changing Timeformat when sending variable values as JSON Body to Deploy Azure Resources with Terraform

My Terraform Deployment for Azure Resources contains a Budget, which requires a start and end date. When I'm sending my JSON Body/variable value from my Logic A

convert a CSV file to JSON file

I am trying to convert CSV file to JSON file based on a column value. The csv file looks somewhat like this. ID Name Age CSE001 John

How to handle the variable size json file in python to create DataFrame using pandas

I am trying to build a DataFrame using pandas but I am not able to handle the case when I have the variable size of JSON chunks I am getting. eg: 1st chunk: {'a

Problems when receiving websocket data(it's json but result is list of number)

I am a beginner developer developing with Dart. There was a problem while working with websockets. According to the API help, it's obviously JSON. but data is l

Skip or Ignore non-existing key with to_entries in jq

I'm trying to create a massive CSV file converted from each *.json file. This snippet works until it faces the file that doesn't have the key (hobby). Original

extended the bars to the bottom in SharePoint Online JSON format

I want to extend the bar, in blue or red up to the bottom of the row via JSON. How can I achieve that? Here is my code: { "$schema": "https://developer.microsof

Microsoft Azure iot-hub: The measured senosor values sent via device to iot-hub cannot be read stored Json data

We are using a data acquisition system as a device and send some signals values via MQTT protocol into a container which is assigned to an iot-hub. The connecti

How to pick specfic data from json response javascript

How to pick specific data from JSON response javascript Background-Info I'm trying to create an application to view data from haveibeenpawned's API. I don't wan

How can I add a timeslider to a leaflet map?

I have a leaflet map, exported from qgis with the qgis2web plugin. I would like to add a timeslider for this map, as every layer (representing points) has a "fr

How to access nested JSON with Jinja?

I'm learning Jinja for building a simple website. How do I access values of nested JSON in the Jinja syntax? Example: How do I only access the "Education" key i

Unnest/Unlist column with variable lengths in R

I'm trying to wrangle a json file into a data frame but I'm having trouble when unnesting to a wider format because the columns contain lists of unequal sizes.

swift error: Value of type _ has no member _

how do I fix this error? xcodes-13 This Is my code for working with api: struct everything: Codable{ let topic: String let content: String

Fetch data from database where logged in user id exist in an column that stores ids as an array Laravel 8

I want to get the rows in a database where logged in user exists. Here is my structure Table = Meetings Column = Participants (stores an array of users eg.["1",

Downloading JSON file in expressjs and reading it

I have a task where I am given a URL such as https://xyz.json. This URL prompts the downloading of the JSON file into the local. I am now required to read the u