Загрузка из json

1. FilippovRI 71 09.12.18 14:39 Сейчас в теме
Имеется файл формата 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 в таблицу значений?
По теме из базы знаний
Ответы
Подписаться на ответы Инфостарт бот Сортировка: Древо развёрнутое
Свернуть все
3. insurgut 207 10.12.18 09:26 Сейчас в теме
JSON вроде как это Дерево значений, а не таблица значений.
Оставьте свое сообщение

Для получения уведомлений об ответах подключите телеграм бот:
Инфостарт бот