How to use the companies house API?

Question

I was hoping I could use Alteryx to extract some data off companies house using their API - I'm hoping it's not massively complicated, I just want to be able to pull a list of companies and registered directors in the UK.

I saw an example of a case on here which used the API before regarding getting PDF docs and I tried to adapt that for my use, but I don't think I understand it entirely.

Would appreciate if someone could give a bit of guidance maybe (if someone has already utilised Alteryx to get this information even, I couldn't find anything in my searches).

I have created a developer profile and followed the instructions as per the companies house website, but getting stuck on how to use the API.

Thanks for any help!

JosephSerpis · Answer

Hi @Lili7891 I would check your API key like I said I used this myself and had no issue with my API key from Companies House. Have you tried calling the API through  postman? I typically work with API in postman to check I have everything I need before I transition to Alteryx.

Lili7891 · Answer

@JosephSerpis Tried using your solution but keep getting the following

{"error":"Invalid Authorization","type":"ch:service"} HTTP/1.1 401 UnauthorizedDate: Mon, 12 Sep 2022 11:18:39 GMTContent-Type: application/jsonContent-Length: 53Connection: keep-aliveAccess-Control-Allow-Origin: *Ch-Authentication-Error: Invalid AuthorizationWww-Authenticate: Invalid or no A... error Invalid Authorization
{"error":"Invalid Authorization","type":"ch:service"} HTTP/1.1 401 UnauthorizedDate: Mon, 12 Sep 2022 11:18:39 GMTContent-Type: application/jsonContent-Length: 53Connection: keep-aliveAccess-Control-Allow-Origin: *Ch-Authentication-Error: Invalid AuthorizationWww-Authenticate: Invalid or no A... type ch:service

Lili7891 · Answer

Amazing, I'll give this a go and report back if I've managed to work it out, thanks so much!