Ok, just called Clydesdale and a very helpful guy said he knows there is an issue with their open banking system when using the customer ID. He advised me that if i was to use my customer number instead which starts 90 then it should work, and it did!
For anyone also having problems with this please call their support and ask for your customer number which starts 90. The connection will then work.