I am having a really difficult time importing from a JSON similar to this one. I have no problems with the majority of the data. It is the data contained in the section below that is:
"configurations" : {
"ABC_data_version" : "4.0",
"nodes" : [ {
"operator" : "OR",
"123_match" : [ {
"vulnerable" : true,
"testdata" : "c:a:gksu-polkit_project:gksu-polkit::::::::",
"versionEndExcluding" : "0.0.3"
} ]
}, {
"operator" : "OR",
"123_match" : [ {
"vulnerable" : true,
"testdata" : "abc:2.3:o:debian:debian_linux:6.0:::::::*"
} ]
Here is a snippet of the cypher I am trying
<UNWIND ['test.json'] as filename>
<CALL apoc.load.json(filename) YIELD value AS n>
<FOREACH (123_match IN v.configurations.nodes.123_match |>
< FOREACH (abc23 IN v.configurations.nodes.123_match[0].abc23Uri |>
<MERGE (abc23Uri: abc23Uri {abc23Uri:abc_match[0].abc23Uri})>
The error message"Type mismatch: expected a map but was List{Map" is returned. I have tried using [0] and other fixes I have seen but none work. The 123_match is the field I am unable to create a node with. Everything else works (non of the cypher for that is included here)
Source data example:
"ABC_Items" : [ {
"ABC" : {
"data_type" : "ABC",
"data_format" : "ABCDE",
"data_version" : "4.0",
"ABC_data_meta" : {
"ID" : "ABC-1234-0703",
"ASSIGNER" : "ABC@ABCDE.org"
},
"problemtype" : {
"problemtype_data" : [ {
"description" : [ {
"lang" : "en",
"value" : "XYZ-20"
} ]
} ]
},
"references" : {
"reference_data" : [ {
"qwe" : "sdfkjsadhkjaccess.redhat.com/security/ABC/ABC-1234-0703",
"name" : "sdfkjsadhkjaccess.redhat.com/security/ABC/ABC-1234-0703",
"refsource" : "MISC",
"tags" : [ "Broken Link" ]
}, {
"qwe" : "sdfkjsadhkjsecurity-tracker.debian.org/tracker/ABC-1234-0703",
"name" : "sdfkjsadhkjsecurity-tracker.debian.org/tracker/ABC-1234-0703",
"refsource" : "MISC",
"tags" : [ "Third Party Advisory" ]
} ]
},
"description" : {
"description_data" : [ {
"lang" : "en",
"value" : "In gksu-polkit before 0.0.3, the source file for xauth may contain arbitrary commands that may allow an attacker to overtake an administrator X11 session."
} ]
}
},
"configurations" : {
"ABC_data_version" : "4.0",
"nodes" : [ {
"operator" : "OR",
"123_match" : [ {
"vulnerable" : true,
"testdata" : "c:a:gksu-polkit_project:gksu-polkit::::::::",
"versionEndExcluding" : "0.0.3"
} ]
}, {
"operator" : "OR",
"123_match" : [ {
"vulnerable" : true,
"testdata" : "abc:2.3:o:debian:debian_linux:6.0:::::::*"
} ]
} ]
},
"impact" : {
"baseMetricV3" : {
"yyyyy3" : {
"version" : "3.1",
"vectorString" : "yyyyy:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H",
"attackVector" : "NETWORK",
"attackComplexity" : "LOW",
"privilegesRequired" : "NONE",
"userInteraction" : "NONE",
"scope" : "UNCHANGED",
"confidentialityImpact" : "HIGH",
"integrityImpact" : "HIGH",
"availabilityImpact" : "HIGH",
"baseScore" : 9.8,
"baseSeverity" : "CRITICAL"
},
"exploitabilityScore" : 3.9,
"impactScore" : 5.9
},
"baseMetricV2" : {
"yyyyy2" : {
"vers" : "2.0",
"vectorStr" : "A",
"accessV" : "NEK",
"accessCo" : "LOW",
"authentication" : "NONE",
"confidentialityImpact" : "PARTIAL",
"integrityImpact" : "PARTIAL",
"availabilityImpact" : "PARTIAL",
"baseScore" : 7.5
},
"severity" : "HIGH",
"exploitability" : 10.0,
"impac" : 6.4,
"acIn" : false,
"obtainAllP" : false,
"obtainUser" : false,
"obtainOther" : false,
"userInteraction" : false
}
},
"publishedDate" : "2019-11-15T17:15Z",
"lastModifiedDate" : "2019-12-03T14:55Z"
},
Please provide the following information if you ran into a more serious issue:
- neo4j version, desktop version, browser version
3.5.6, Browser version 4.0.1