cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Having some troubles when working with JSON file

Hi everyone!

I'm trying to load a JSON file but I have some troubles. The file is constructed as follows:

{
 "key1": "value1",
 "key2": "value2",
 "key3": "value3",
 "layers": {
 "tls": {
          "tls.record": {
            "tls.record.content_type": "20",
            "tls.record.version": "0x00000303",
            "tls.record.length": "1",
            "tls.change_cipher_spec": ""
          },
          "tls.record": {
            "tls.record.content_type": "22",
            "tls.record.version": "0x00000303",
            "tls.record.length": "122",
            "tls.handshake": {
              "tls.handshake.type": "2",
              "tls.handshake.length": "118",
              "tls.handshake.version": "0x00000303",
              "tls.handshake.random": "16:36:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:cd",
              "tls.handshake.session_id_length": "32",
              "tls.handshake.session_id": "e7:d1:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:",
              "tls.handshake.ciphersuite": "4865",
              "tls.handshake.comp_method": "0",
              "tls.handshake.extensions_length": "46",
              "Extension: key_share (len=36)": {
                "tls.handshake.extension.type": "51",
                "tls.handshake.extension.len": "36",
                "Key Share extension": {
                  "Key Share Entry: Group: x25519, Key Exchange length: 32": {
                    "tls.handshake.extensions_key_share_group": "29",
                    "tls.handshake.extensions_key_share_key_exchange_length": "32",
                    "tls.handshake.extensions_key_share_key_exchange": "cf:84::xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:"
                  }
                }
              },
              "Extension: supported_versions (len=2)": {
                "tls.handshake.extension.type": "43",
                "tls.handshake.extension.len": "2",
                "tls.handshake.extensions.supported_version": "0x00000304"
              }
            }
               }
        }
}

Here is my issues: there are two objects in 'tls' with the name 'tls.record'. How can I dissociate them when importing?
Second one is the fact that the name of some objects are variables from one file to another (for example "Extension: supported_versions (len=2)" the 'len' can vary).

I'm actually using 'apoc.load.json'. I'm able to load all standards ''key" : "value" without troubles.

English is not my native langage, I apologize for any mistakes.

Thanks a lot for taking the time to read me ! 🙂

Xavier

0 REPLIES 0