Basic access authentication is a way for a user to provide a username and password when making an API request.
Authorization: Basic X
X is the Base64 encoded version of the users credentials and it is the only value that needs to be replaced in this header.
The first step is to base64 encode your credentials (your username and password).
You can base64 encode from command-line: https://www.serverlab.ca/tutorials/linux/administration-linux/how-to-base64-encode-and-decode-from-command-line/
Or you can use an online encoder such as this one, if you are okay with entering your credentials on a third-party website: https://www.base64encode.org/
Note: some APIs require the username and API key to be encoded instead of the password. Check the API docs.
Alternative base64 encoder: https://www.debugbear.com/basic-auth-header-generator
Now that you have the encoded value of your credentials, you can enter your basic auth header into Apipheny, so you can call the API in your Google Sheet.
Basic, followed by a space, then paste your encoded credentials
Here’s what your header should look like:
Don’t forget to leave a space between Basic and your encoded credentials in the header value.
Then just click the Run button at the bottom of Apipheny to confirm if your API request works successfully.
If you get an error, confirm that you’ve encoded your credentials correctly, or contact us so we can help you.
Make a GET request
Make a POST request
PUT, PATCH, & DELETE Requests
Save requests for later
Schedule requests for automatic updates
Reference cell values in requests
=APIPHENY custom function
Stack multiple URLs in a single request
Run all saved requests at once
Modify your request settings
Import & export saved API settings
Alpha Vantage API
Constant Contact API
Facebook Graph API
Facebook Ads API
Google SERP API
Linkedin Ads API
Product Hunt API
Reddit Ads API
Riot Games API