function import_inventory_test(e) {
var options = {
"method": "GET",
"headers": {
'Content-Type': 'application/json',
'Prefer': 'code=200',
'Prefer': 'dynamic=true',
"clientId": "1",
"key": "1",
}
}
var text = UrlFetchApp.fetch("https://stoplight.io/mocks/flowhub/public-developer-portal/24055485/v0/inventory?max=100", options).getContentText();
var json = JSON.parse(text);
// I added the below script.
var values = json.data.map(({ sku }) => [sku]);
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); // Please set your sheet name.
sheet.getRange(1, 1, values.length).setValues(values);
}
如何使用以下字段(按顺序)填充 a-d 列:sku (A) 数量 (B) 产品名称 (C) 品牌 (D)
在你的脚本中,当你的脚本被修改的时候,下面的修改怎么样?
From:
var values = json.data.map(({ sku }) => [sku]);
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); // Please set your sheet name.
sheet.getRange(1, 1, values.length).setValues(values);
To:
var values = json.data.map(({ sku, quantity, productName, brand }) => [sku, quantity, productName, brand]);
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); // Please set your sheet name.
sheet.getRange(1, 1, values.length, values[0].length).setValues(values);
Note:
- 如果您想添加和修改您需要的值,在这种情况下,请修改
json.data.map(({ sku, quantity, productName, brand }) => [sku, quantity, productName, brand])
.
参考:
- 解构赋值 https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Destructuring_assignment
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)