I am trying to run a simple Perl JSON example with the JSON Perl module and can't find the issues with line: my $json_data = decode_json(<$fh>); I get the following error. Any help would be appreciated. Susan@Kona MINGW64 /c/data/data/data/quickPerlTest $…
I have a JArray from a json-file like this: [ { "pos": 36, "name": "name1", "id": 1 }, { "pos": 36, "name": "name2", "id": 2 }, { "pos": 36, "name": "name2", "id": 3 } ] And I need save json…
I have a task to upload MySQL table JSON data to the rest API. I am loading the data in the Pandas dataframe and transforming it and trying to make a single JSON value to post to the API endpoint.…
I need help to remove null elements from JSON using jolt. I want to remove only root level elements containing null. Input : { "x": null, "y": null, "z": [ { "id": "1", "name": "2", "price": null, "quantity": 1 }…
I am trying to write a jolt specification to transform an input JSON. I have the following input: [{ "id": "11500887", "created": "2023-03-16T18:34:24.485+0200", "items": [{ "field": "status", "fieldtype": "jira", "fieldId": "status", "from": "10000", "fromString": "In Definition", "to": "1", "toString": "Open"…
I want to remove all Id from dep_array that exists in the dep_log array and have deleted=0. //array of departments ID dep_array=['3', '2', '1']; dep_log=[{"department_id": "3", "creation_date": "2023-05-13 17:59:27", "created_by": "1", "deleted":"0"} , {"department_id": "2", "creation_date": "2023-05-13 17:59:11", "created_by": "1",…
I have two simple JSON objects, I'm trying to add a single object from a Bash variable newValArr in order of the corresponding objects to the masterfile.json. They appear as following: newValArr [{ "firstValue": "foo", "secondValue": "bar"}, { "firstValue": "baz",…
I have a JSON file with some data on it, like the below one: { "84d0da32-c945-9844-86cc-4b4bd6100dc5": { "UUID": "84d0da32-c945-9844-86cc-4b4bd6100dc5", "GroupName": "TEST1", "EntryTitle": "host1", "Username": "sys", "NewPassword": "@PVmkiajauauajjhfz-5/NN" }, "test": { "UUID": "5c3c162f-0a80-f949-85a0-afcf9aedb6c8", "GroupName": "TEST2", "EntryTitle": "host2", "Username": "sys", "NewPassword": "H7-uPz2mkaaua@ki7q?NSs?"…
I have a JSON file in the following structure: { "10712": { "id": "10712", "age": 27, "gender": "male" }, "217": { "id": "217", "age": 60, "gender": "female" } } This causes a problem when importing using spark.read.json, because of the…
I'm on ubuntu system trying to connect to my local sql server from my (ASP).net application i configured the string connection "ConnectionStrings": { "DefaultConnection": "Server=localhost\mssqllocaldb;Database=temaintdb;User Id=sa; Password=******;" }, also i enabled the TCP/Ip ,and allowed the port 1433, and tried…