Converting Base64 value to use in pagination

Anonymous I actually cover this topic on The Definitive Guide to Power Query (M). You can binary encode and decode on the fly using something like this to decode for example:

let
  Source = 
    Text.FromBinary(
      Binary.Decompress(
        Binary.FromText(
          "Base64 encoded text",
          BinaryEncoding.Base64
        ),
        Compression.Deflate
      )
    )
in
  Source

Thank you Greg, I will work on adding this to my function and the list.Generate query. It would seem that I need to start with list.Generate to generate the table of the available pages, is that correct? I am still a beginner in M, even with years in Power BI.

Thanks

Yes it does return prev and next like so

This is my function, I had to add RelativePath to avoid the Power BI service error for dynamic datasource

(Page as text)=>
let
   Source = Json.Document(
       Web.Contents(
           "https://apis-us.Mycompany.com/v1/orgs/OrgID/projects",
           [RelativePath = "?page[size]=100&page[number]="&(Page),
           Headers=[Authorization="Bearer ####MyToken####", #"Content-Type"="application/vnd.api+json"]])),
    data = Source[data]

in
    data

Greg_Deckler here is a snip from the api documentation.

Additionally, responses include the links parameter, which provides URLs for the prev and next attributes (or null values if all of the items are on one page). Those URLs include the above parameters, so you can paste them into subsequent requests if needed.

Still trying to figure this out, the below code only returns page one. The "url" parameter is the full url for page one and "Token" is the key

et
    // Base URL
    baseUrl = "https://apis-us.MYAPI.com",
    initialUrl = baseUrl & "/v1/dep/13473/projects?page[size]=100&page[number]=MQ==",
    
    // Function to get data from a given URL with authorization header
    GetPage = (url as text) as record =>
        let
            response = Json.Document(Web.Contents(url,
            [Headers=[Authorization=Token, #"Content-Type"="application/vnd.api+json"]]
)),
            data = if Record.HasFields(response,"data") then response[data] else {},
            links = if Record.HasFields(response, "links") then response[links] else null, 
            nextLink = if links <> null and Record.HasFields(links, "next") then links[next] else null,
            nextUrl = if nextLink <> null and Text.StartsWith(nextLink, "http") then nextLink else baseUrl & nextLink
        in
            [Data = data, NextLink = nextUrl],
    
    // Function to loop through pages and combine data
    GetAllPages = (url as text) as table =>
        let
            firstPage = GetPage(url),
            allData = List.Generate(
                () => firstPage,
                each _[NextLink] <> null,
                each GetPage(_[NextLink]),
                each _[Data]
            )
        in
            Table.Combine(List.Transform(allData, each Table.FromList(_, Splitter.SplitByNothing()))),
    
    // Initial call to get all pages
    result = GetAllPages(initialUrl)
in
    result