remove column ids, row ids from Smartsheet json!

somer

hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks. 

Etienne Mermillod

Hi,

You can't do that in smartsheet, although using few regex you should be able to remove column ids, rows ids from the json content, such as :

• To find columnId text: \"columnId\":\s\d*,
• To find row ids: \"id\":\s\d*,