Cable to connect brickpi to motor

I have already got a raspberry PI and have been looking at using it for robotics.
Searching through your website and forum someone posted that they had brought a lego 42001 kit as it had enough parts to build the simple bot.
I have found the motor 53787 on ebay and other sites but without the cable.

So my question is, what cable for I need , is it similar to an Ethernet cable, think I have seen rj45 mentioned on the forum?

Also the bom for the simple to has one 55806 cable itemised, is this correct, should it be two?

If you’re going to use the 53787 motor, all you’ll need to connect is a set of NXT cables. They can be found here. They’re special cables with the latch to the side, rather than to the middle.