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

Bridge Workflow Export
I have just recently found use cases where I needed Bridge. I created a sheet with unpivotted data. I have a love/hate relationship with the tool for now. I really like flexibility and power, what I don't like is how difficult it is to troubleshoot and in some ways manage the workflows. Seems to be some sensitive points…
Unable to connect to Smart sheet API using the Python sdk
raise HttpError(rex, "SSL handshake error, old CA bundle or old OpenSSL?") from rex smartsheet.exceptions.HttpError: (SSLError(MaxRetryError("HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded with url: /2.0/sheets (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED]…
Getting Blank Rows While Inserting Data directly using Python
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…