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

Which .NET Version and Smartsheet SDK Should I Upgrade To for 2026 Endpoint Deprecations?
Hi Everyone, I have a Console Application that was developed using .NET Core 3.1 and Smartsheet SDK version 2.126.0. The application currently uses the following endpoints, which are scheduled to be deprecated in early 2026: GET /workspaces/{workspaceId}/folders GET /workspaces GET /workspaces/{workspaceId} GET…
Reasons for error code 1008 in webhook subscription request
Hi, Zapier Integrations team here. We are experiencing users reporting being unable to set up a webhook subscription to Smartsheet when a POST request is made to https://api.smartsheet.com/2.0/webhooks Response received { "errorCode": 1008, "message": "Unable to parse request. The following error occurred: Field 'name'…
API for RM and smartsheet project plan linking
Are they any APIs that can be used to link an RM project to an existing smartsheet project plan? Also, is there an API that can be used to navigate between a smartsheet project plan and an RM project?