REST API calls

[Jazz Engineer]

Within MS Access, is it possible to interrogate a remote website? The site posts relevant field names and provides sample code for reference. Not sure of the following:

1. Is it possible?
2. Would I need to write in another language and execute through API calls?
3. If 2='Y', is MS Access friendlier to one particular language over another?
4. Or am I best off writing code, such as VBA module?

I have a pretty good programming history. Unfortunately, for personal reasons I haven't really coded since 1996. Still, if at all possible, please respond. Including code is good. I have to learn VBA eventually.

Lastly, if I MUST write code, what is/are the best book(s) for learning VBA for Access?

Thank you,

Jazz Engineer

[orange]

I have no experience with REST API, But I found this that may give some insight.
Good luck.

[pbaldy]

I'm actually working on something now where I am pushing service requests to an api, but also learned how to pull data. Looks like:

    Dim req                   As New MSXML2.XMLHTTP60
    Dim reqURL                As String
 
    reqURL = "https://..."

    req.Open "GET", reqURL, False
    req.setRequestHeader "Accept", "application/json"
    req.setRequestHeader "ApiKey", "xxx"
    req.send

    Debug.Print req.Status & " - " & req.statusText
    Debug.Print req.responseText

[Jazz Engineer]

Hey,

Thanks for the links. They'll give me a lot to research.

[Jazz Engineer]

Orange (that your screen name?),

Thanks. You provided a lot of material for study.

[orange]

JE,
That's my screen name. Lots of materials in the links in my signature. Many of these reviewed, used and recorded over the years.
Hope you find them helpful. Good luck.