LoadItemsByCamlQueryAsync have a * in API call

[nepgya2803]

I'm using LoadItemsByCamlQueryAsync with pagination to get all items from a SharePoint list to local. Even though my caml query only limits specific fields returned from the Sharepoint list in the API call, it seems it is trying to return every column like this. The '*' in the call is very suspicious. I'm not sure if this was the reason why it

GetItems?$select=*,ID,EmployeeNumber

The caml query:

string caml = "<View>" +
        "<ViewFields>" +
          "<FieldRef Name='ID'/>" +
          "<FieldRef Name='EmployeeNumber'/>" +
        "</ViewFields>" +
        "<Query>" +
        "<OrderBy Override='TRUE' Ascending='TRUE'><FieldRef Name='ID'/></OrderBy>" +
        "</Query>" +
        "<RowLimit Paged='TRUE'>5000</RowLimit>" +
        "</View>";

Code:

bool paging = true;
string nextPage = null;
int pages = 0;

while (paging)
{
    await myList.LoadItemsByCamlQueryAsync(new CamlQueryOptions()
    {
        ViewXml = viewXml,
        PagingInfo = nextPage,
    });
    pages++;
    if (myList.Items.Length == pages * 5000)
    {
        nextPage = $"Paged=TRUE&p_ID={myList.Items.AsRequested().Last().Id}";
    }
    else
    {
        paging = false;
    }
}
return myList.Items.AsRequested();

[jansenbe]

@ngqtrieu99 : did you confirm via a network trace that effectively all columns are retrieved?