Do I have to get sedated to have an endoscope done in the doctor's room?

In general... At least sedation is the usual for endoscopy. Although hypothetically one might be able to do this without it, the procedure is uncomfortable enough that it warrants this level of anesthesia.