ArcGIS OnLine and the REST API - bring live geo-data into Excel
Вставка
- Опубліковано 5 чер 2022
- Video #138
This longer video covers the use of the REST API. In it I:
- Give a high level overview of the REST API
- Build a REST API query to interrogate a feature service in ArcGIS OnLine
- Show the difference between HTML, JSON, PJSON and GeoJSON responses
- Ingest web data into Excel using an INTERSECT query via REST API
- Ingest web data into Excel using an attribute query via REST API
My data sample is open data and so Tokens are not actually needed. If you need that authentication to access your ArcGIS Secure Services then make sure you read this doc:
developers.arcgis.com/rest/se...
To find out more about the parameters of the Query operation, please use this ESRI document:
developers.arcgis.com/rest/se... - Наука та технологія
Hey! this is the most helpful resource relating to this topic. ESRI's explanation is quite vague.
Really nice intro. Thank you
Hi, can you please post the link for the token generation video?
can this be done to connect power bi to portal/arcgisonline? I cannot get the two to talk to each other
The short answer is yes.
You can find what you need here: resource.esriuk.com/blog/how-to-use-arcgis-with-power-bi/ and I have successfully done this myself. However, you need to make sure you have the right security clearance. You must be able to see that REST endpoint with its layers. Other issues could be around gateways/firewalls if you are trying to access from within corporate infra.