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

Create a row and get the URL in the response.
Hi At https://developers.smartsheet.com/api/smartsheet/openapi/rows/rows-addtosheet the documentation says that a 'permaLink' attribute can be returned, "if the include query string parameter contains rowPermalink". So I've set my POST request to: /sheets/#{sheet_id}/rows?include=rowPermalink and sadly had no luck. I have…
Is new python sdk available for new end points
Is new python sdk available for new end points. Is Sunset date moved to Jun-2026
Creating Gantt via API / SDK ?
We're looking to create a Gantt chart by inserting the data and creating the chart via the API (actually via the Java SDK, but either will do). Inserting the data is fine, but cannot seem to get the setDependenciesEnabled (which believe need for the Gantt ) or setGanttEnabled() to work… We think part of this is the order…