Hi, a beginner here asking for API help. (ChatGPT has already brought me far but I’m still a bit stuck) I’m trying to update my Monday.com board according to changes in Google Sheets. My GoogleSheets is able to send out the following JSON string mutation request:
{ “query”: “mutation { change_column_value (board_id: 4353413926, item_id: 4353413947, column_id: "__", value: "{"text":"2521"}") { id } }” }
Which I think is correctly formulated for the Monday.com API to receive. Board ID, Column ID, and Item ID have all been checked to be correct. API token is, I think, also correct (At least I’m not getting an error from the Google Sheets side).
However, I’m not seeing the change requested by this string on Monday.com.
On the individual board items, I’m not seeing any API requests in their individual update. Likely the JSON never reached them.
How can I see if Monday.com overall has received this API request from outside, what was received, and how it was interpreted?
If someone can let me know how to debug or check this, or any potential reason why this is not working, please let me know!
Thank you!