Issue with datagrid.magicParseJSON() for custom connector

I am currently not able to export data from a custom connector when using datagrid.magicParseJSON(my_data). I always end up getting redirected to an error page: 

https://api.domo.com/Error%20adding%20data%20to%20stream%20664.%20ApiData%20response%20400

It appears to be related to the fact that I have multiple nested arrays in my JSON string but I don't know how to get it to export correctly. 

Comments

  • Hi there,

     

    Can you please post a screenshot of your code so we can diagnose the issue.

     

    Another way of parsing JSON data is by using the JSON.parse() method. Examples below:

     

    var parsedData = JSON.parse(my_data);

     

    DOMO.log(parsedData.id)

    DOMO.log(parsedData.person.age)

    DOMO.log(parsedData.person["first-name"])

     

    for(var i = 0; i < parsedData.length; i++) {

      DOMO.log(parsedData[i].id);

    }

     

    Cheers

    Eric