Read sheet2api with credentials

Question

I am used sheet2api to convert spreadsheet to api.

I used the below credentials.

user id : test

password :test

https://sheet2api.com/docs/UHC796KdSvqC/testsp

As per their documentation here is the instructions to read api can you give an equivalent C# MAUI Blazor code

Authentication

If you have configured your API to require authentication then all requests will need to include an Authorization header.

The credentials are constructed like this:

The username and the password are combined with a colon (aladdin:opensesame).

The resulting string is base64 encoded (YWxhZGRpbjpvcGVuc2VzYW1l).

That string should when be included within the Authorization header:

Authorization: Basic YWxhZGRpbjpvcGVuc2VzYW1l

Answer 1

That is standard basic authentication. Most likely the site does not support CORS. because blazor runs in a webview, it requires CORS support to call a webapi.

you will probably need to proxy the calls via the hosting app. you can probably use the access to the blazor services to inject into a service a proxy.

Answer 2

Closing the question as the free api has some limits