XPath Returning Error on JSON Data

XPath Returning Error on JSON Data

I am trying to import some JSON data via the XML Path Builder. The content looks like the below, and I am trying to get an XPath to the "spend" level

  
  1. {
  2. "data": [
  3. {
  4. "lifetime_budget": "9837",
  5. "insights": {
  6. "data": [
  7. {
  8. "spend": 2.97,
  9. "date_start": "2015-12-07",
  10. "date_stop": "2015-12-07"
  11. }
  12. ],
  13. "paging": {
  14. "cursors": {
  15. "before": "MAZDZD",
  16. "after": "MAZDZD"
  17. }
  18. }
  19. },
  20. "id": "6034498439074"
  21. },


However, the XPath builder returns this error: ERROR: The Number of Nested Child Nodes is Exceeding the limit...