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

How to access the new end points via SDK
We were using python SDK to access smartsheet API's. Have seen most of the end points getting deprecated and provided new end points. Its providing the request with all params using direct API request in documentation. However no reference provided for using python SDK/other SDK's to access the API. Is Smarthsheet API…
what is the cause of "Unexpected character encountered while parsing value: <. Path '', line 0, pos"
what is the cause of "Unexpected character encountered while parsing value: <. Path '', line 0, position 0." error when using the C# SDK. the full log message is: - 2025-09-18 09:58:54 *** Exception in 'ProcessShares(Entity, EntityName, EntityId, Counter, ssWorkspace)' 2025-09-18 09:58:54 1 'ShareResources.ListShares()'…
Potential recently introduced bug on Create Webhook call? (POST /webhooks)
Our Smartsheet integration has occasional need to create a webhook before it knows the ultimate URL for the callback. For several years, we have done this by supplying a dummy URL to the CreateWebhook (POST /webhooks) API and then before we verify that webhook, we update the URL with the POST /webhooks API and set it to…