DataGrid Delete Rows

Simon_King

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

datagrid.removerow(1);

Datagrid.Rows.Remove(1); 

eg

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);
datagrid.magicParseJSON(jsonRes.data);

user05046

You should to do this using  the 'JSON connector with custom parsing:'

 

https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_File_Retrieval/JSON_Connector_with_Custom_Parsing