If you have ever used U2U CAML Query Editor, you will see it's very easy to get Sharepoint Datas from Lists.
If you haven't used U2U CAML Query Editor yet, you can get it here:U2U Caml Query EditorIt's a very easy to use application. First thing you need to is to Click "Connect".Then you will have to write your Sharepoint Portal URL:Then Click Connect. And you're free to use this tool. Click on a List Object and then Choose "New Query".What we're going to do is to get all the items in a List.The most easiest way is to get all the items whose ID are greater than and equal to 0.Write these values and then click Execute query which looks like this:Here is the result:See? We got all the records.Here I'm also giving the CAML Query: <Query> <Where> <Geq> <FieldRef Name="ID" /> <Value Type="Counter">0</Value> </Geq> </Where></Query>Hope it helps.
<Query> <Where> <Geq> <FieldRef Name="ID" /> <Value Type="Counter">0</Value> </Geq> </Where></Query>
Configure MinRole Search and Cloud Hybrid Features in SharePoint Server 2016 and Office 365