we are trying to read a table from Bigquery to spark dataframe. Strucute of the table is Following pyspark code is used for reading the data. from google.oauth2 import service_account from google.cloud import bigquery import json import base64 as bs…
I want to merge JSON string in a table and sum its value after group for Eg:- 2023, {"hen":4, "owl":3} 2023, {"crow":4, "owl":2} 2022, {"owl":6, "crow":2} 2022, {"hen":5} 2021, {"hen":2, "crow":1} Result could be like below 2023, {"hen":4, "owl":5, "crow":4}…
Helloo ! i would use a json files in my angular-app. I have a local json file 'client.json' { "T001": { "name": "admin", "type": "adm", "id": "1", "class": "viewer", }, "T002": { "name": "Customer", "type": "usr", "id": "2", "class": "viewer",…
I have the following problem, I'm new in Dart, and I'm using a Future to construct a list view from a JSON response of an API, once I do this request, I receive the following response: REQUEST: Future<List<Job>> _fetchJobs() async…
I have the following data object. public class Response<T> where T : MyBaseDTO { public bool result { get; set; } public List<Message> messages { get; set; } public List<T> data { get; set; } } public class Message {…
I'm doing a little exercise to get values from a JSON file and set those values into InputFields of a Unity project. When I read the file all I can get is that the Index is out of range, when…
I'm struggling cause I don't know how to consume this JSON because in the "weather" part of the JSON it receives [0] as key-value and I don't know how to declare it { "coord": { "lon": -35.7353, "lat": -9.6658 },…
I have an issue with deserializing the JSON file from the web to a List. My code is down below, but it does not execute and shows System.NullReferenceException. It happens in the Content() method, when I call callApiAsync() in the…
I am making a bot which checks if a message contains a key with a value of "weak", if it does, it should send the keys that are in the message. However, my code faces two issues. when i do…
Say your XML file is: <CATALOG> <CD> <TITLE>Empire Burlesque</TITLE> <ARTIST>Bob Dylan</ARTIST> </CD> <CD> <TITLE>Empire Burlesque</TITLE> <ARTIST>Bob Dylan</ARTIST> </CD> If you transform it into JSON, should it be (version 1): { "CATALOG": { "CD": [ { "ARTIST": "Bob Dylan", "TITLE": "Empire…