I have a file with over 1 million ChEMBL drug identifiers, for which I need to acquire the common name of each drug. I have used the PubChem Identifier Exchange to map the ChEMBL IDs to synonyms, but the challenge I'm finding is that each ChEMBL ID can have numerous synonyms, and the drug names that I need don't appear to be listed in any particular order within each drug's synonyms (e.g. the drug name is sometimes listed as the first synonym, but often buried later in the list).
I'm wondering whether anyone has experience in mapping ChEMBL/drug IDs to drug names in an efficient way, as it will not be feasible for me to manually select the correct choice for each drug. Thanks for any suggestions you can provide.