Is the external gamification built into the SQL database? I have a need to assign external points to a large quantity of users and doing it through the API with its rate limiting will take too long and cause issues with other automations that rely on the API. I’d like to write a SQL query that inserts the external points in one go.
AI-generated summary
The discussion revolves around a feature request to add a bulk_create functionality to the Gamification external event API. colin.mckibben highlights the need to assign external points to a large number of users efficiently, as the current API rate limiting is too slow and disruptive. Falco confirms that the external gamification data is stored in a dedicated SQL table and suggests implementing a bulk_create method to allow sending up to a thousand scoring events per request. colin.mckibben agrees this would be ideal, noting it would reduce thousands of API calls to just a few. jordan-violet supports the request, stating it’s not urgent but should be considered as a feature request, and suggests tagging @JammyDodger for visibility.
Yes, it has a dedicated table for this.
Sounds like what we really have here is a Contribute > Feature request for a bulk_create where you can send, let’s say, up to a thousand of new scoring events per request. How that sounds like?
1 Like
Yes, that sounds acceptable, and I appreciate the help. We only have a few thousand users that actually have points where I would need to run this logic. That would only take a couple of API requests instead of a few thousand.
I’m not in a huge rush to implement this, but that being said, do you have a rough estimate on when a feature like this could be implemented so I can plan accordingly?
3 Likes
Echoing what Colin said, we’re not in a rush for this to be any prioritized custom development—we’ll reach out through the official channels if so!
For now, we’ll just leave it as a feature request. Unfortunately I can’t split Colin and I’s posts over there though. Does paging @JammyDodger work? 
2 Likes