Loop several days ( 10 days) in API

Hi HaiVN 

Use the below M Code:

let
    // Define your start and end dates
    StartDate = #date(2023, 1, 1),
    EndDate = #date(2023, 1, 10),

    // Generate a list of dates
    DateList = List.Dates(StartDate, Duration.Days(EndDate - StartDate) + 1, #duration(1, 0, 0, 0)),

    // Define a function to get data for each date
    GetDataForDate = (CurrentDate as date) =>
        let
            StartDateTime = DateTime.ToText(DateTime.From(CurrentDate) & #time(3, 0, 0), "yyyy-MM-ddThh:mm:ssZ"),
            EndDateTime = DateTime.ToText(DateTime.From(CurrentDate + #duration(1, 0, 0, 0)) & #time(3, 0, 0), "yyyy-MM-ddThh:mm:ssZ"),
            // Construct the API URL
            URL = "https://...startDate=" & StartDateTime & "&endDate=" & EndDateTime & "&dataset=CONSUMPTION_PER_GROUP_MUNICIPALITY_HOUR",
            // Fetch the data from the API
            Source = Json.Document(Web.Contents(URL))
        in
            Source,

    // Apply the function to each date and combine results into a table
    Data = List.Transform(DateList, each GetDataForDate(_)),
    CombinedData = Table.Combine(Data)
in
    CombinedData