Understanding the role of linker flexibility in soft porous coordination polymers