Miten yhdistät Excelin TWICE Commerceen

let
    FromDate = "2025-01-01",
    ToDate = Date.ToText(Date.From(DateTime.LocalNow()), "yyyy-MM-dd"),
    Source = Web.Contents(
        "https://server.twicecommerce.com",
        [
            RelativePath = "internal/reporting/revenue/export",
            Query = [from = FromDate, to = ToDate, currency = "EUR"],
            Headers = [#"X-API-KEY" = TwiceApiKey]
        ]
    ),
    Csv = Csv.Document(Source, [Delimiter = ";", Encoding = 65001, QuoteStyle = QuoteStyle.Csv]),
    Promoted = Table.PromoteHeaders(Csv, [PromoteAllScalars = true]),
    // A truncated export ends in a notice row with no Row_ID. Drop it.
    DataRows = Table.SelectRows(Promoted, each [Row_ID] <> null and [Row_ID] <> ""),
    Typed = Table.TransformColumnTypes(
        DataRows,
        {
            {"Create_Date", type date}, {"Start_Date", type date}, {"End_Date", type date},
            {"Quantity", type number}, {"Amount_Excl_Tax", type number},
            {"Amount_Total", type number}, {"Amount_Paid", type number},
            {"Amount_Refunded", type number}, {"Amount_Outstanding", type number}
        },
        "en-US"
    )
in
    Typed