Getting data from web where next page token generates uniquely every time Eg Youtube api

Problem solved

Created a table on sheet1 with name youtube

and I wrote the code as follows, if anyone wants help , i can explain

let
Source = Excel.CurrentWorkbook(){[Name="YouTube"]}[Content],
url = Source{2}[String],

FnGetOnePage =
(url) as record =>
let
Source = Json.Document(Web.Contents(url)),
nextPageToken = try Source[nextPageToken] otherwise null,
items = try Source[items] otherwise null,
Res = [Data = items , Token = nextPageToken]
in
Res,

TotalCount = Json.Document(Web.Contents(url)),
pageInfo = TotalCount[pageInfo],
totalResults = pageInfo[totalResults],
iterations = Number.RoundUp(Value.Divide(totalResults,50)),

GeneratedList =
List.Generate(
()=>[i=0, res = FnGetOnePage(url)],
each [i]<iterations,
each [i=[i]+1, res = FnGetOnePage(url&[res][Token])],
each [res][Data]),

ToTable = Table.FromList(GeneratedList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Expand = Table.ExpandListColumn(ToTable, "Column1"),
Snippet = Table.ExpandRecordColumn(Expand, "Column1", {"snippet"}, {"snippet"}),
GenList = Table.ExpandRecordColumn(Snippet, "snippet", {"publishedAt", "title", "description", "position", "resourceId"}, {"publishedAt", "title", "description", "position", "resourceId"}),
VidID = Table.ExpandRecordColumn(GenList, "resourceId", {"videoId"}, {"videoId"})
in
VidID