API Calls with VBA: Accessing External Data Sources

Consume REST APIs to bring data into Excel.

GET with headers

Function ApiGet(ByVal url As String, ByVal bearer As String) As String
    Dim x As Object: Set x = CreateObject("MSXML2.XMLHTTP")
    x.Open "GET", url, False
    x.setRequestHeader "Authorization", "Bearer " & bearer
    x.setRequestHeader "Accept", "application/json"
    x.send
    If x.Status = 200 Then ApiGet = x.responseText Else ApiGet = ""
End Function

Parse JSON and map fields to columns. Handle pagination and rate limits.