let
url = "https://card.wb.ru/cards/detail",
headers = [
#"Accept" = "*/*",
#"Accept-Language" = "en-US,en;q=0.9",
#"Connection" = "keep-alive",
#"Origin" = "https://www.wildberries.ru",
#"Referer" = "https://www.wildberries.ru/catalog/37862210/detail.aspx?targetUrl=GP",
#"Sec-Fetch-Dest" = "empty",
#"Sec-Fetch-Mode" = "cors",
#"Sec-Fetch-Site" = "cross-site",
#"User-Agent" = "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36",
#"sec-ch-ua" = "^\^Google",
#"sec-ch-ua-mobile" = "?0",
#"sec-ch-ua-platform" = "^\^Windows^^"
],
parameters = [
#"spp" = "26",
#"regions" = "80,64,83,4,38,33,70,82,69,68,86,30,40,48,1,22,66,31",
#"pricemarginCoeff" = "1.0",
#"reg" = "1",
#"appType" = "1",
#"emp" = "0",
#"locale" = "ru",
#"lang" = "ru",
#"curr" = "rub",
#"couponsGeo" = "2,12,7,3,6,18,21",
#"sppFixGeo" = "4",
#"dest" = "-1029256,-85617,-543140,-1586279",
#"nm" = "37862210"
],
response = Web.Contents(url, [
Query = parameters,
Headers = headers
]),
json = Json.Document( response ),
totable = Table.PromoteHeaders(Table.Transpose(Record.ToTable(json[data][products]{0})))
in
totable |