I have slate dashboard which uses fusion sheet for backend data and fusion service api/fusion queries to retrieve data from fusion sheets.
I want write data into fusion sheet with one of the column having array type of data.
Does anyone knows how to write back array data type into fusion sheet using fusion query?
What I tried
giving this payload to fusion query result in error Invalid argument
data = {
rows: [
"columnID" : {
"type": "untypedString",
"untypedString": ['a','b']
}
]}
giving this payload to fusion query it writes data as it is (I thought it will be interpreted as array in fusion sheet cell)
data = {
rows: [
"columnID" : {
"type": "untypedString",
"untypedString": "=array('a','b')"
}
]}
WHAT I WANT to write array data in fusion sheet
Could you try with this :
{
"rows": [
{
"columnID": {
"type": "cellValue",
"cellValue": {
"type": "stringArray",
"stringArray": [
"A", "B"
]
}
}
}
]
}
Instead of this :
{
"rows": [
{
"columnID": {
"type": "untypedString",
"untypedString": "test"
}
}
]
}
For reference, this is possible to find it in the dev docs, by looking at the specific query you are using and the objects it can take as arguments.