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

Example JSON:

{ 
"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.

Did this answer your question?