Имеется файл формата json
Имеется файл json
Подскажите как правильно записать json в таблицу значений?
Чтение = Новый ЧтениеJSON;
Чтение.ОткрытьФайл("C:\1c\token.json");
Пока Чтение.Прочитать() Цикл
Имеется файл json
{"itemserviceresult": {
"serviceMetaData": [
{
"version": "3.0.2"
}
],
"transactionArea": [
{
"response": {
"returnCode": "0",
"returnMsg": "",
"success": true
},
"responseSequence": {
"transactionTime": "65.333 ms",
"queryTime": "0 ms",
"dbTime": "0 ms",
"totalItems": 69,
"resources": [],
"qq": 150
}
}
],
"data": [
{
"resources": [
{
"type": "search",
"uri": "https://www.arrow.com/en/products/search?q=bav99"
}
],
"PartList": [
{
"itemId": 34718706,
"partNum": "BAV99",
"manufacturer": {
"mfrCd": "RECTRON",
"mfrName": "Rectron"
},
"desc": "BAV99",
"packageType": "",
"resources": [
{
"type": "cloud_part_detail",
"uri": "http://www.arrow.com/en/products/bav99/rectron"
},
{
"type": "api_part_detail",
"uri": "http://api.arrow.com/itemservice/v2/en/detail?mfrCd=RECTRON&partNum=BAV99"
},
{
"type": "part_detail",
"uri": "http://api.arrow.com/itemservice/v2/en/detail?pkey=ONDR-dhZVz54VOs9nh821fDCQXJd4nS6qfZFYx3BwDU"
}
],
"EnvData": {
"compliance": [
{
"displayLabel": "eurohs",
"displayValue": "n/a"
},
{
"displayLabel": "cnrohs",
"displayValue": "n/a"
}
]
},
"InvOrg": {
"sources": [
{
"currency": "USD",
"sourceCd": "ACNA",
"displayName": "Arrow Americas",
"sourceParts": [
{
"packSize": 1,
"minimumOrderQuantity": 1,
"sourcePartNumber": "",
"sourcePartId": "V99:2348_18303851",
"Prices": {
"resaleList": [
{
"displayPrice": "0.2069",
"price": 0.2069,
"minQty": 1,
"maxQty": 999999999
}
]
},
"Availability": [
{
"fohQty": 47,
"availabilityCd": "INSTK",
"availabilityMessage": "In Stock",
"pipeline": [
{
"delivery": "10-DEC-2018",
"quantity": 9047
}
]
}
],
"customerSpecificPricing": [],
"customerSpecificInventory": [],
"dateCode": "1805",
"resources": [
{
"type": "detail",
"uri": "https://www.arrow.com/en/products/bav99/rectron"
},
{
"type": "add_to_cart",
"uri": "https://www.arrow.com/en/products/bav99/rectron"
}
],
"inStock": true,
"mfrLeadTime": 0,
"isNcnr": false,
"isNpi": false,
"isASA": false,
"requestQuantity": 0,
"productCode": "",
"iccLevels": [],
"cloudMfrCode": "",
"eccnCode": "EAR99",
"htsCode": "",
"containerType": ""
},
{
"packSize": 3000,
"minimumOrderQuantity": 3000,
"sourcePartNumber": "",
"sourcePartId": "V36:1790_18303851",
"Prices": {
"resaleList": [
{
"displayPrice": "0.0588",
"price": 0.0588,
"minQty": 3000,
"maxQty": 29999
},
{
"displayPrice": "0.0550",
"price": 0.0550,
"minQty": 30000,
"maxQty": 299999
},
{
"displayPrice": "0.0334",
"price": 0.0334,
"minQty": 300000,
"maxQty": 1499999
},
{
"displayPrice": "0.0235",
"price": 0.0235,
"minQty": 1500000,
"maxQty": 999999999
}
]
},
"Availability": [
{
"fohQty": 0,
"availabilityCd": "NOSTK",
"availabilityMessage": "No Stock",
"pipeline": [
{
"delivery": "06-JUN-2019",
"quantity": 9000
}
]
}
],
"customerSpecificPricing": [],
"customerSpecificInventory": [],
"dateCode": "",
"resources": [
{
"type": "detail",
"uri": "https://www.arrow.com/en/products/bav99/rectron"
},
{
"type": "add_to_cart",
"uri": "https://www.arrow.com/en/products/bav99/rectron"
}
],
"inStock": false,
"mfrLeadTime": 0,
"isNcnr": false,
"isNpi": false,
"isASA": false,
"requestQuantity": 0,
"productCode": "",
"iccLevels": [],
"cloudMfrCode": "",
"eccnCode": "EAR99",
"htsCode": "",
"containerType": ""
},
ПоказатьПодскажите как правильно записать json в таблицу значений?
По теме из базы знаний
Ответы
Подписаться на ответы
Инфостарт бот
Сортировка:
Древо развёрнутое
Свернуть все
Для получения уведомлений об ответах подключите телеграм бот:
Инфостарт бот