Combining API Call with two functions (including pagination)

Hi,

I am trying to call an API in Power BI and have run into a roadblock.

 The API parameters only allow 1 site to be entered, so I have created Function 1 and invoked it on a site table (using site email as @hostEmail). But it is only returning 100 records per site.

Following a tutorial, I created Function 2 for pagination (record count unknown) and invoked it on a List query to loop and get all records, but it only works for 1 site.

Is it possible to get the pagination working in Function 1?

All Site Call - Function 1

-----------------------------------------

(hostEmail as any) => let

    Source = Json.Document(Web.Contents("https://webexapis.com/v1/" & "meetings"

      &"?&hostEmail="&(hostEmail)
      [Headers=[Authorization=List.Min(#"Refresh Token (POST)")]])),

    #"Converted to Table" = Table.FromRecords({Source}),
   #"Removed Columns" = Table.RemoveColumns(#"Inserted Minutes",{"Custom"})

in

    #"Removed Columns"
-----------------------------------------

Pagination 

Query using Function 2

-----------------------------------------

= List.Generate(()=>

[Result = try MeetingwOffset(100) otherwise null, Offset=100],

each [Result] <>null,

each [Result= try MeetingwOffset([Offset]+100) otherwise null, Offset=[Offset]+100],

each [Result])

-----------------------------------------

Function 2

-----------------------------------------

(Offset as number)=>let

    Source = Json.Document(Web.Contents("https://webexapis.com/v1/" & "meetings"

    &"?hostEmail=AAA"

     &"&max=100&offset="&Number.ToText(Offset),

    [Headers=[Authorization=List.Min(#"Refresh Token (POST)")]])),

    #"Converted to Table" = Table.FromRecords({Source}),

    #"Removed Columns" = Table.RemoveColumns(#"Inserted Minutes",{"Custom"})

in

    #"Removed Columns"

-----------------------------------------

Thank you for your help in advance.