Stack Overflow
Stack Overflow

Questions tagged [json-arrayagg]

55 questions
0
votes
0 answers

JSON_ARRAYAGG returning backslashes when implemented in Nodejs

I am trying to return multiple array data in JSON but somehow backslashes are coming inside array while implementing in code. But while running the query in SQL then the data is coming fine as expected. Node implementation allPackagesByTrip:…
Amit Sharma
  • 13
  • 2
0
votes
1 answer

find the JSONObject in JSONArray based on key-value of JSONObject

I have a JSONArray with JSONObjects , i want the find a JSONObject based on condition and update it . Consider my json as below ManagerArr = [ { name : "Ram", employees: ["Shyam","bhavya"] }, { name: "Ramya", employees: ["Keerthi",…
Sahithi Y
  • 218
  • 2
  • 6
0
votes
4 answers

Oracle JSON_ARRAYAGG doesn't support DISTINCT keyword

SELECT key1, key2, JSON_ARRAYAGG(foo) foo, JSON_ARRAYAGG(bar) bar FROM ( select 1 as key1, 2 as key2, '1.0' as foo, 'A' as bar from dual UNION select 1, 2, '2.0' , 'A' as bar from dual UNION select 3, 4, '2.0' , 'A' as bar from dual UNION select…
JShao
  • 21
  • 2
0
votes
2 answers

Replace Backslash when converting to JSON Array in Azure Logic App

I am trying to fetch a JSON Array, however the Logic App Response it itself is appending a backslash to the response. Output expected :- { "ABC": [ "000D", "100D", "1200D" ] } I am getting response like below I am trying to use Replace function but…
Paramita Das
  • 23
  • 5
0
votes
1 answer

PLSQL : for loop json_arrayagg to json

I have an emp table, i.e. insert into emp(id,name,salary) values (1,'name1',1000); insert into emp(id,name,salary) values (2,'name2',2000); insert into emp(id,name,salary) values (3,'name3',3000); insert into emp(id,name,salary) values…
JackNagger
  • 3
  • 2
0
votes
1 answer

How to use prefix syntax to retrieve a deeply nested setting [array] from an appsettings.json file

Is there a way to retrieve a specific WriteTo object from the following Serilog json snippet from my appsettings.json file using the prefix syntax? here is the file section "Serilog": { "Using": [ "Serilog.Enrichers.Thread",…
dinotom
  • 4,990
  • 16
  • 71
  • 139
0
votes
0 answers

How to parse an xml array node in a SQL to convert XML to JSON

I am working on developing a sql query that picks up the xml data stored in a clob column of table stg_tbl and then converts the data to json in exact same hierarchy as the xml. Below is a sample xml data that is stored in the clob column
samrilla
  • 1
  • 1
0
votes
0 answers

Is it possible to make a nested GROUP BY with SQL?

I'm getting pretty close to the result i want, but i still can't figure out how to group by in the subquery. Here is my actual query, thanks to JNevill. SELECT JSON_OBJECT('id', a.IDartwork, 'creaDate', a.artworkCreationDate, 'length',…
nikubik
  • 21
  • 7
0
votes
1 answer

Can't figure out a triple joint with group by

I want to get the Creators of Artworks, GROUP BY by their role. I find a way to have the list of the Creators with their role, for each Artwork. SELECT JSON_OBJECT('id', a.IDartwork, 'creaDate', a.artworkCreationDate, 'length', a.length,…
nikubik
  • 21
  • 7
0
votes
0 answers

Conversion of ArrayList<> to Json Object Array in Android

I want to pass my array list which I get it from the Model Class in android to Json Object Array from one Activity to another activity and also suggest me the possibilities to achieve this process in Java. implementation…
Pursoth V
  • 1
0
votes
2 answers

Use JSON array in SQL query in the repository

In my PostgreSQL table I have a parts column of type json. I want to check if the given argument is contained in my json column. This query works in the database: select * from elements we where parts::text like '%"CHEST"%' However, it doesn't work…
pawello12
  • 17
  • 5
0
votes
1 answer

How to parse array values from Json in Jmeter

For the below response I need to fetch the rideId and pass it to the next request in Jmeter.Also ,the API that generates below response should be executed until the eventType is HANDSHAKE. …
Snehal Matharu
  • 13
  • 2
0
votes
0 answers

When converting custom list to string e.g.List.toString in JsonArray then facing performance time issue, do we other way to improve performance time

When converting custom object list to string using toString method it increases performance time list list; JSONArray array = new JSONArray(list.toString());
danceAyush
  • 1
  • 1
0
votes
1 answer

I want to extract the value from JSON by same id one id using java

So the json look like this { "cover":"AddressBook", "Addresses":[ { "id":"1", "NickName":"Rahul", "ContactName":"Dravid", "Company":"Cricket", "City":"Indore", "Country":"India", …
roger xiang
  • 3
  • 2
0
votes
0 answers

Unable to sort JSON string within MySQL

I have a JSON returned from a SQL which is created using json_arrayagg and JSON_OBJECT. Have applied sort order based on timestamp of column t_last_updated_at. The output of sql is stored in json_output variable in mysql procedure. SQL: select…
Ramaraju.d
  • 1,301
  • 6
  • 26
  • 46
1
2
3 4