Sign in to join the conversation:
How to un-hide all columns in a smartsheet using smartsheet C# SDK?
The hide attribute on the column object can be read to see the current status of a column and if it is hidden or not, but it currently it isn't writable to allow changing its state. Using the Smartsheet API you can see the current status of columns and if they are hidden or not, but you aren't able to adjust the value to hide or unhide columns. That would need to be done manually in Smartsheet in your browser.
You might check out the Smartsheet API documentation. There are examples for updating columns.
https://smartsheet-platform.github.io/api-docs/?csharp#update-column
Just update the column attribute 'hidden' to False. I'm not into c#. But see the screenshot for Python. The documentation has a similar example for c#.
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…
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]…
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…