remove column ids, row ids from Smartsheet json!

somer
somer
edited 12/09/19 in API & Developers

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. 

Screen Shot 2019-11-25 at 2.38.47 PM.png

Comments

  • Etienne Mermillod
    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*,