Questions tagged [nested-json]
114 questions
0
votes
1 answer
How to access data inside Json nested objects from an API
I am using cryptocomare API to get crypto coins data within a Nextjs App. What i doing is that when a user clicks on a perticular symbol, i redirect it to the coin details page where i try to extract the clicked symbol with getServerSideProps as…
Sverely Simple
- 3
- 1
0
votes
0 answers
Visualize a SQL file on Tableau where one of the table has data in JSON format
I have extracted and analysed the dataset with mysql and now i want to visualize it with Tableau. Other tables work fine when i do data modelling except the one that has data in JSON format.
I tried spliting on Tableau but it didn't work.
0
votes
0 answers
Nested dynamic json, Hive complex datatype, data insertion
I've a nested dynamic json. I want to load data from the json to some 5 hive tables. The tables do have some complex datatypes. A single json is used to populate all the tables. I flattened out the entire json dynamically. But that won't suffice. I…
Diksha Kapoor
- 11
- 1
0
votes
1 answer
Complicated Nested JSON Normalization in Python
After several days of trying, I'm posting for help. I know this question has been asked many times. I tried several solutions but I couldn't solve my problem.
I have a large nested JSON file (1GB) and I would like to make it flat and then convert it…
CCS22
- 11
- 1
0
votes
0 answers
How to store values into a dataframe from a List using Scala for handling nested JSON data
I have the below code, where I am pulling data from an API and storing it into a JSON file. Further I will be loading into an oracle table. Also, the data value of the ID column is the column name under VelocityEntries. I am able to print the data…
0
votes
0 answers
How to create a nested collection in Azure purview through api using postman?
I am trying to create a nested collection in a purview through api using postman.
I was able to create a one subcollection under my existing collection in a purview.
Is there a way to create a bunch of subcollections under the existing collection…
mustard
- 1
- 1
0
votes
1 answer
How to print optional arrays in JQ
I have the following example:
{
"field1": "test1",
"array1": [
{
"field2": "test20",
"array2": [
{
"field3": "test30",
"array3": [
…
bunkfish
- 45
- 6
0
votes
0 answers
Error when Update data using ORDS API with JSON nested payload Oracle APEX 21.2.0
I have this json coming from a client of my API:
{
"device" : "37AB2C",
"time" : "1552749097",
"data" : "0d01da0c1600",
"signal" : "Average",
"payload" :[
{
"lat":49.21706417063655,
"lng":16.627916371512473,
"radius":9228,
…
Graçane Muhate
- 1
- 3
0
votes
0 answers
How to get value from nested JSON object in a generic way in Java
I want to fetch value of Column, Tag & Status attribute from below json string in a generic way.
[
{
"HoldTag": {
"Employee": {
"Column": "0",
"Tags": [
{
"Tag": "2345"
}
],
…
0
votes
2 answers
Error Parsing Swift in nested JSON (JSON Serilization)
if(UserDefaults.standard.string(forKey: "UID") != nil){
guard let dataFile = Bundle.main.path(forResource: "database7", ofType: "json"),
let database = FileManager.default.contents(atPath: dataFile) else {
…
VXCX
- 3
- 3
0
votes
2 answers
Nested JSON parsing pyspark
I have a nested json body like below:
{ "MainTag": { "GroupId": "10C81", "IDArray": [ "ABC-XYZ-123" ], "IDStruct": { "DSA-ASA-211": null, "BSA-ASA-211": null, "ABC-XYZ-123": [ { "BagId": "42425fsdfs", "TravelerId": "1234567", "LegCorr": [ { "DelID":…
Vaibhav
- 11
- 5
0
votes
2 answers
Convert Nested JSON into CSV File
I want to create a CSV file with the columns 'Duration' and 'Attention' from a nested JSON file that looks like this:
[
{
"Id": {
"Address": "",
"Address": "",
"Name": "Avg"
},
"position": 0,
"sender": [
…
humzaqureshi
- 39
- 2
- 4
0
votes
1 answer
SQL Server nest JSON output
This is my SQL Server table:
I have a table like this:
CREATE TABLE countries
(
continent nvarchar(10),
country nvarchar(10),
city nvarchar(10),
);
And I have this data like this:
INSERT INTO countries
VALUES ('asia', 'inda', 'new…
0
votes
2 answers
Flutter: Model for List of nested json response
I am building a flutter app that gets a List of nested JSON as the response. I build the code as follows
This is the response I get
[
{
"machine_id": "SVB12-00001",
"display_name": "Cuttack Rly Stn",
"last_datetime":…
Ajay Ramprasad
- 29
- 8
0
votes
1 answer
Type 'AA' is not assignable to type 'NgIterable | null | undefined' in Angular
I have the following interfaces with Response having array and object. I want to display the data using ASYNC Pipe from the url provided. Result is Array and Info is Object. Inorder to display the value of Info , I get error saying
** error…
user17449555
- 15
- 2
- 8