I am having trouble connecting the Companies House API in my Synapse Pipeline.
The steps I have made so far include:
Source - Rest API
- base URL: https://api.company-information.service.gov.uk/ or +company/ or +company/company_number or https://api.companieshouse.gov.uk/.
- Authentication:
a. Basic - provide my username and password from companies house account
b. Anonymous - no username, password - Auth Headers:
a. APIKey
b. X-API-Key
c. Authorization (available only when selecting the Anonymous Authentication) - No Annotations, Parameters, Advanced Settings.
The connection test is successful every time but I can’t figure out what is missing to get the 200 code that is needed.
I am getting 400 error with {“error”:“Invalid Authorization header”,“type”:“ch:service”}
or 401 error with message {“error”:“Empty Authorization header”,“type”:“ch:service”}
Can you please point out if there is any step wrong and what should be used instead of what I am inputting?