Though I have not dealt with the same problem, the easiest way is probably to download the data directly from their FTP site and join it with the structural data. However, an alternative solution might also be to use the ChEMBL database. They integrate a lot of the PubChem bioassay data, as well as data from the literature and provide several ways of accessing it.

Hope that helped!