Is there a way to mass upload data to edit-only columns to Ontology/Workshop?
My current Workshop application has an action with 10+ edit-only parameters. It would be really nice if an Excel/Fusion sheet could be composed and uploaded for each unique ID, instead of updating them one by one. Is it possible to create this upload?
I thought about adding all the columns to the dataset and making them editable by actions, however, I am worried about overwrites and not quick enough refresh times.
Yes, this is possible (we currently use this method which is a function-backed action used as an inline edit in the Object Table widget within Workshop), but you should be aware of enforced limits.
If the atomic action type (e.g., EDIT this single object instance with ID abc123 on these 12 properties) is defined via the UI in the Ontology Manager, you should be able to edit up to 10,000 objects at a time if the input representing target object instances are converted/cast to a primitive list (this goes down to just 1k if you’re using the standard object reference list parameter which is more common). If the atomic action type is actually backed by either TypeScript or Python code (i.e., it’s a function-backed action), the maximum number of object instances that can be edited at a time goes down to 20. See this page in the docs for more details: https://www.palantir.com/docs/foundry/action-types/scale-property-limits#batch-call-limits
We explored the CSV upload method, but the parsing of values in each row added some additional latency + overhead that didn’t meet the relevant SLAs (+ it reduced the bulk object count limit to just 20). The workaround that was acceptable for our use case was to simply copy and paste the values in the cells from Excel to the inline edit form on Workshop that pops up when we invoke our bulk inline action, but of course this might not be acceptable in all use cases including yours so YMMV!
You can use an inline action table widget, which is detailed here: https://www.palantir.com/docs/foundry/workshop/widgets-inline-action-form/#action-table-action-grid.
With the action table, you can upload a CSV directly and then map columns of the CSV to corresponding parameters of the action type used for the action table.
