Get site lists

1. From the SharePoint Sites view, select sites and retrieve information about their lists clicking on the "Lists" button.

2. In the resulting Files view, you will see each sites' files listed in within their folder hierarchy where you can expand or collapse folders.

From there, you can select lists to retrieve their items and columns.

Get list items and columns

In the Lists view, you can:

1. Show System Lists which are hidden by default.

2. See the list items and their properties of selected lists by clicking ‘List Items’.

3. See column information of selected lists by clicking ‘List Columns’.