topic REST GET URL VBA in ArcGIS Online Questions

REST GET URL VBA

Hornblower5953 — Mon, 27 Sep 2021 19:26:39 GMT

I'm trying to get access to my hosted feature layer from an access database in VBA
I setup an API key for the feature layer in Developer
URL copied from Developer

VBA

Set Request = New ServerXMLHTTP60

Request.Open "GET", <Point LayerURL>/&query?where=0=0&outFields=*&returnGeometry=false&f=html&Key=" & ApiKey, False

the response contains text in the <title> A potentially dangerous Request.Path value was detected from the client...

Re: REST GET URL VBA

Hornblower5953 — Tue, 28 Sep 2021 15:54:07 GMT

Got a response:

Request.Open "POST", FeatureLayer URL /query?where=FID=1&outFields="Site_Name"&f=json&token=token string

Re: REST GET URL VBA

janeinar — Fri, 17 Dec 2021 15:07:00 GMT

I do all REST handling in Access / Excel VBA using this VBA Class library:
https://github.com/VBA-tools/VBA-Web