Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to set up a rollup field using the API?

453 2
cancel
Showing results for 
Search instead for 
Did you mean: 
waldgeist
4 - Data Explorer
4 - Data Explorer

According to the API docs, it should be possible to set a rollup field using the REST API.

However, if I send this:

{
    "name": "Total Points",
    "description": "Automatically calculated total points for each user",
    "type": "rollup",
    "options": {
        "fieldId": "fld...", // Field ID of a "Points" field in a Points table
        "linkedTableId": "tbl...", // ID of the Points table
        "aggregation": "SUM"
    }
}

I am getting this error:

{
    "error": {
        "type": "UNSUPPORTED_FIELD_TYPE_FOR_CREATE",
        "message": "Invalid options for Leaderboard.Total Points: Creating rollup fields is not supported at this time"
    }
}

I asked ChatGPT and it tells me that rollup fields cannot be created using the API, despite the API docs claiming otherwise. Is this true, or am I doing something wrong here?

(Setting up the rollup field using the UI works just fine.)

2 Replies 2

The message is pretty explicit that rollup fields can't be created and so I'd defer to that.  If you're still unsure, perhaps you could open a support ticket to get confirmation? 

Alexey_Gusev
13 - Mars
13 - Mars

According to Web API,  field options are read-only, so you can't create such field

Alexey_Gusev_0-1731355013005.png