Hi,
I am currently working towards fetching data from company house using its Streaming API.
For this, I am using Azure Synapse Pipeline (Web activity).
I have created account on Company House, created an application, created a Streaming API key as well which are needed to fetch streamed data.
I needed assistance to establish a connection between this Streaming API and azure synapse.
Below tries I have done till now which has given me “401: Invalid authorization” error:
-Created Stream Key
-Appended “:” to the key and converted it to Base64
-Passed converted key as Header i.e., Basic {base64 code} as GET method.
-Even tried to pass username and password along with API key
None of the above seems to work.
please provide your assistance regarding this, about what am I doing wrong OR what things I am missing etc.
Thanks,
Neeraj