Handle pagination in Zendesk Basic Auth

Dears, 

I need your help in this Power Query, I already connected to MY Zendesk API and fetch the data from their and as you know it only retrieve one page at a time, so i'm trying to loop over all pages and export data from their. but i got an error: "Expression.Error: The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer" 

which is related to the access user/password "authontication" the code not able to process and grant them to proccess. 

this is my code:

let 
    BaseUrl         = "https://yourdomain.zendesk.com/api/v2/tickets?",
	User		="yourusername",
	Password		="yourpassword",
    EntitiesPerPage = 100,
 
    GetJson = (Url) =>
        let Options = [Headers=[ #"Authorization" = "Basic " & User &":" & Password ]],
            RawData = Web.Contents(Url, Options),
            Json    = Json.Document(RawData)
        in  Json,
 
    GetEntityCount = () =>
        let Url   = BaseUrl & "$count=true&$top=0",
            Json  = GetJson(Url),
            Count = Json[#"@odata.count"]
        in  Count,
 
    GetPage = (Index) =>
        let Skip  = "$skip=" & Text.From(Index * EntitiesPerPage),
            Top   = "$top=" & Text.From(EntitiesPerPage),
            Url   = BaseUrl & Skip & "&" & Top,
            Json  = GetJson(Url),
            Value = Json[#"value"]
        in  Value,
 
    EntityCount = List.Max({ EntitiesPerPage, GetEntityCount() }),
    PageCount   = Number.RoundUp(EntityCount / EntitiesPerPage),
    PageIndices = { 0 .. PageCount - 1 },
    Pages       = List.Transform(PageIndices, each GetPage(_)),
    Entities    = List.Union(Pages),
    Table       = Table.FromList(Entities, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    Table

could you please help in this, i'm not that expert in the M query. 

the target is to loop over all pages to get the data. 

Thank you so much. 

Anonymous 

v-chuncz-msft 

pdbenbow