+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 29 of 29

UK Companies House API

  1. #16
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,723

    Re: UK Companies House API

    Id just like to say that this is beautiful..........Ive just started looking at a project which involves CH data so this should be ideal starting point.
    If someone has helped you then please add to their Reputation

  2. #17
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,508

    Re: UK Companies House API

    No problem, if you use it and add any more to the wrapper, upload it and I'll update my workbook with your additions

  3. #18
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,723

    Re: UK Companies House API

    hmmm I seem to be having a problem and apologies if it should be in a new thread (Im guessing not but no doubt fast gun Ali will delete if not valid )

    Ive created a key, added it to the constants and attempting searches but each time I get the following error

    "The server name or address could not be resolved"

    When I debug it steps through and correctly constructs the search query, the baseURl and qry variables hold the expected data but then fails in the .Send (hangs for 5 seconds or so before returning the error).

  4. #19
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,508

    Re: UK Companies House API

    What happens if you copy and paste it into the browser? Sounds like you've misspasted your API key

  5. #20
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,723

    Re: UK Companies House API

    Ive checked and double checked the Key and its spot on.

    If I paste the query thats created into a browser
    https://api.companieshouse.gov.uk/se...&start_index=0

    I just get nothing, it flashes up in bottom left with "Establishing a Secure connection" but nothing else happens.

  6. #21
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,508

    Re: UK Companies House API

    Hmmm, I've just tried it and it's working fine. Just to try and rule out some issues, try swapping:
    Please Login or Register  to view this content.
    with
    Please Login or Register  to view this content.
    In CompaniesHouseRequest

    I was being slack with the browser thing, it won't work since you're not authenticated

  7. #22
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,723

    Re: UK Companies House API

    you sir, are a genius.

    Much kudos to you.

  8. #23
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,508

    Re: UK Companies House API

    No worries, it's a networky config thing at your work that's causing the issue (probably a proxy server)

  9. #24
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,723

    Re: UK Companies House API

    hmmm that would make sense it is a seriously secure network

  10. #25
    Registered User
    Join Date
    02-28-2017
    Location
    Birmingham
    MS-Off Ver
    7
    Posts
    1

    Re: UK Companies House API

    Hello everyone,

    I am new here and am impressed by the work you do here to help on a daily basis.
    I just stick on this topic as it seems to be the only one on the internet to tell how to extract companies house's data and to put it in an excel file.
    The problem is I am really not an IT expert, and when I open your file Kile, I cannot play the macro.
    Reading your comments i might need an API key but I do not know how it works either.

    Would you have a sort of a tutorial to make your program work?
    Not much details, just some clues, i'll check what to do on other websites.

    Thank you very much,

    Picolaud

  11. #26
    Registered User
    Join Date
    11-08-2012
    Location
    birmingham, uk
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: UK Companies House API

    Hi Kyle,
    You sir are amazing, this is awsome work. I got my api key and form worked for me. so thanks to you...
    I have a list of companies for which I have to download certain fields and i type them manually everyday, I am wandering if there is any way from company number we could retrieve information like company name, incorporation date or accounts due by date etc on the same line in next columns of worksheet not in a form that would make my life so much easier. don't know even if this is possible, any help is much appreciated.
    Many Thanks

  12. #27
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Bournemouth
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: UK Companies House API

    Hi all

    I have taken one of Kyle's tools and have managed to tweak it a little to collect a few extra fields.

    I am now trying to collect the filing history to collect the transaction_ID for the latest accounts a company.

    I can pull in the json file and see the data in the locals windows. From what I can tell the lowest item number is the latest record. I only need this record not the historical data.

    Has anyone had any success in pulling just the latest record from a JSON from Companies house?

    For some reason I cant upload my file

    Appreciate any advise or help.

    Thanks

  13. #28
    Registered User
    Join Date
    07-30-2018
    Location
    Monmouth, Wales
    MS-Off Ver
    365 Business
    Posts
    1

    Re: UK Companies House API

    Thanks for this Kyle. Very impressive. I would be interested in the script to generate the classes if it's not too much trouble.

    Cheers

    apostleit

  14. #29
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,508

    Re: UK Companies House API

    This was a while ago and I'm not sure I still have it, I'll have a look tomorrow

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1