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 :
Hello :) I am building a project management system where we have: Asset (Parent Object) Components needing fixing/replacement (Child Objects). In my Bridge workflow I have managed to achieve child row creation based on the number of values in the dropdown cell (components). I need to add a feature that spreads each…
Hello, I found that sheet modifiedAt field in "List Sheets" GET method sometimes is different than modifiedAt field from "Get Sheet". Is this normal ? When I change a value in a cell, Get Sheet method returns the last modifiedAt date but List Sheets remain with the old value.
Hello! Is there an existing way to pipe data directly into Databricks from Smartsheet workspaces? We understand the capabilities of the API and python SDK, but are curious about other out of the box offerings with enterprise systems.