Help Desk

Submit a ticket My Tickets
Welcome
Login

My JSON to Tabular indicates “conversion successful”, but I do not get any data.

Description: 
JSON to Tabular indicates "conversion successful", but no data is being rendered. 

Error Messages & Codes:
NA

Issue Summary:
The OneCloud JSON BizApp can only operate with JSON arrays. For example, the following JSON will not return any details about the balls or bicycles:

{
  "store": {
    "bicycle": {
      "color": "red",
      "price": 19.95
    },
    "ball": {
      "color": "blue",
      "price": 21.95
    }
  }
}


Issue Solution:
The following JSON will return details about balls and bicycles since the details are a part of an array wrapped in square brackets.

{
  "store": {
    "bicycle": [{
      "color": "red",
      "price": 19.95
    }],
    "ball": [{
      "color": "blue",
      "price": 21.95
    }]
  }
}

Use this site to test JSON paths.

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

Login to post a comment