Option Explicit
Public Sub ExportWorksheetAndSaveAsCSV()
Dim wbkExport As Workbook
Dim shtToExport As Worksheet
Set shtToExport = ThisWorkbook.Worksheets("Итоговые цены")     'Sheet to export as CSV
Set wbkExport = Application.Workbooks.Add
shtToExport.Copy Before:=wbkExport.Worksheets(wbkExport.Worksheets.Count)
Application.DisplayAlerts = False                       'Possibly overwrite without asking
wbkExport.SaveAs Filename:="d:\Clouds\Yandex.Disk\Магазин\pricelists\import\Prices_for_marketplaces_new.csv", FileFormat:=xlCSV
Application.DisplayAlerts = True
wbkExport.Close SaveChanges:=False
End Sub

//////////////////////////////////////////////////////////////////////////////////////////

function getOrdersList() {
  const endpoint = "/v3/posting/fbs/list";
  const sheet_name = 'Заказы';

  let options = {
    method: "POST",
    headers:  {
        'Client-Id': CLIENT_ID,
        'Api-Key': API_KEY,
        'accept': 'application/json'    
    },
    payload:{
  "dir": "ASC",
  "filter": {
    "since": "2023-01-01T00:00:00.000Z",
    "to": "2023-12-01T23:59:59.000Z"
  },
  "limit": 1000,
  "offset": 0,
  "translit": true,
    "with": {
        "analytics_data": true,
        "financial_data": true
      }
    }
  };
  options.payload = JSON.stringify(options.payload);
  
  let response = UrlFetchApp.fetch(API_URL + endpoint, options);
  
  let rows = JSON.parse(response).result;

  
  if(rows){
  //SpreadsheetApp.getActive().toast("Данные получены успешно.");
  //SpreadsheetApp.getUi().alert(response);
  }
 
  const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = spreadsheet.getSheetByName(sheet_name);

  let range = sheet.getRange(1,1,10000,ORDERS_NUM_COLS);
  range.clearContent();
  
  sheet.activate();
  
  // Append the headers.
  const headers = ["Номер заказа", "Статус отправления", "Дата и время", "Артикул товара", 
                   "Название товара", "Количество", "Цена продажи"];
  //sheet.appendRow(headers);    
  sheet.getRange(1, 1, 1, headers.length).setValues([headers]);  
  
  

  // Append the results.
  var data = new Array(rows.length);
  
  for (let i = 0; i < rows.length; i++) {
    const cols = rows[i];
    const values = [cols.order_number, cols.status, 
    Utilities.formatDate(new Date(cols.in_process_at), timeZone, 'dd.MM.yyyy HH:mm'), 
    cols.products[0].offer_id + '', 
                    cols.products[0].name, cols.products[0].quantity,
                    cols.products[0].price | 0 ];
   data[i] = values;
     
  }
  
  sheet.getRange(2, 1, rows.length, headers.length).setValues(data);
}//function getOrdersList()
//////////////////////////////////////////////////////////////////////////////////////////