Delve into the chemical makeup of Ceftriaxone Sodium API and its broad spectrum of applications in treating bacterial infections and surgical prophylaxis.