Questions tagged [nested-json]
114 questions
1
vote
1 answer
Deep Nested JSON Normalization in Python pandas
I want to convert deep nested JSON file into CSV. JSON file is
{ "abcd-performance:output": {
"performance": [
{
"sample": {
"objectId": "abcd-device:100:12",
"ifName": "Carrier1/1",
"timeStamp": "2021-10-20T03:15:00.000Z",
"type":…
Ritesh Jain
- 13
- 3
1
vote
0 answers
GraphQLHttpClient nested json string c#
I am recieving this response from a GraphQL endpoint:
"container": {
"id": "X",
"containerId": "XYZ",
"metaData":"{\"postnummer\": \"9000 Aalborg\", \"ejendomsnr\":…
Kennedine
- 23
- 5
1
vote
0 answers
How can I generate nested json output using FOR JSON PATH from table with key-value in SQL Server?
The table containing the key-value also has a ParentID column. This column contains the id of its parent. I want to get a nested json using these.
Key-value table:
create table #temp
(
[Id] int,
[Key] nvarchar(100),
[Value]…
emekscoding
- 21
- 2
1
vote
1 answer
How to access json array elements (keys) , values in json nested dictionary type using postgresql?
I have a nested structure json .
How to extract the specific elements(keys) and values?
How to access " sky: selling":"1"
Or "U1":"0000" ?
I tried json_object_keys and json_array_elements for extracting the array .
But I don't know exactly how to…
Abarna
- 11
- 1
1
vote
1 answer
How to convert a CSV into a nested JSON using Python
So i have read alot of previous questions about this topic but non were really able to help me get to the result I want so here's the CSV file…
Omar Solieman
- 36
- 7
0
votes
0 answers
Nested Document in solr cloud
This is my schema file :
This is my schema file :
`
Jerry
- 1
0
votes
0 answers
Json Normalize to Pandas Dataframe multiple list of dicts
I am having a nested json file like below:
test.json
{
"resourceType": "test",
"url": "/test/abc-oq-001",
"version": "1.0",
"title": "xyz test",
"status": "active",
"date": "1990-01-01T10:10:10+08:00",
"description": "one",
"code":…
blackfury
- 675
- 3
- 11
- 22
0
votes
1 answer
How to Access and Extract unique id's from all the rows each row having its own unique id as a key?
I have a JSON nested Data in column name response of a table name data_1 as i am using JSON_EXTRACT function in my google bigquery but don't know key. talking about each row have its own key (https://i.stack.imgur.com/f1IcE.png) how to access and…
akshat chourasia
- 9
- 2
0
votes
0 answers
How to access segments of nested json using url?
Ex json http://example/api :
{
"shop":{
"id":"shop",
"employee":{
"id":"employee",
"name":"som",
"age":10
}
"departments":{
"id":"departments",
…
Finalgof
- 11
- 2
0
votes
0 answers
Read json data kotlin
I have a json file. I want to use this json file with firebase collection and document logic. This is how I created my file. But when I try to read it in my application, I cannot read it like that. I am reading all the files directly. How can I…
frknklksz
- 1
- 1
0
votes
1 answer
How can I use a customized function in JsonPath to set values for nested JSON objects in Java?
how to use Jsonpath to set values with a customized function for nested JSON objects
the JSON objects is nested by unordered json array and json object
such as
{
"store": {
"name": "ABC Co",
"book": [
{
…
0
votes
1 answer
How to recursively build a JSON tree structure in JavaScript?
I wrote an recursive function to generate an hierarchy JSON but the function is returning unexpected output i tried solving it but i am getting no where.
The input format is a list of objects with Name,Email,Reports to Id(parent node) and Id and i…
Banoth Srikanth
- 1
- 2
0
votes
0 answers
type "null" is not a subtype of type 'List' in type cast- nested json
i want to retrive or parsing nested JSON data from rapidapi :
the recipe class should include basic data name,image
and contain object of rating{score}
and list of instruction{ position, text}
the structure of data in the image below
JSON data in…
Alaa Abdullah
- 1
- 2
0
votes
0 answers
Mapping nested data from additional information in email notification
Suppose i had sent nested json data in additional information in em_alert, how do i access the nested data in the Email notification?
For example the additional info has below nested value, how do i access data1 and data2 fields in the Email…
user1929905
- 389
- 3
- 9
- 25
0
votes
0 answers
Deconstructing Nested JSON keys in Javascript for HTML table
I am having troubles to get specific keys from nested JSON in javascript.
I want to create HTML table where
columns would be:
id, Card Trader, MKM Low, MKM Trend..... those level keys
and rows would…
