I heard there's an endoscopy capsule pill that some hospitals uses, is it out yet and is it effective?

Capsule endoscopy. Capsule endoscopy has been commercially avaiable for almost 10 years, as a diagnostic tool to visualize the upper GI tract & small bowel without sedation & in "real time." a camera, led's, battery & transmitter are packaged into a small pill, weighted so the camera always points forward. A movie of what the pill sees (bleeding, masses, crohn's, etc.) is downloaded & interpreted by a GI doctor.
Yes. That has been available for many years now. However, it is generally used only when other endoscopic techniques have failed to show the exact location of an intestinal problem like bleeding and there remains high suspicion that the intestines are the source of the problem.