Python json.loads returning JSONDecodeError Expecting ',' delimiter Problem Description: I am trying to parse a JSON raw string using json.loads but its throwing following error JSONDecodeError at /octopus/entries/53/test_sample_job/ Expecting ‘,’ delimiter: line 3 column 27 (char 48) My json string data is as follows and I am getting error when i did json.loads(data) data = … Read more
JQ – map an array changing existing properties only, leaving others intact Problem Description: Considering the following json: [ { "propertyA": 11, "nestedPropertyB": [ 12 ] }, { "propertyA": 21 } ] I would like to get the following result: [ { "propertyA": 11, "propertyB": 12 }, { "propertyA": 21, "propertyB": null } ] I … Read more
How to find a bus stop in array by a route? Problem Description: i’ve got a problem. We’ve got a route that serves multiple bus stops. We’ve got one bus stop from the whole route. Now how to find the stop that goes next on this route? The "_stopNum": "1" means the stop is the … Read more
Concatenation operation not working in JOLT Problem Description: I am trying to concat two string in JOLT. The field in which I want the output is popping up but it’s value is not populating. What I want- WG_REQ_FIRST_NAME- Sam WG_REQ_LAST_NAME- Jones requesterDetails- Sam Jones Current output- Input is to long so I have uploaded the … Read more
I expect the result to be a dictionary but it is accessed like a property… why? Problem Description: I have this JSON coming from a server… { "cars": [ { "name": "Ferrari", "price": "100" }, { "name": "Lamborghini", "price": "200" }, { "name": "Ford Pinto", "price": "1" } ] } This JSON is a dictionary … Read more
How can I create a json file using python which will contain one key and under that multiple key value pairs using a for loop Problem Description: I want my Json file to look like this- The Name values I am taking from another Json file. {"Name1":{ "Age": 30, "Gender": "Male", }, "Name2":{ "Age": 25, … Read more
JSON: TypeError: string indices must be integers Problem Description: I’m trying to filter following .json file example where ["cbaCode"][‘HHH’] differs from ‘300’: { "took" : 32, "timed_out" : false, "_shards" : { "total" : 12, "successful" : 12, "skipped" : 0, "failed" : 0 }, "hits" : { "total" : { "value" : 1549, "relation" … Read more
Cannot read specific key from JSON file with Powershell Problem Description: I have a large JSON file (vehicle data) from which I want to read 1 specific value (vehicle identification number, for example). So, following this answer, I have this code with debug output: $json = Get-Content $responsefilepath | ConvertFrom-Json Write-Host $json Write-Host $json.values | … Read more
Cannot read specific key from JSON file with Powershell Problem Description: I have a large JSON file (vehicle data) from which I want to read 1 specific value (vehicle identification number, for example). So, following this answer, I have this code with debug output: $json = Get-Content $responsefilepath | ConvertFrom-Json Write-Host $json Write-Host $json.values | … Read more
Cannot read specific key from JSON file with Powershell Problem Description: I have a large JSON file (vehicle data) from which I want to read 1 specific value (vehicle identification number, for example). So, following this answer, I have this code with debug output: $json = Get-Content $responsefilepath | ConvertFrom-Json Write-Host $json Write-Host $json.values | … Read more