Sub M_snb()
a = Split("merk handelsbenaming inrichting brandstof bruto_bpm")
c00 = Sheet1.Cells(2, 1).Text
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", "http://opendata.rdw.nl/resource/m9d7-ebf2.json?kenteken=" & c00, False
.send
sn = Split(Replace(Replace(.responsetext, Chr(34), ""), ":", "|:"), ",")
sp = Filter(Split(Join(Array(Filter(sn, a(0))(0), Filter(sn, a(1))(0), Filter(sn, a(2))(0), Filter(sn, a(3))(0), Filter(sn, a(4))(0)), ":"), ":"), "|", 0)
.Open "GET", "http:" & sp(3) & "?kenteken=" & c00, False
.send
sp(3) = Split(Filter(Split(Replace(.responsetext, Chr(34), ""), ","), a(3) & "_omschrijving")(0), ":")(1)
End With
Sheet1.Cells(3, 2).Resize(, UBound(sp) + 1) = sp
End Sub