# הוסף bulk\_create ל-Gamification external event API

**URL:** https://meta.discourse.org/t/add-bulk-create-to-gamification-external-event-api/307800
**Category:** Feature
**Tags:** rest-api, gamification
**Created:** [13 במאי,‏ 2024,‏ 1:22pm UTC](https://meta.discourse.org/t/add-bulk-create-to-gamification-external-event-api/307800 "2024-05-13T13:22:45Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![colin.mckibben](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/colin.mckibben/32/307951_2.png) [@colin.mckibben](https://meta.discourse.org/u/colin.mckibben)
#### Post date: [13 במאי,‏ 2024,‏ 1:22pm UTC](https://meta.discourse.org/t/add-bulk-create-to-gamification-external-event-api/307800/1 "2024-05-13T13:22:45Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [13 במאי,‏ 2024,‏ 5:32pm UTC](https://meta.discourse.org/t/add-bulk-create-to-gamification-external-event-api/307800/2 "2024-05-13T17:32:02Z")

</div>

> [@colin.mckibben](#):
>
> Is the external gamification built into the SQL database?

Yes, it has a dedicated table for this.

> [@colin.mckibben](#):
>
> 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.

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?

---

<div class="post-metadata">

### Author: ![colin.mckibben](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/colin.mckibben/32/307951_2.png) [@colin.mckibben](https://meta.discourse.org/u/colin.mckibben)
#### Post date: [13 במאי,‏ 2024,‏ 5:35pm UTC](https://meta.discourse.org/t/add-bulk-create-to-gamification-external-event-api/307800/3 "2024-05-13T17:35:26Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![jordan-violet](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jordan-violet/32/281428_2.png) [@jordan-violet](https://meta.discourse.org/u/jordan-violet)
#### Post date: [13 במאי,‏ 2024,‏ 8:22pm UTC](https://meta.discourse.org/t/add-bulk-create-to-gamification-external-event-api/307800/7 "2024-05-13T20:22:13Z")

</div>

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? 😃
