Tool to explode JSON data in a column into separate columns. Extracts all keys from JSON objects and creates a new column for each key. Use when you need to flatten nested JSON data in a Gigasheet dataset.
keysarrayOptional list of JSON keys to extract from the column. If not provided, the API will automatically extract the most common keys (up to 2000). Use this to specify exactly which keys to explode into separate columns.
columnRequiredstringColumn ID or name of the column containing JSON data to explode. This is the column whose JSON values will be extracted into separate columns.
handleRequiredstringUnique identifier (handle) of the dataset/sheet containing the JSON column. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'cfd53422_4516_42e9_bb92_91cec8af8ff8').
indicesarrayOptional list of row indices to process. If not provided, all rows will be processed.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.