Get immediate child (files and folder) from folder via CSOM C# SP Online

Question

Document Library
-----RootFolder -> File1
-------------------SubFolder1WithinRootFolder -> File2
------------------------------SubFolder2WithinSubFolder1 -> File3
---------------------------------------------------SubFolder3WithinSubFolder2

Hi,
I have folder object which contain files and sub folders. When I am using recursive or recursive all, it is giving me all files and folder and folder within folder etc.
I only want fetch only files and folder within specified folder. Not folder or files within its sub folder.
For e.g. if I target RootFolder it should return me File1 & SubFolder1
And when I target Subfolder1 it should return me File2 and SubFolder2

I also want item id while fetching these details.

Thanks.

Answer 1

Below query works for me.

CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = @"<View><Query><OrderBy Override=""TRUE""><FieldRef Name=""FileLeafRef"" /></OrderBy></Query><RowLimit>5000</RowLimit></View>";
camlQuery.FolderServerRelativeUrl = folder.ServerRelativeUrl;

Thanks