Bulk update of Items through API?

monday Apps & Developers Feature Requests - API and Apps Framework
,
21

Hello @rramess!

I have added your vote to it :slightly_smiling_face:

Cheers,
Matias

23

Hi Henry,

We currently do not support bulk updates, but you can achieve a similar result by making your updates in batches.

24

Is there any update on this?

I have more than 3000 items on a board and I want to update all of them using API. currently I can update only around 130 to 150 items at once due to API query credits limitations (one mutation query costs 30k credits and we have 5000k credits available for 1 minute. Although if update 150 items at once, I need to wait for 1 minutes to avoid “credits exhausted” error)
can somebody suggest me a good workaround solution?

25

Hi there,

Thanks for following up!

We have no updates to these limits-- we’ll be sure announce any changes planned for this space in our Changelog:

https://developer.monday.com/api-reference/changelog

26

Using API version 2023-10, I’m actually able to update the column values on multiple items at once like this. Not 1 column value for all items, but at least you can compose a query that can send all changes in a single call.

mutation {
  update1:change_multiple_column_values(
    item_id: 987654321
    board_id: 123456789
    column_values: "{\"numbers4\": \"10\" }"
  ) {
    id
  },
  update2:change_multiple_column_values(
    item_id: 987654322
    board_id: 123456789
    column_values: "{\"numbers4\": \"12\" }"
  ) {
    id
  }
}
27

Hello there @mieldr,

You can do that both in the stable version and in the preview version of the API :grin:

Cheers,
Matias

28

Hi @Matias.Monday , how many such change_multiple_column_value calls would you recommend per mutation?

29

Hello there @rramess ,

Personally, I usually use one mutation per HTTP request.

But, there is really no formal “best practices” on the number of mutations to use in an HTTP request.

Just take into account the rate limits and our timeouts policy!

Cheers,
Matias

30

There is another “rate limit” that isn’t mentioned in the documentation, and that is the connections per minute per IP address (5000 was the last I heard).

While much harder to hit, its not impossible for an app developer’s backend serving many customers with multiple apps.

31

Thank you @anon29275264 !

Will share this with the team!

32

Hi @anon29275264,

Thanks for bringing this up! I added it to the docs here :smiley:

Best,
Rachel

33

Upvote. Any good news forthis feature request?

34

Hello there @apsimos,

There are no updates for this at the moment.

35

Thanks @Matias.Monday