Sign in to join the conversation:
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.
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 :
We are trying to update all users’ timesheets programmatically, which will involve tens of thousands of records in total. According to the Resource Management API documentation, time entries can only be updated one at a time. Is there a way to batch update multiple records at once? If I’m not mistaken, the API rate limit…
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]…
