Questions tagged [nested-json]
114 questions
0
votes
1 answer
flatten complicated nested Json file with a lot of list of dictionary with same key ( "key", "value")
I have a complicated json file that take me a lot of time to make it in Excel format, I do my best but i think I miss something so can someone help please,
the json file is below and my script did half of work :
json file :
{"logFormatVersion":…
OUDRHIRI Mohcine
- 3
- 2
0
votes
0 answers
How to find the difference between two json and create body for api accordingly using python?
I can not use any jsondiff library. I require to do this without library.
default_config = {
"pipeline_id": "2",
"version": 1.0,
"tasks": [
{
"task_group_id": "Task_group_1",
"branch": [
…
Professor
- 87
- 6
0
votes
1 answer
how to get data from nested json input from flutter?
Below is the response how to get this data in flutter.I wants to get image file path of all fields like aadhaar,pan card and business ownership proof. I needs to know how to get the response when it is structured like this?
{
"data": {
"pan":…
Minal Suryawanshi
- 81
- 8
0
votes
2 answers
How to extract multi-nested values from JSONs in T-SQL
I am using SSMS v18.12.1, and am trying to write a T-SQL query to extract specific values from multiple columns, and at times nested values.
In the example below, I would like to extract the DeliverySchedule @Type value, and the Details @Type and…
Burke Evans
- 1
- 1
0
votes
1 answer
Nested Json Using pyspark
We have to build nested json using below structure in pyspark and i have added data that need to feed using this
Input Data structure
Data
from pyspark.sql import SparkSession
spark =…
Amol
- 336
- 3
- 5
- 17
0
votes
0 answers
json tree iteration missing return condition
Im iterating through a nested json tree with Pandas dataframe. The issue im having is more or less simple to solve, but im out of ideas. When im traversing trough the nested json tree i get to a part where i cant get out of it and continue on…
Tom
- 37
- 8
0
votes
0 answers
Extract events data from GA4 via bigquery in ADF synapse delta table
We need to extract the events table from GA4 through bigquery (not connecting via Google API directly as it limits both - the number of rows & number of dimensions/metrics), however as there are several nested columns, the ADF reads data in the…
0
votes
1 answer
Nested JSON to Pandas Data frame
Input JSON
{
"tables": {
"Cloc": {
"MINT": {
"CANDY": {
"Mob": [{
"loc": "AA",
"loc2": ["AAA"]
},
…
Alind Billore
- 696
- 2
- 10
- 24
0
votes
1 answer
How to access nested elements of json object in node js and mongodb
const mongoose = require("mongoose");
const productSchema = mongoose.Schema({
product_name: {
type: String,
required: [true, "Must Enter Product Name"],
},
product_brand: {
type: String,
},
category: {
type: String,
…
0
votes
1 answer
How to access nested JSON data | REACT
I have a problem when trying to fetch one nested JSON object from local API endpoint /user/{id} that looks like this…
vijje
- 3
- 1
0
votes
0 answers
How to get selected json objects from a nested json in postgres sql
I have the data stored in a table named 'userfields' the below format in one of the columns named 'params' in Postgres SQL. I want to select two json objects and the output should be in the same format
{
"default": {
…
Gopinath Thatha
- 1
- 1
0
votes
0 answers
How to Access the data inside the JSON object. Some of my columns in pyspark dataframe is in JSON format
I was trying to access the data inside object. The table is in pyspark dataframe, but some table values are in JSON format. I need t access the date from it and convert into meaningful format. Any help or idea will be great relief.
This is thing i'm…
antonyj453
- 17
- 7
0
votes
0 answers
Select All check Box not working ideally when we switch tabs where all the data is being rendered from nested json array in react
The below is the reponse data from api which I get
[
{
zip_file: [
{zip: "a.zip"},
{zip: "b.zip"},
{zip: "c.zip"}
],
text_files: [
{text: "a.txt"},
{text: "b.txt"},
{text: "c.txt"}
],
…
ganesh Shivkumar
- 1
- 1
0
votes
1 answer
Accessing column of a list of nested json in a python dataframe
Identifier Properties
1 [{"$id":"2","SMName":"pia.redoabs.com","Type":"sms"},{"$id":"3","Name":"_18_Lucene41_0.doc","Type":"file"}]
2 …
Lopa
- 51
- 6
0
votes
1 answer
Is it possible to rename a json key name using its value in Python?
I have this nested json dictionary and I want to rename the key name 'Keys' with its equivalent value using Python. I wonder if this is possible?
Current - 'Keys': ['AWS Backup']
I want it to be - 'AWS Backup': ['AWS Backup']
Sample json…
jellobeann
- 7
- 6