Help Desk

Submit a ticket My Tickets
Welcome
Login

Getting the error “Error finding the root array element, please check your path: path not found”.

Issue Summary:
The JsonPath is not set correctly to isolate the element. JSON to Tabular indicates "Error finding the root array element, please check your path: path not found". 

Error Messages & Codes:
"Error finding the root array element, please check your path: path not found".

Issue Solution:
Look at the JSON and to find the path of the root array element you want to isolate. For example, if you are trying to capture:

usageUnit

The JsonPath would need to be set to:

pricingInfo[0].pricingExpression.usageUnit


{
  "skus": [{
    "skuId": "0033-4F4C-36F1",
    "description": "Long Term Storage (us-east4)",
    "category": {
      "serviceDisplayName": "BigQuery",
      "usageType": "OnDemand"
    },
    "serviceRegions": [
      "us-east4"
    ],
    "pricingInfo": [{
      "summary": "",
      "pricingExpression": {
        "usageUnit": "GiBy.mo",
        "displayQuantity": 1,
        "tieredRates": [{
          "startUsageAmount": 0,
          "unitPrice": {
            "currencyCode": "USD",
            "units": "0"
          }
        }]
      },
      "currencyConversionRate": 1,
      "effectiveTime": "2019-08-18T02:30:55.193Z"
    }],
    "serviceProviderName": "Google"
  }]
}


Use this site to test JSON paths.

If you still require assistance, please contact support@onecloud.io.

Login to post a comment