HSG/Cannulation

Summer

So I have blocked fallopian tubes and my doctors are setting me up to do a cannulation next month.

Has anyone ever had this done? Is it painful? Did they put you to sleep? Was it successful? Please give me all the experiences and tips - I’m super hopeful but don’t want to get my hopes up too much.