All Questions
25,530
questions
0
votes
1
answer
27
views
Distinct for jsonb_path_query_array
Have some trouble with jsonb_path_query_array in pgsql.
Is there a way to distinct values inside arrays?
I have something like this
select jsonb_path_query_array(public.table.column, '$.Idents.type' ) ...
0
votes
1
answer
40
views
Find index in map object using JavaScript
If we want to find index in array of objects, it's pretty simple. Example below
let a = [
{prop1:"abc",prop2:"qwe"},
{prop1:"bnmb",prop2:"yutu"},
{prop1:&...
-2
votes
1
answer
57
views
How parse json value into array with jq
I have this
{ "1": { "Split": { "result": "first_image" } }, "2": { "Split": { "result": "second_image" } } }
I tried .[]...
0
votes
1
answer
52
views
Response object is not subscriptable [closed]
###
# Added for reproducibility.
from flask import Flask, jsonify
import requests
app = Flask('my_app')
###
@app.route('/twoHourForecast')
def get_twoHourForecast():
twoHourDataUrl = "https:/...
0
votes
0
answers
28
views
json_encoded array ajax response interpreted as text [closed]
My ajax response seems to be interpreted as text even though the ajax request contains datatype: "json". My understanding is that header line in the php script below should have no effect, ...
0
votes
1
answer
39
views
Remove array from JSON when it appears
I receive a JSON and sometimes, not always, I can receive an array in "resources" instead of a single value. I need to always transform this to a single value, keeping only the first one.
{
...
2
votes
2
answers
52
views
SQL to JSON Need Bracket for Array that can have multiple rows
I'm trying to take a SQL query and turn it into JSON for an API call. I have two groupings that need to contain an opening and closing bracket [] because they can contain multiple rows. Those are ...
0
votes
1
answer
51
views
filter map objects using javascript
I have a map object with key value pair as shown below
const input = new Map([
[
0,
{
testErrorSummary: "ServiceC\nV4/\n\tcom.dmv.smp",
appErrorSummary: '{&...
0
votes
0
answers
19
views
My json input contains object and arrays, how can I convert it into dataset
My json input contains object and arrays, how can I convert it into dataset?
I referred existing stack overflow solutions but didn't find anything that works.
Need help with the solution, available ...
1
vote
1
answer
44
views
Jolt concatenate array into a single JSON object
I am trying to flatten the following JSON :
{
"barcode": "7490b0d2-dfe5-4a21-bc21-02de587e2fe8",
"containers": [
{
"L_ID": "867bb595-d2a4-...
-1
votes
1
answer
54
views
Getting unnecessary special characters in Url while encoding and decoding json with rawurlencode
I am trying to send JSON array of image URLs to a second page but my redirection URL has a lot of special characters which might be slashes, spaces, etc.
I have tried both 'urlencode' and '...
0
votes
4
answers
122
views
Change array of object value based on another array
const array1 = [
{
id: "40",
alias: "Number",
name: "Number",
},
{
id: "41",
alias: "Salary",
name: "Salary",
...
0
votes
2
answers
37
views
Jolt spec to perform the grouping and remove the duplicate from nested json
Please help me in providing jolt spec or update the below tried jolt spec to get desired output json shown below
I already posted the similar question but tried to solution but not able to remove the ...
-5
votes
0
answers
34
views
Fetch and build a 2 dimensional array from json response [duplicate]
I am trying to figure out how to build a 2 dimensional array from a JSON response using specifically the fetch and lambada techniques.
I am trying to capture two fields out of the json response name....
1
vote
1
answer
59
views
Remove duplicate from nested json array using jolt spec
please provide the jolt spec to get the desired output json
below provided jolt spec is needs to updated to remove the dupicate inside the subitems array
the input JSON :
[
{
"itemid": ...