fnGetSPOListColumns.pq

(sharepoint_site as text, list_title as text) =>
  let
    Source = Record.SelectFields(
      OData.Feed(
        sharepoint_site & "/_api/lists/getbytitle('" & list_title & "')", 
        null, 
        [Implementation = "2.0"]
      ), 
      "Fields"
    )[Fields], 
    Select_Columns = Table.SelectColumns(
      Source, 
      {"Id", "Title", "InternalName", "Indexed", "Required", "TypeDisplayName", "CanBeDeleted"}
    ), 
    Set_Types = Table.TransformColumnTypes(
      Select_Columns, 
      {
        {"Id", type text}, 
        {"Title", type text}, 
        {"InternalName", type text}, 
        {"Indexed", type text}, 
        {"Required", type text}, 
        {"TypeDisplayName", type text}, 
        {"CanBeDeleted", type text}
      }
    )
  in
    Set_Types