nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

remove column ids, row ids from Smartsheet json!

somer

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

500 Internal Server Error when accessing WorkApps
Hello- my co-worker is getting the Opps something went wrong error. Also know as a 500 internal server error when accessing workapps. Can you please help?
Reports API: Full CRUD Support Now Available
You can now create, read, update, and delete reports programmatically via the Smartsheet API. Reports are no longer UI-only — they're a first-class API resource, just like sheets. What's new The Reports API now supports the full object lifecycle: Create reports from API calls — no more manual setup in the UI Read report…
New Learning Series: "Mastering Smartsheet API" — Part 1 is live
Hey dev friends, We just kicked off a new hands-on learning series for the Smartsheet API Developer Ecosystem: Mastering Smartsheet API. From your first API call to production integrations and the new MCP Server for AI agents — this series covers the full path. Part 1, "Zero to API: Your First Successful Smartsheet…