I have a prompt that takes a user's request and an existing JSON table with row and column IDs.
The prompt is designed to have a structured JSON output and after testing, it gets 95% there, The output I get as the structured JSON output that is 95% correct is as follows:
{
"operation": "add",
"cells": [
{
"columnId": 5365531952238468,
"value": "Await for feedback"
},
{
"columnId": 1987832231710596,
"value": "2025-10-17"
},
{
"columnId": 7775829480918916,
"value": "2025-10-25"
},
{
"columnId": 7617331765923716,
"objectValue": {
"objectType": "MULTI_PICKLIST",
"values": [
{
"item": "team 1"
},
{
"item": "team 2"
}
]
}
},
{
"columnId": 2146329946705796,
"value": "50%"
},
{
"columnId": 105636365553540,
"value": "Consulting needs to assess output"
}
],
"location": "toBottom"
}
Where it is 5% wrong is the "values": [ { "item": "team 1"},{"item","team 2"}]
What i have in the prompt is that it should be "values": ["team 1", "team 2"], a list of strings essentially.
I tried customizing the structured JSON output as follows in the screenshot and get the following error below:
I want the cells to output a JSON output essentially and in that format above (in the screenshot). Is this just an invalid JSON format? If it is, what's the way around it to get a specific output?
Essentially my HTTP REQUEST using an API accepts the value in cells in that format and in that format only.
