Glad it works. A couple of points though.All lights are up and work great from a plug socket. I looked into it more and kinda understand how the lighting ring main works. I suspect the right way to wire it in, would be to add another junction box and wire it in like any other light? .
Firstly ( sorry to be pedantic) but to aid your “kinda understanding” of the wiring, lighting circuits are RADIALs not RINGs.
Second, you should not need a junction box, when you make this permanent and connect them to the lighting circuit. Any nearby light rose should provide you with the permanent LNE to power your lights.