Questions tagged [nested-json]
114 questions
0
votes
0 answers
Store nested JSON object as a string C#
I ran into an issue when parsing JSON . I am parsing JSON similar to this :
{
"regularProperty" : "Test here",
"nestedJSON" : {
"propertyText1" : "new Text",
"propertyText2" : "new Text",
"propertyText3" : "new Text"
}
}
Where it…
JmukhadzeT
- 99
- 1
- 9
0
votes
1 answer
Using Azure Synapse pyspark filter flatten the nested json objects based on nested object's data type
I am working on Azure Synapse pyspark on flattening the nested json data.
json file has json objects with nested data as shown below, here cords is of type struct for 1 and 3rd record and string for 2nd record.
When I printed the schema using…
Palaksha K S
- 31
- 5
0
votes
1 answer
split data in nested json to make some calculations
hoping someone helps me out. I have a nested json file and I'm trying to calculate the age difference between two lines of the file, the start_date and end_date with date format of mm/yyyy only. So I'm trying to split it so I can calculate the year…
Grace
- 3
- 2
0
votes
2 answers
Converting nested JSON object to pandas Dataframe
I am dealing with a JSON file which has nested fields (arrays). I am trying to convert the same into a Pandas dataframe.
{
"_id": "2026",
"dataDate": 1537920000000,
"dataYear": 2018,
"groupId": "1378",
"HourConsumed": 19781.4,
…
shivanshu
- 67
- 5
0
votes
0 answers
Im trying to store my nested json file to db but it throws error in index
Im Planed to Store my Nested Json File into postgres db Using java Spring boot But the nested json array part throw a error, What can i do To solve this Error
Error Is
Caused by: java.lang.ArrayIndexOutOfBoundsException: Index 2 out of bounds…
Akoram
- 13
- 6
0
votes
1 answer
read nested JSON with the .find() Method
I'm stuck at reading out nested JSON elements that were saved in a MongoDB. I'm trying it with the following method:
blockChainModel.find({"transactions.user": "eltaieyo"}, null, {projection : { transactions: {user : 1}} }, (err, blocks) => {
…
younes.xd
- 11
- 1
- 8
0
votes
0 answers
How to multipart upload nested json parameter with Alamofire?
now I'm using Alamofire to connecting my iOS app to server with apis.
Our server guy made post request that upload images and some information of this.
And this data send to server with POST method and multipart.
private let files =…
999rimmy
- 35
- 3
0
votes
2 answers
Deserializing Json With Unknown Key - ASP.Net Core 3.1
I'd like to deserialize the following JSON with .Net 3.1
My difficulty is the "1234" key for this object is unknown when this object is serialized. How could I deserialize this? The values I want to keep are the nested "first_name" and "last_name"…
consol
- 1
0
votes
2 answers
Convert result into doubly nested JSON format
I am trying to convert SQL Server results into a doubly nested JSON format.
Source SQL Server table:
ID
Name
Program
Type
Section
Director
Project
Sr Manager
PCM
Contractor
Cost…
David Kade
- 33
- 5
-1
votes
3 answers
Conditional parsing of Nested Jsons with jq
Need help parsing the below nested Json. The end goal is to get the quota limits from GCP that have non-default values. Below is the sample data for one of the services (compute APIs for a given CPU type)
I am struggling to be able to compare
I came…
Python Beginner
- 71
- 5
-1
votes
2 answers
How to get metadata when reading nested json with pandas
I'm trying to get the metadata out from a json using pandas json_normalize, but it does not work as expected.
I have a json fine with the following structure
data=[
{'a':'aa',
'b':{'b1':'bb1','b2':'bb2'},
'c':[{
…
fil
- 49
- 5
-1
votes
1 answer
How to elegantly get a particular value from highly nested json object in JavaScript?
This is my json object by name data
{
"data": {
"id": "---------",
"type": "licenses",
"attributes": {
"name": "Floating Point Lic",
"key": "-----------",
"expiry": "2022-07-30T19:11:30.738Z",
"status":…
KESHAV MAHESHWARI
- 25
- 4
-1
votes
1 answer
javascript adding items to json object using a nested array
so i have one array with names, and one with other json-data i can access using a method.
I was trying to do
let out = [];
for (let i = 0; i < data.length; i++) {
for (let j = 0; j < names.length; j++) {
let feed = {names[j] :…
Jonas
- 52
- 1
- 8
-1
votes
1 answer
Writing a program to take user input and prints output from the Nested json file
I have a nested json file with the below data and I need some help in writing an interactive program where it should take a topping as input and prints out the names of all the donuts that have this topping.
[
{
"id": "0001",
…
user7463647
- 53
- 1
- 8
-1
votes
1 answer
Convert nested JSON to HTML Unordered List with Python
I did a fair amount of google searching but didn't find a suitable answer for someone who would like take arbitrarily nested JSON, for example from an API response, and display it as an unordered list using HTML using python.
Ultimately, the issue…
Kyle
- 321
- 1
- 14