Добрый день.
Во вложении документация разработчика, не работает смещение и увеличить количество строк не получается.
Помогите, пожалуйста разобраться что я делаю не так. Токен выложить не могу, запрос в таком виде не работает.
Подозреваю что что-то не так в выделенной строчке.

let
   From = Excel.CurrentWorkbook(){[Name="Таблица2"]}[Content]{0}[с],
   To = Excel.CurrentWorkbook(){[Name="Таблица2"]}[Content]{0}[по],
   pathValue = Excel.CurrentWorkbook(){[Name="Таблица2"]}[Content]{0}[Бренд],
   url = "https://mpstats.io/api/wb/get/brand?d1="& From & "&d2=" & To &"&path="& pathValue,
   headers =
 [#"X-Mpstats-TOKEN" = ""],
   postData = Json.FromValue([startRow = "100", endRow = "1000"]),
   response = Web.Contents(
       url,
       [
           Headers = headers,
           Content = postData
       ]
   ),
   jsonResponse = Json.Document(response),
   #"Преобразовано в таблицу" = Record.ToTable(jsonResponse),
   #"Транспонированная таблица" = Table.Transpose(#"Преобразовано в таблицу"),
   #"Повышенные заголовки" = Table.PromoteHeaders(#"Транспонированная таблица", [PromoteAllScalars=true]),
   #"Другие удаленные столбцы" = Table.SelectColumns(#"Повышенные заголовки",{"data"}),
   #"Развернутый элемент data" = Table.ExpandListColumn(#"Другие удаленные столбцы", "data"),
   #"Развернутый элемент data1" = Table.ExpandRecordColumn(#"Развернутый элемент data", "data", {"id", "name", "brand", "seller", "supplier_id", "color", "balance", "balance_fbs", "comments", "rating", "final_price", "final_price_max", "final_price_min", "final_price_average", "final_price_median", "basic_sale", "basic_price", "promo_sale", "client_sale", "client_price", "start_price", "sales", "sales_per_day_average", "revenue", "revenue_potential", "revenue_average", "lost_profit", "lost_profit_percent", "days_in_stock", "days_with_sales", "average_if_in_stock", "is_fbs", "subject_id", "subject", "purchase", "purchase_after_return", "country", "gender", "sku_first_date", "firstcommentdate", "picscount", "has3d", "hasvideo", "commentsvaluation", "cardratingval", "categories_last_count", "category", "category_position", "product_visibility_graph", "category_graph", "graph", "stocks_graph", "price_graph", "thumb", "thumb_middle", "url"}, {"id", "name", "brand", "seller", "supplier_id", "color", "balance", "balance_fbs", "comments", "rating", "final_price", "final_price_max", "final_price_min", "final_price_average", "final_price_median", "basic_sale", "basic_price", "promo_sale", "client_sale", "client_price", "start_price", "sales", "sales_per_day_average", "revenue", "revenue_potential", "revenue_average", "lost_profit", "lost_profit_percent", "days_in_stock", "days_with_sales", "average_if_in_stock", "is_fbs", "subject_id", "subject", "purchase", "purchase_after_return", "country", "gender", "sku_first_date", "firstcommentdate", "picscount", "has3d", "hasvideo", "commentsvaluation", "cardratingval", "categories_last_count", "category", "category_position", "product_visibility_graph", "category_graph", "graph", "stocks_graph", "price_graph", "thumb", "thumb_middle", "url"})
in
   #"Развернутый элемент data1"