Change_column_value not working for a "link" column in Python

monday Apps & Developers
, , ,
1

Hello,

I am using Python to query monday API.
I have been spending many hours trying to use “change_column_value” on a link column, in vain.
I saw I wasn’t the only one to have this issue but I still couldn’t solve it.

This is my code:

def update_field(item_id: int, column_id: str, value):
    value_str = json.dumps(value).replace('"', '\\"')
    print(value_str)
    query = f'''
    mutation {{
        change_simple_column_value(
            board_id: {BOARD_ID},
            item_id: {item_id},
            column_id: "{column_id}",
            value: "{value_str}"
        ) {{
            id
        }}
    }}
    '''
    response = requests.post(url=MONDAY_URL, json={'query': query}, headers=monday_headers)

    return response.json()

some_url = 'https://www.google.com'
some_text = 'Google'
print(update_field(item_id=item_id, column_id='link', value={'url': some_url, 'text': some_text}).json())

This code returns:

{\"url\": \"https://www.google.com", \"text\": \"Google\"}
{'data': {'change_simple_column_value': {'id': '0000000000'}}, 'account_id': 00000000}

(I replaced the numbers by 0 for safety matters)

When I print json.dumps(value_str) I get {"url": "https://www.google.com", "text": "Google"}.

Returning back on my Monday board, I can see that the changes have been done, but not accurately. Here is what I get when I get the item:

{'id': 'link', 'title': 'Link column', 'value': '{"url":"https://%7B%22url%22:","text":"\\"https://www.google.com\\", \\"text\\": \\"Google\\"}","changed_at":"2023-05-12T10:14:02.242Z"}'}

I would be grateful if you could help me through this issue.

twan

2

hi @twan

So, from your example it shows that the value

'value': '{"url":"https://%7B%22url%22:","text":"\\"https://www.google.com\\", \\"text\\": \\"Google\\"}","changed_at":"2023-05-12T10:14:02.242Z"}'

you are sending to the column is picked up by monday and URL-encoded, hence is starts with %7B%22 (which unencoded is {"). I’m not a Python expert but it looks like json.dumps URL-encodes automatically and when printing it out it decodes it again.

3

Hi Bas de Bruin,

Thank you for your help.
I am not sure what changes to make your message suggest.
I wrote the value of value_str in a .txt file to see if I get the same output as when printing: yes.

I don’t see what’s wrong in the format of value_str since when I’m looking at it, it’s a string representing a json with 2 keys: “url” and “text”, as in the column.

4

Hello there @twan,

You can use something like this:

mutation {
  change_multiple_column_values(
    board_id: 1234567890
    item_id: 1122334455
    column_values: "{\"link\" : {\"url\" : \"http://monday.com\", \"text\":\"go to monday!\"}}"
  ) {
    id
  }
}

Which I translated to Python using Postman into:

import http.client
import json

conn = http.client.HTTPSConnection("api.monday.com")
payload = "{\"query\":\"mutation {\\n  change_multiple_column_values(\\n    board_id: 1234567890\\n    item_id: 1122334455\\n    column_values: \\\"{\\\\\\\"link\\\\\\\" : {\\\\\\\"url\\\\\\\" : \\\\\\\"http://monday.com\\\\\\\", \\\\\\\"text\\\\\\\":\\\\\\\"go to monday!\\\\\\\"}}\\\"\\n  ) {\\n    id\\n  }\\n}\",\"variables\":{}}"
headers = {
  'Content-Type': 'application/json',
  'Authorization': 'MYAPIKEY',
}
conn.request("POST", "/v2/", payload, headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))

I hope that helps!

Cheers,
Matias