Excel VBA API Access Example

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]