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...
Solved! Go to Solution.
Got a response:
Request.Open "POST", FeatureLayer URL /query?where=FID=1&outFields="Site_Name"&f=json&token=token string
Got a response:
Request.Open "POST", FeatureLayer URL /query?where=FID=1&outFields="Site_Name"&f=json&token=token string
I do all REST handling in Access / Excel VBA using this VBA Class library:
https://github.com/VBA-tools/VBA-Web