json Questions

How can I extract GUID's from Dictionary stored in JSON field in SQL?

January 16, 2023
yeti
2 Answers

I have the following table: Test_ID Test_JSON some uniqueidentifer see below some uniqueidentifier see below The Test_JSON structure is as follows: { "LaneIds": { "1": "a5a8ff96-0291-4ef9-890a-57c1874398bc", "2": "7a698a8b-934b-4a57-99c7-29a200d87877", "3": "aa30906d-e859-40a8-aedd-ae8ae10d0ae1", "4": "ccb05b71-a65a-4db7-b7c9-b4b7251150c7", "5": "c10593a9-06c3-49e4-bf4e-9d1c5ece98d4", "6": "6eeb9c85-f3ac-44cb-be74-f2d7554ea8d3", "7": "1226abb3-58c3-4b1e-844f-f2643d874490", "8": "7256ce43-014a-4dd6-a072-f8de2c373688"…

VIEW QUESTION

Jolt Transformation: Make the nested object field to be part of main Json Object and also convert the nested object to String

January 16, 2023
pramod wadappi
2 Answers

I am new to JOLT transformation, can someone help me in transforming the Input JSON to the desired output? Input JSON: [ { "product_id": 1, "product_description": "Product 1 details", "billing_details": { "product_id": 1, "billing_description": "Product 1 billing Details" }, "product_part_desc":…

VIEW QUESTION

Json – Unexpected Error : Unexpected character encountered while parsing value: }. Path 'resultData.data', line 1, position 184

January 16, 2023
Ahmet Yılmaz
2 Answers

I don't understand what is problem clearly. When I searched it in google, I don't decide my reponse model is problem or the json response is problem and should change. Which one? I can't find solution for Kotlin. How I…

VIEW QUESTION

Append in nested array JSON object in oracle

January 16, 2023
Bhawana Solanki
2 Answers

I have JSON document column in one of the table and its structure is like:- { "root":[{"MCR":"MCR_1", "MCR_COLUMNS":{ "MCR_COLUMN_1":"ABC1", "MCR_COLUMN_2":"ABC2" } }, {"MCR":"MCR_2", "MCR_COLUMNS":{ "MCR_COLUMN_1":"XYZ1", "MCR_COLUMN_2":"XYZ2" } } ] } Now I want to write a merge statement to merge…

VIEW QUESTION

Convert JSON nested array to flat array

January 15, 2023
Anonymous User
2 Answers

I have a JSON array which includes a nested array: { "data": [ { "id": 659, "created_at": "2023-01-13T06:35:08.000000Z", "products": [ { "name": "532", "properties": [ { "name": "color", "value": "blue" }, { "name": "size", "value": "1" } ], } ]…

VIEW QUESTION

How do I update data inside a stringified JSON object in SQL? – Postgresql

January 15, 2023
alonkh2
4 Answers

So I have three databases - an Oracle one, SQL Server one, and a Postgres one. I have a table that has two columns: name, and value, both are texts. The value is a stringified JSON object. I need to…

VIEW QUESTION

I need to compare 2 JSON files in PYTHON with transferring the result to a separate file

January 15, 2023
eugenelosikhin
2 Answers

I have 2 JSON-files and I need to compare them. json_new.json {"company_id": 111111, "resource": "record", "resource_id": 406155061, "status": "create", "data": {"id": 11111111, "company_id": 111111, "services": [{"id": 22222225, "title": "u0421u0442u0440u0438u0436u043au0430", "cost": 1500, "cost_per_unit": 1500, "first_cost": 1500, "amount": 1}], "goods_transactions": [], "staff":…

VIEW QUESTION

how do i format curlly bracket data in php

January 15, 2023
user3647738
2 Answers

i have this type of data store in mysql, how can i echo only the amount value from this? {"1":{"amount":"700","date":"2022-10-31","amount_discount":"0","amount_fine":"0","description":"","collected_by":"John Doe","payment_mode":"Cash","received_by":"12","inv_no":1},"2":{"amount":"300","date":"2022-12-17","description":" Paid by: Jane Doe","amount_discount":0,"amount_fine":"0","payment_mode":"upi","received_by":"23","inv_no":2}} this code looks like json data, if yes then should i be using jquery to…

VIEW QUESTION

how to put anonymous json as class member and convert all to json in c#

January 14, 2023
Renju Ashokan
3 Answers

I'm having a well-defined class for sending as JSON body in an HTTP request. public class EventData { public string deviceJobId { get; set; } public int eventID { get; set; } public long time_ms { get; set; } ///…

VIEW QUESTION

Json – I'm trying to get data from local data with pinia and nuxt, and it can't seam to get the end point, what's wrong with my code?

January 14, 2023
wilson irungu
2 Answers

I'm trying to get data from local data with pinia and nuxt, and it can't seam to get the end point, what's wrong with my code? I'm new to Vue, Nuxt and Pinia, I have been following some tutorial, but…

VIEW QUESTION