Retrieving data from a paginated API

[Lethabo5]

Hi 

I am trying to retrieve data from this API. It is paginated. But I keep getting this error

1. Expression.Error: We cannot convert a value of type Table to type List. Details: Value=Table Type=Type

   I am not sure what I'm doing wrong.  I am very new to M. Any assistance will be greatly appreciated

   let

     ufnGetList = (pgToken) =>

      let

      actualUrl = "https://api.XXXXXXXXX.com/v1/user",

      options = [Headers =[#"Content-type"="application/json",

                 #"Authorization"="Bearer eyXXXXXXXXXXXXXXXXXXXXXX"]],

       result = Web.Contents(actualUrl, options),

     nextPageToken = try result[nextPageToken] otherwise null,

     items = result[items],

     record = [items = items, nextPageToken = nextPageToken]

     in

     record,

     resultSet = List.Generate(

             () => ufnGetList (""),

             each _[nextPageToken] <> null,

             each ufnGetList(_[nextPageToken]),

             each [nextPageToken =_[nextPageToken], items =_[items]]

     ),

     lastPageToken = List.Last(Table.FromRecords(resultSet)[nextPageToken]),

     lastResultSet = ufnGetList(lastPageToken)[items],

     fullResultSet = Table.Combine({Table.FromRecords(List.Combine(Table.FromRecords(resultSet))), Table.FromRecords(lastResultSet)})

     in

     fullResultSet

[v-chuncz-msft · Accepted solution]

@Lethabo5 ,

Remove Table.FromRecords in List.Last.

List.Last(resultSet)[nextPageToken],