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.