Using an API to get the rare disease for a list of drugs

Hi All. I have a list of 4000+ drugs in an excel. In an adjacent column, I want to find out the rare disease associated with the drug. I’ve heard of APIs from Orphanet before but I’m unable to retrieve the info. Could someone please help? TIA