Welcome!

remove column ids, row ids from Smartsheet json!

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

Find more posts tagged with

Sheets

API and Developers

Community Platform

IT & Operations

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Not able to access Developer Tools
We are trying to enable Oauth for Smartsheets to read data from our application. We are trying to create an application but unable to find Developer tools option Could you please guide us if there are any steps to follow to enable developer tools?
Is there a list of endpoints for which offset-based pagination is being deprecated?
Based on info available in the changelog (specifically https://developers.smartsheet.com/api/smartsheet/changelog#2025-08-04) ) for some endpoints offset-based pagination is being replaced with token-based pagination. Is there a list of endpoints that will be impacted by this change? I am trying to stay ahead of this and…
Controlling settings via API for Portrait/Landscape or Scaling/Fit To Page when creating PDF's
We are currently using the Smartsheet API to export and send a sheet as a PDF via email as part of an automated workflow. While generating the PDF, we are able to specify the paper size (for example, A4 or A3). However, we are facing limitations with the following formatting controls: Orientation We are unable to…