I sort of had it done, they placed the catheter in the cervix but had trouble setting it through due to a blockage and did not want to force it through, it was slightly undignified but not painful but i did not have the dye and they say that that is the uncomfortable part, a bit like af pain but worse.
It should be over and done with within about half hor.
Good luck and im sure you will be fine