remove column ids, row ids from Smartsheet json!

edited 12/09/19 in API & Developers
11/25/19 Edited 12/09/19

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

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

     

     

Sign In or Register to comment.