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:
https://developers.arcgis.com/rest/se...

To find out more about the parameters of the Query operation, please use this ESRI document:
https://developers.arcgis.com/rest/se...