how to create a query that paginates?

Hi ImkeF & Community,

Need help with a similar problem.

Same as rest, started from DataChatn's blog and got stuck in some implementation.

https://datachant.com/2016/06/27/cursor-based-pagination-power-query/

I am trying to iterate over an API source, to fetch some data(pagination).

I have to do a "POST" request, and in the "content/query parameters", provide information for the next page (not part of url)

this information goes in as parameter named "AFTER" ( as seen in below snapshot- this is the value that we get from [data][next] response - keep reading)

In the responce of any query, I get three fields.

[data][post] --> this is my data part,

[data][remaining] -->count of entries left,

[data][next]-->a 64base code to be placed in the next query paramter to tell, starting point for next fetch

below documentation for reference:

The first query need to go either without "after" parameter, or we can set it to a stationary value. later queries can go and use "next"'s value for "after".

I have tried to do following - can someone please see, if there are some evident errors I have made here

let
	iterations = 10000 // just for initialization
	auth_key ="Basic myAuthKey",
	url =  "https://api.socialbakers.com/0/facebook/page/posts",
	header= [#"Authorization" = auth_key,
			#"Content-Type" = "application/json; charset=utf-8"],		
	content= "{
	        ""date_start"":""2017-08-16"",
		    ""date_end"":""2017-11-10"",
		    ""profile"":""88147621212"",
		    ""fields"":[""id"",""created"",""message ],           
                    ""limit"":5,
                    ""after"":[next] // Not sure if this is the right way to use the next value here
	        }",				
				
       // DO I need to pass just URL or Content as well in this method & define header wihtin the method?
	FnGetOnePage =
		(url) as record =>
let
	Source =Json.Document(Web.Contents(url,[Headers = header,Content = Text.ToBinary(content)])),
	data = try Source[data][posts] otherwise null,
	next = try Source[data][next] otherwise "somefixedvalue?",
	remaining = try Source[data][remaining] otherwise null,
	res = [Data = data, Next = next,rem = remaining]

in
    res,

	GeneratedList =
	List.Generate(
	()=>[i=0,res=FnGetOnePage(url)],
	each [i] <iterations and [res][rem]>0,
         // Not sure about the next two lines, if they are making sense in my scenario-
         // Depending how we designed our method - really confused about these
	each [i=[i] +1 , res = FnGetOnePage([res][Next])],
	each[res][Data])
in
   GeneratedList

 Any help is this reagrd highly appriciated.

Cheers.