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.
Comments
-
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*,