Retrieving PSC data using OpenRefine/GREL

Hi,

Does anyone have experience retrieving person of significant (PSC) control data for a list of companies?
I have company numbers and I’m using OpenRefine, but I’m not sure how the API key works, or what endpoint and GREL expression to use…

Any help would be greatly appreciated!

Christian Eriksson

Hello @m.christian.eriksson

We have bulk datasets located here for PSC
http://download.companieshouse.gov.uk/en_pscdata.html

With the bulk data set you may not need to use the API at all.

Hope this helps