Time-our error 504 for inserting records to a monday board

monday Apps & Developers
,
1

Lately, I have a persistent problem caused when I try to upload data to a Monday Board via the GraphQL API.

I know a similar problem when reading a board’s content, and using the “limit” param to overcome it. However, it happens not for reading content, but writing to the board.

When I try to render a json response as I used to do for the past months, I receive an HTML snippet with the following strings:

"cf-error-details cf-error-504">
  <h1>Gateway time-out</h1>
  <p>The web server reported a gateway time-out error.</p>
  <ul>
    <li>Ray ID: XXX </li>
    <li>Your IP address: XXX </li>

I use the following query to upload data:

"mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:" + board_id + ", item_name:$myItemName, column_values:$columnVals, create_labels_if_missing: true) { id } }"

Update:
Likely I had to use group_id as well, as documented here:
https://api.developer.monday.com/docs/items-queries

2

Solved.
The way you retrieve the group_id is:


query {
  me {
    name
  }
  
  boards(ids:[XXXX]) {
    name
    
    groups {
    	title
      id
  
    }
  }
}

Solution:

query = "mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:" \
                    + board_id \
                    + ", group_id: "\
                    + group_id \
                    + ", item_name:$myItemName, column_values:$columnVals, create_labels_if_missing: true) { id } }"
3

Error still persists after that few records are successfully uploaded.

image
image1190×725 105 KB

4

Hello @orblatt-AF!

Matias here.

It looks like the issue might lie in the amount of data that is being retrieved. Just to be sure, would you please send this information to our email address so we can take a closer look?

Our email address is appsupport@monday.com

Cheers,
-Matias

5

Hello @Matias.Monday

Is there any update on this?
I am updating a lot of records and this problem happens multiple times a week now.
There is still no option to update multiple items at once and therefore I loop trough my array and update / insert about 200 to 400 items on a single Monday board. It would be nice if there would be a API error instead of a snippet of HTML.

Thanks for the reply

Cheers

  • Tieme
6

Hello @Tieme!

This does not seem to be a generalized issue but rather something particular with the other account, and now you experiencing something similar, but probably not related.

You can update many items at once by using a mutation like this one:

mutation {
  item1: create_item(item_name: "New item 1", board_id: 12345678) {
    id
    name
  }
  item2: create_item(item_name: "New item 2", board_id: 12345678) {
    id
    name
  }
}

About the error you are experiencing, I would love to know more about it. Could you send us an email to appsupport@monday.com so we can take a closer look?

Looking forward to hearing from you :slightly_smiling_face:

Cheers,
Matias

7

Could you provide an example of this with the use of parameters? I am getting an TimeoutError sending over 2,000 single mutation requests. See below.

image
image1315×106 6.36 KB

8

Hello @mariok and welcome to the community!

I hope you like it here :muscle:

If you are getting a timeout error, then your syntax is probably correct. You just need to use much less data in your request, to avoid that error. If our server can not perform the action you are asking in 60 seconds, it will time out. Using less data/less mutations will probably solve the issue.

Hope this helps!

Cheers,
Matias