Category "json"

SQL Parse Json array to rows

I'm trying to parse the 'custinfo' array to rows, rather than specific columns how I have in my query (there can be none or many values in the array) DECLA

Extract a value in a json response with a variable

I am trying to return the id of a declared variable from a json file: i want my java code to search for the previous variable in the json response and once it i

How can I get all the object inside an object which is present inside an array and add the result into another array

I am struggling with an issue that is bugging me a lot. I am not good with JSON data manipulation. So the issue is I have an Array of multiple Object which cont

JSON Object to Hmtl

I've been developing a WebApp using javascript. I was trying to retrieve some data, and fortunately did it sucessefully but when i try to insert it in the HTML

convert complex nested json array using jolt expression in nifi

I have a complex Json where i wanted to flatten the Json using Jolt or any other ways to flatten in Nifi is also fine can anyone please help to flatten the belo

JSON NESTED STRUCTURE - PENTAHO

I have this following json nested structure that i need to construct in pentaho: { "num_matricula": "4242424", "limit_date": "2018-01-01", "admission_date

How to get openweathermap icon from OneCall API nested-list?

I'm adding weather forecast data to my app. The info displays in a RecyclerView after it is received by an API call using Retrofit 2. I'm having trouble getting

How to handle extra data error in FastAPI

So I have the following FastAPI code: from fastapi import FastAPI app = FastAPI class Demo(BaseModel): content: str = None @app.post("/demo") async d

HTTP Post request method does not execute. How to use HttpClient?

I'm trying to make a post request using HttpClient. The expected json which I'm trying to post is stored in var result and looks like : { "ID": 142, "Statio

save map bookmark for each user login using .net and javascript

I want to create Bookmark widget, and I want each user can save his own bookmarks. and when login to the application can see only his bookmarks. for this I have

Serialize/Deserialize json array to struct

I have incoming data in a json array that I deserialize into a struct, but I can't seem figure out how to serialize it back into an array instead of an object.

Empty output using trino dbapi in python

I am getting empty output in the below code but when I remove the part of and I get the desired output. Can anyone clarify if there is any error in syntax of be

Why can I not refresh my Snowflake External Table?

I am getting the message "query produced no results" when I try to execute a refresh of my external table in Snowflake. Below are the steps I have taken leadin

How to exclude escape characters from ROOT when using FOR JSON from SQL server

I am trying to create JSON output from SQL Server using FOR JSON. My JSON record is good however I have a number of elements I need in the ROOT section but this

How to fetch multiple .json files with javascript?

I have multiple .json files and I want to fetch them so I can take information from them. Like user ID, name, salary... I know how to do one, but I need two of

Create JSON with jq

I am trying to create a JSON file with jq from the result of the command "lsb_release" What i have done : if [ -x "$(command -v lsb_release)" ]; then lsb_re

How To Display JSON Data in flutter Chart

I have tried to put JSON data in flutter chart, I used syncfusion_flutter_charts library but its not working and its only showing y axis point but not x axis po

Read action parameters from JSON properties

How can I get the parameters of an ASP.NET Core MVC controller action from the properties of a JSON object that was sent in the HTTP request body? If the reques

Is it possible to get the sum of a dictionary JSON with values of different data types in python

I am trying to get the sum of the values from a dictionary within a JSON file, but some of the values are a different data type. Only the values that are number

Remove null from a json data (python)

When I use the Rest API to download data from Firebase, it looks like this. { "Dataset1": [ null, { "Key1": 1, "Key2": 2 }, {