Excel VBA API Access Example
It has been a well-known secret that countless successful domain investors and marketing professionals are using dotDB to boost their productivity by orders of magnitude. They also use it to keep themselves at a leading competitive position in the industry. Many of them are not just using dotDB for checking domain names. They also use dotDB's API access feature to help automatize their daily routine, empowering themselves to focus on the decision making instead of mundane. While it sounds complicated, it's not. Today we would like to share a simple VBA program for querying dotDB via API access, from one of our very successful user, Kassey Lee:
Sub dotDB()
Dim hRequest As Object
Dim strAPIkey As String
Dim strURL As String
Dim strResponse As String
strAPIkey = "(your API key)"
strURL = "https://api.dotdb.com/v1/search?keyword=apple"
Set hRequest = CreateObject("MSXML2.XMLHTTP")
With hRequest
.Open "GET", strURL, False
.SetRequestHeader "Authorization", "Token " & strAPIkey
.Send
End With
strResponse = hRequest.ResponseText
MsgBox strResponse
End Sub
You need to change the API key first, then you can call "dotDB" function from your Excel or Word file. It will query "apple" keyword and display the result in a message box. That's it, and you can modify the code a bit to make your routine automatic.
Love to see more content like this showing how you can write programs to automate your daily routine? Please feel free to send us an email at [email protected]