y4VikC4Z

1let
2	Url = "https://xx.com/magento-api/rest/customers?order=entity_id&dir=asc",
3	Limit = "100",
4	consumerKey = "xx",
5	Token = "xx",
6	SignatureMethod = "PLAINTEXT",
7	Signature = "xx",
8	TimeStamp = "1551909334",
9	Nonce = "2NuM9DBGZHb",
10
11	Pagination = 
12		List.Generate( 
13			() => [
14				
15				Page = 1, 
16				Counter=0,
17				WebCall = Function.InvokeAfter(Record.FieldValues(
18					Json.Document(Web.Contents(Url, 
19						[Query=[limit="" & Limit & "",page="" & Text.From([Page]) & ""],
20							Headers=[Authorization="OAuth 
21								oauth_consumer_key=" & consumerKey & ", 
22								oauth_token=" & Token & ", 
23								oauth_signature_method=" & SignatureMethod  & ", 
24								oauth_timestamp=" & TimeStamp  & ", 
25								oauth_nonce=" & Nonce & ", 
26								oauth_version=""1.0"", 
27								oauth_signature=" & Signature & "
28							"]
29						]
30				)){Counter}),#duration(0,0,0,1))
31				
32				
33			], // Start Value      
34
35			each [Counter] < 5,
36		
37			each [ 
38				Page = [Page]+1,                         
39				Counter = [Counter]+1,
40				
41				WebCall = Function.InvokeAfter(Record.FieldValues(
42					Json.Document(Web.Contents(Url, 
43						[Query=[limit="" & Limit & "",page="" & Text.From([Page]) & ""],
44							Headers=[Authorization="OAuth 
45								oauth_consumer_key=" & consumerKey & ", 
46								oauth_token=" & Token & ", 
47								oauth_signature_method=" & SignatureMethod  & ", 
48								oauth_timestamp=" & TimeStamp  & ", 
49								oauth_nonce=" & Nonce & ", 
50								oauth_version=""1.0"", 
51								oauth_signature=" & Signature & "
52							"]
53						]
54					)){Counter}),#duration(0,0,0,1))
55			]
56		),
57
58	#"Table" = Table.FromList(Pagination, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
59	#"Expanded Column1" = Table.ExpandRecordColumn(Table, "Column1", {"WebCall"}, {"Column1.WebCall"}),
60	#"Column1 WebCall" = #"Expanded Column1"{0}[Column1.WebCall]
61in
62	#"Column1 WebCall"