DataGrid Delete Rows

I have some JSON data I am pulling into Domo via a connector however when I Parse the data I end up with a table which has rows with varying numbers of coloumns and therefore wont save into a dataset.


One option I am looking at is to just delete the rows I dont need and end up with one relevant row of the data Im after, but how do I delete Rows.  I have tried different varients of




but nothing seems to work, or is there a was to delete the data before Parsing it (which I have to do twice as everything is a suset of 'data')


var jsonRes = JSON.parse(res);