Skip to main content
1-Visitor
September 6, 2021
Question

Edit JSON

  • September 6, 2021
  • 2 replies
  • 734 views

I have a JSON from Infotable, but I have a lot of information i don't need. I just want "rows". I do not want "datashape". What is the code to take only "rows" or delete the "datashape"?

 

json=

{
"rows":[
      {"Desc":"b",
       "Class":"d",      
     }],


"dataShape":{
      "fieldDefinitions":{
                       "Desc":{
                              "name":"Desc",
                             "aspects":{"isPrimaryKey":false},
                            "description":"",
                            "baseType":"STRING",
                            "ordinal":2},
                       "Class":{
                             "name":"Class",
                             "aspects":{"isPrimaryKey":false},
                            "description":"",
                            "baseType":"STRING",
                            "ordinal":3},

                        }}
}

2 replies

AitorP1-VisitorAuthor
1-Visitor
September 6, 2021

delete jsonData['dataShape'];

Community Manager
September 14, 2021

Hi @AitorP.

 

We're not understanding your use case.  It should be possible to access the row element and ignore anything else.  If you can explain further, we will try to assist.

 

Regards.

 

--Sharon