Integrating Companies House API with Clay: Seeking Experiences

Does anyone have any experience connecting companies house API into clay?

Muhammad S.
·
·
Yes, I recently did, are you getting stuck somewhere?
Leo B.
·
·
Yes, I am trying to get the PDF of the account filings but when I click the url link that gets given, the page is not avaliable
Leo B.
·
·
did you have this issueC?
Leo B.
·
·
https://document-api.company-information.service.gov.uk/document/a1aBqsXhUq0zOp_OPsfVo90_n5noPnz54RUWda4A-0g
Muhammad S.
·
·
because pdf is a binary file
Muhammad S.
·
·
Clay cant handle binary file
Muhammad S.
·
·
You have to upload the file on aws and then get back the URL in clay
Muhammad S.
·
·
The file returned by the API is a binary file
Leo B.
·
·
ahhh
Leo B.
·
·
makes sense
Leo B.
·
·
Is there anyway I can do that?
Leo B.
·
·
that part is new to me
Leo B.
·
·
I need to scrape the data in there
Muhammad S.
·
·
Yes Send a call to n8n, have n8n upload the file to aws and return the URL to caly.
Leo B.
·
·
Thank you
Leo B.
·
·
I will ping you if I am stuck
Muhammad S.
·
·
sure!
Leo B.
·
·
let me know if I can help with anythign
Muhammad S.
·
·
No worries, just lmk if you get stuck
Leo B.
·
·
Hey, had another question, did you have any trouble seeing which one of the directors were still active in the company
Leo B.
·
·
Hey Muhammad A. do you have any experience with the HM land registry?