palantir-foundryfoundry-slatepalantir-foundry-apifoundry-fusion-sheet

Foundry Slate - append new row using fusion query


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


Solution

  • 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.