Has anyone had to get an HSG done?

Stelsie

Has anyone had to have a Hysterosalpingography (HSG) done? Was it painful? Can you give me some insight into what it will be like? Do I need to take the day off work? Thanks!