Companies House API-MS Access Integration
Budget: $30 – $250 AUD
I am seeking a solution to integrate the Companies House API (https://developer.company-information.service.gov.uk/) with a Microsoft Access database using VBA. The goal is to retrieve directors' and secretaries' names and store them in a table, using company numbers from another table. Below are the detailed requirements:
Requirements:
1- API Connection Setup:
Establish a connection to the Companies House API using VBA in MS Access.
Let me know what API type and credentials for authentication are needed.
2- Data Retrieval:
Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database.
Ensure the data is accurately parsed and stored in a new table (Optional).
3- Automation:
Develop a VBA script to automate the data retrieval process.
Additional Notes:
Include instructions on how to use and maintain the solution, in case we needed to change the API key.
The solution should be robust.
Experience with VBA, and API integration is essential.
Please provide an outline of your approach.
Requirements:
1- API Connection Setup:
Establish a connection to the Companies House API using VBA in MS Access.
Let me know what API type and credentials for authentication are needed.
2- Data Retrieval:
Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database.
Ensure the data is accurately parsed and stored in a new table (Optional).
3- Automation:
Develop a VBA script to automate the data retrieval process.
Additional Notes:
Include instructions on how to use and maintain the solution, in case we needed to change the API key.
The solution should be robust.
Experience with VBA, and API integration is essential.
Please provide an outline of your approach.