The basics of the each and _ functions in Power Query every Power Query advanced users need to master.
each
_
-PowerQuery -Youtube
RestAPI
Sharepoint