I'm almost at the end of a thing I like to make for my website. I have a json file that I use as a sort of database for my thumbails for the recipes... The most info displays as I…
i have been trying for hours but with no luck, I want to extract the (id, remote_ip, listen_addr) and put it in a txt file I have managed to do so with curl -s https://pastebin.com/raw/gGt524CS | grep -e "id" -e…
I have a .csv log file containing three json lines for each client. For example: {"name":"John","phone":"08847","politic":"on","ville":"LA","isTest":"false","source":"t3_1"} {"data":{"name":"John","phone":"+8847","city":"LA","source":"t3_1","cameF":"a1"},"token":"bd67a","isTest":false} {"data":{"responseId":"R_2hs","city":"LA","cameF":"cpl_agency2","source":"t3_1"},"success":true,"ts":1721394844,"message":null} I don't understand how you can combine three separate lines into one and then read the json. Starting reading the file: import…
I am working on a Node.js backend project using Socket.IO and am facing two issues when trying to interact with the Socket.IO endpoints via Postman: 1. Connection and Event Emission Issue on Different URLs: I am able to connect and…
I am working with a large gzipped JSON file containing review data, formatted as a list of JSON objects. Each object is separated by a newline character. My goal is to efficiently extract the review_text field from each object using…
I have this data in a json column #mycolumn { "key": "KEY", "elements": [ { "name": "NAME_1" }, { "name": "NAME_2" } { "name": "NAME_3" } ] } I want to select all the elements[*].name. I have tried: select JSON_EXTRACT_PATH_TEXT(mycolumn,…
I'm trying to figure out how I can ignore a specific value of a property using Mixin. For example, there is a class: class MyClass { String name; } I want to use a MixIn to ignore names with a…
I have an object let files = { '00':{}, '01':{}, '02':{}, '03':{}, '04':{}, '05':{}, '06':{}, '07':{}, '08':{}, '09':{}, '10':{}, '11':{}, '12':{}, '13':{}, '14':{}, '15':{} } console.log(Object.keys(files)) the result I'm getting is this. ["10","11","12","13","14","15","00","01","02","03","04","05","06","07","08","09"] 1. why it's reading key from 10…
I have two arrays as shown below, as i concat both the arrays - the ST key value in Array1 is replaced by values in ST key values in Array2, Array 1: {"ST": ["Bin", "No", "Comp"], "OSS": ["Class"]} Array 2:…
I have query like select billing_number, created, amount_total_sum, days, country, status, check_in_date, concat(elements->> 'isPossible', elements-> 'UTCDateFrom' ->> 'date', ' - ', elements-> 'UTCDateTo' ->> 'date' ) from (select o.billing_number, o.created, o.amount_total_sum, t.check_in_date, t.check_out_date - t.check_in_date as days, t.hotel_country as country,…