I am trying to get the joke from https://icanhazdadjoke.com/. This is the code I used const getDadJoke = async () => { const res = await axios.get('https://icanhazdadjoke.com/', {headers: {Accept: 'application/json'}}) console.log(res.data.joke) } getDadJoke() I expected to get the joke but…
I have the following JSON : { "Content": [ { "CandidateFirstName": "Nagu", "Applications": { "ApplicationId": "456", "Sarasa": "test" } }, { "CandidateFirstName": "Deleted", "Applications": { "ApplicationId": "123", "Sarasa": "test2" } } ] } and I'd like to have the following…
I'm trying to write js code to find if any item already exits in the array, it makes it a bit tricky. There are multiple items, every item has a zone, every zone has multiple sizes and every size has…
I am new to JOLT. I am creating a JOLT specification to parse a JSON from one format to another. However when i use the RHS as "&1.name" it doesn't work as expected and creates a different format. But when…
I want to parse a nested json to csv. The data looks similar to this. {"tables":[{"name":"PrimaryResult","columns":[{"name":"name","type":"string"},{"name":"id","type":"string"},{"name":"custom","type":"dynamic"}]"rows":[["Alpha","1","{"age":"23","number":"xyz"}]]]} I want csv file as: name id age number alpha 1 23 xyz I tried: jq -r ".tables | .[] | .columns | map(.name)|@csv"…
i struggle to do something that look simple with axios : Here is my axios query : axios.get('/consumption_reports', { params: { exists: { energyDeliveryPoint : false } } }) The result is this query : consumption_reports?exists={"energyDeliveryPoint":false} When i would like…
My data is as below and saved in test folder with name risk.json [{ "Risk": "BN", "Classification": null, "LastDefaultDate": "1915-04-14 00:00:00" }] I have RiskClass defined as below @Data @JsonIgnoreProperties({"document"}) public class RiskClass implements KeyedObject { String risk; String classification;…
a potentially huge json-lines file with objects of known structure is to be converted to csv with headers. example {"name":"name_0","value_a":"value_a_0","value_b":"val_b_0"} {"name":"name_1","value_a":"value_a_1","value_b":"val_b_1"} {"name":"name_2","value_a":"value_a_2","value_b":"val_b_2"} {"name":"name_3","value_a":"value_a_3","value_b":"val_b_3"} {"name":"name_4","value_a":"value_a_4","value_b":"val_b_4"} expected output "name","value_a","value_b" "name_0","value_a_0","val_b_0" "name_1","value_a_1","val_b_1" "name_2","value_a_2","val_b_2" "name_3","value_a_3","val_b_3" "name_4","value_a_4","val_b_4" currently tried (if (input_line_number == 1 ) then…
Hello everyone i have a problem to fetch data from the api first thing first i will show u the guide of the api for showing images : Card Images Images are pulled from our image server images.ygoprodeck.com. You must…
I have a use case, where i need to drop a whole set of record if condition satisfied. Input { "Location": "IND", "Environment": "", "Climate": "Summer", "category": "City", "status": "De-Active" } Condition : If "status" is equals to "De-Active", the…