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

upstream connect error
Hi, has anyone received this or similar error yesterday? upstream connect error or disconnect/reset before headers. reset reason: connection termination I got it once but haven't since, I suppose this is something coming from the smartsheet's api's end?
Action Required: Migrate from includeAll by June 3rd
Hi dev friends, Heads up — the includeAll query parameter is being sunset on June 3rd for list operations on workspaces, folders, shares, and more. This affects both direct API calls and all Smartsheet SDKs (Python, Java, C#, Node.js, Ruby). Check the Changelog for the full list of affected endpoints and migration guides —…
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?