How do we use restful APIs from Excel macros (vba)?

You can use the MSXML library within VBA. Then you can create an XMlHTTP request and do a GET or POST etc. Here's a code sample below. It uses late binding i.e. no need to reference the library first:

Option ExplicitSub Test_LateBinding()    Dim objRequest As Object    Dim strUrl As String    Dim blnAsync As Boolean    Dim strResponse As String    Set objRequest = CreateObject("MSXML2.XMLHTTP")    strUrl = "https://jsonplaceholder.typicode.com/posts/1"    blnAsync = True    With objRequest        .Open "GET", strUrl, blnAsync        .SetRequestHeader "Content-Type", "application/json"        .Send        'spin wheels whilst waiting for response        While objRequest.readyState <> 4            DoEvents        Wend        strResponse = .ResponseText    End With    Debug.Print strResponseEnd Sub

I'm using this testing website - JSONPlaceholder - to call a RESTful API. This is the response:

Note that I found that calls to this website with this method fail if you a) make a synchronous request, or b) use http not https.

Here, you can find a detailed example using REST API for getting the information from JIRA and loading into excel worksheet. The excel file with the macros can be downloaded from the post. Anyway, it includes a detail explanation on each step in case you want to do it your self for your specific purpose. It's not worth repeating here. I was looking for a similar solution and this is so far, the only post I have found that covers from end to end this problem.