Excel VBA: Retrieving Outlook Address Book Values
Custom Excel VBA function to retrieve field values from an Outlook address book entry. Searches both local contacts and Exchange address books.
Blog
Astro: Collection Pagination Using Rest Parameter Dynamic Route
Astro pagination capability using collections and dynamic routes with a rest parameter. Resolves type issues and generates post listings with page navigation.
Power Query: Access REST APIs Secured by Basic Auth and API Key
Querying REST APIs secured by both Basic Authentication and API tokens, using Power Query. Anonymous instead of Basic authentication is used for the data source.
Power Query: Handling Paginated REST API Data
Multiple solutions for querying paginated REST APIs with known or unknown page counts or entry counts, using Power Query.
Power BI Map Visualizations: Mapping Continents and Countries
Display continents and countries using Power BI map visualizations. Country-level mapping is challenging due to geopolitical issues and inconsistent naming.