Update columns values in Python

[Sima (Sima Gabbay)]

Hi,

How should I update columns values in Python.
I tried different ways and got Error 500.
This is one of formats I tried (where description is of Long Text type column):
query_update = ‘mutation { change_column_value (board_id:, item_id:, column_id:“description”, value:“test update”) { id } }’

Thanks,
Sima

[AlexSavchuk]

Hey @Sima

As we’d discussed, the issue here was related to specififying "text’ as description was a Long Text column That said, I did want to share a few more Python-based examples with you, as promised on the call:

https://community.monday.com/t/python-code-example-importing-existing-zendesk-tickets-using-the-api/3092/3

"No Query String Present" for Python-based queries

I can successfully place a very simple query in the interactive client, as well as using cURL: query{account{id, name}} But when I place the same query using Python, I get the following response: '{"errors":[{"message":"No query string was present"}],"account_id":XXXXXXX}' The API authentication works, because I am getting my account id back with the response. But every method I use returns “No query string was present”. Any ideas? My relevant code snippet: headers = {"Authorization" : cre…

Change multiple column values in Python

I think this is the same problem I had when using json.dumps in python, it’s not escaping the quotes as required by graphql, I managed to fix it by using a nested json.dumps like so : >>> import json >>> status = 'Hello' >>> json.dumps({'label':status}) '{"label": "Hello"}' >>> json.dumps(json.dumps({'label':status})) '"{\\"label\\": \\"Hello\\"}"' >>> That way, I could have my the following function work : def update_status(board, event_id, status_id, status): status = json.dumps(json.du…

Let me know if those help!

-Alex

[Sima (Sima Gabbay)]

Thanks Alex, I’ll check it