https://blog.faq400.com/en/web-services-en/consuming-rest-web-services-sql-http-functions-authentication/
Consuming REST web services with basic authentication