Problem with Phone number column

monday Apps & Developers
, ,
6

Hi All,

I concur.

My Java based middleware (using the monday.com API) is now failing when assigning phone columns, using established code.

I have simplified the issue using monday.com.

mutation {
create_item(board_id: board_no_here, item_name: “TEST”,
column_values: “{"site_telephone0":"08719762819 GB"}”) {
id
}
}

yields:

{
“error_code”: “ColumnValueException”,
“status_code”: 200,
“error_message”: “invalid value, please check our API documentation for the correct data structure for this column. https://api.developer.monday.com/docs/change-column-values”,
“error_data”: {
“column_value”: “{"phone"=>"+08719762819", "countryShortName"=>"GB"}”,
“column_type”: “PhoneColumn”
}
}

Sending the same in JSON form:

mutation {
create_item(board_id: board_no_here, item_name: “TEST #2”,
column_values: “{"phone" : {"site_telephone0" : "08719762819", "countryShortName" : "GB"}}”) {
id
}
}

Returns:

{
“data”: {
“create_item”: {
“id”: “xxxxxxx”
}
},
“account_id”: xxxxxxx
}

But this does NOT physically assign to column. The column remains set to 1 (123) 123 4567.

Please note that my middleware uses simple text assignment.

7

Hello @Steve_Merchant!

It looks like your syntax might be incorrect.

You are using:

mutation {
create_item(board_id: ***board_no_here*** , item_name: “TEST #2”,
column_values: “{"phone" : {"site_telephone0" : "08719762819", "countryShortName" : "GB"}}”) {
id
}
}

The correct syntax would be:

mutation {
  create_item(board_id: 1234567890, item_name: "Your name", column_values: "{\"phone\" : {\"phone\" : \"08719762819\", \"countryShortName\" : \"GB\"}}") {
    id
  }
}

I just tested it and it worked well.

The first time you see “phone”, should be your phone column’s ID (not the name of the column, the ID). The second “phone” should just be “phone” and not “site_telephone0”.

@bartwwww that is weird. It looks good but we might be missing something. Can you please try in the Playground a mutation including only the phone column (like the one I show here) and let me know what happens? Please send a screenshot of the mutation and response in the Playground.

Cheers,
Matias

8

Hi @Matias.Monday I am facing the same issue, I have used exactly what you have shared but I am still facing the same issue

mutation {
  create_item(board_id: 3418370963, item_name: "test_phone_number", column_values: "{\"phone\" : {\"phone\" : \"08719762819\", \"countryShortName\" : \"GB\"}}") {
    id
  }
}

{
  "error_code": "ColumnValueException",
  "status_code": 200,
  "error_message": "invalid value, please check our API documentation for the correct data structure for this column. https://api.developer.monday.com/docs/change-column-values",
  "error_data": {
    "column_value": "{\"phone\"=>\"+08719762819\", \"countryShortName\"=>\"GB\"}",
    "column_type": "PhoneColumn"
  }
}
9

Hello @Matias.Monday,
Thanks very much for the info.

Using the Playground, your suggested command responds with a “success”, but it does not seem to assign the telephone number value to the board “phone” column (even after a F5 refresh).

I only included the JSON method example as a point of comparison really.

My Java middleware generates a text based Phone column assignment, thus:

shot1
shot11365×210 14.1 KB

the response is

image
image1825×287 27.3 KB

So, for text based assignments, is this GraphQL command, correct?

Thanks.

10

Hi,

We’re also seeing issues with writing to phone columns. This appears to be a regression in the Monday API.

We have not made any changes to our Monday.com integration, but today we started to see errors like the following:

"invalid value, please check our API documentation for the correct data structure for this column. https://api.developer.monday.com/docs/change-column-values","error_data":{"column_value":"{\"phone\"=\u003e\"+1234567897\", \"countryShortName\"=\u003e\"US\"}","column_type":"PhoneColumn"}}

We also have automated integration tests against your API which were previously passing and are also now failing with similar errors. Again, no code on our end has changed recently.

11

I made a support ticket yesterday.

It looks like https://api.developer.monday.com/ is down.

My guess is the API is down and the “Phone number error message” is a miss-directing error message.

Monday developers, have you started looking in to this?

12

Hello @Matias.Monday,

Thanks for your help so far.

I have tried your suggested GraphQL syntax using the ‘Playground’.

For the exercise I have used a valid UK telephone number (the speaking clock number) for test data.

Also, I demonstrate the syntax that until Friday 28th Oct has been working fine.

To confirm, here is the column in the target board that I would like to assign:

image

Attempt #1

Using JSON method.

image
image1810×260 20.3 KB

Attempt #2

Using Simple Text method.

Please note that up to Friday 28th October this method had been working well for literally months.

image
image1809×295 29.7 KB

As you can see the result in both cases for me is identical.

Due to work pressures, I am tempted to convert my ‘Phone’ columns to ‘Text’ for the time being.

Regards,
@Steve_Merchant

13

Putting phone first in the stringified JSON had no effect sadly

14

Hi everyone, I’m also running into this error (glad it’s not just me!)
This is the error I’m getting.

string(360) "{"error_code":"ColumnValueException","status_code":200,"error_message":"invalid value, please check our API documentation for the correct data structure for this column. https://api.developer.monday.com/docs/change-column-values","error_data":{"column_value":"{\"phone\"=\u003e\"+01234567899\", \"countryShortName\"=\u003e\"GB\"}","column_type":"PhoneColumn"}}"

I’m also seeing \u003e\ (which is ‘>’ in unicode). I wonder if there’s a ‘<’ missing somewhere on the backend?

Here’s the query I’m using:

"{"query":"mutation ($update: JSON!) { change_multiple_column_values (item_id: REDACTED, board_id: REDACTED, column_values: $update) {id}}","variables":{"update":"{\"phone_number__secondary_1\":{\"phone\":\"01234567899\",\"countryShortName\":\"GB\"}}"}}"

This query format is able to update other column/s no problem so it’s definitely something specific with the Phone column.

15

Hello all,

We recently released a change to strictly validate the values sent to our columns.

@bartwwww, we’re now requiring that phone numbers and country codes be valid in order to properly populate the Phone column. If numbers are coming from your users, I suggest implementing a check on your end to ensure only proper values are sent to the API.

Please see the update in our changelog.

16

As far as I can tell, the phone numbers we’re passing to the API are valid US phone numbers.

I’m wondering if we need to provide them in a specific format, or if there’s some other checks that you’re applying to verify if the numbers are valid.

Can you share more information on what “valid” means - what are the validation rules you’re applying on your end?

17

Hi @alessandra, I took the same number and tried to enter it via both the Monday UI and via the Monday API.

The Monday UI happily accepted it
image

The Monday API did not

error_message":"invalid value, please check our API documentation for the correct data structure for this column. https://api.developer.monday.com/docs/change-column-values","error_data":{"column_value":"{\"phone\"=\u003e\"+2025550191\", \"countryShortName\"=\u003e\"US\"}","column_type":"PhoneColumn"}}

Any idea what is going on here? Like I said, the number seems to be valid and in a valid format. Here’s the full payload our tests are sending:

{“boardId”: 1968240186, “itemName”: “Organic real-time Local A”, “columnValues”: “{"email": {"email": "automated-testing+qzmzixerrsadq@partnerslate.com", "text": "automated-testing+qzmzixerrsadq@partnerslate.com"}, "phone_1": {"phone": "2025550191", "countryShortName": "US"}, "dup__of_project_name9": "Susan Richards", "text": "Special educational needs teacher", "text0": "Garcia-Williams", "text1": "yummy - cookie", "text3": "http://www.olsen-daniel.com/\”, "text4": "243796", "text7": "1", "dup__of_company9": "$5 Million - $50 Million", "dup__of_company_revenue": "5-10 Years", "date_1": {"date": "2022-11-01"}}"}

18

As of Today, my API automations (through Zapier) started working again. The Monday dev team mustve fixed the phone validation issue!

I did not change anything on my side.

Thanks Monday team!

19

Hello everyone!

The validation for the phone column has been temporarily removed.

We are preparing some specific documentation to help you with it, and will let you know before we implement it again.

Cheers,
Matias

1 Like
20

We will turn the phone column validation on beginning December 1st, 2022. You can find more details in this announcement!

22

I´m experiencing the same problem:

Invalid value for {“phone”=>“+491765579XXXX‬”} on PhoneColumn. invalid value, please check our API documentation for the correct data structure for this column. Guide to Changing Column Values

23

Hello there @ovokevinxo and welcome to the community!

I hope you like it here :muscle:

Would you be able to please share with me your entire mutation so we can take a look into it?

Looking forward to hearing from you :slightly_smiling_face:

Cheers,
Matias

24

board_id:

1180055514

item_name:

xxx yyyy

{“id”:“status”,“type”:“color”}:

Neuer Lead

{“id”:“phone”,“type”:“phone”}:

+491765579xxxx‬

{“id”:“email”,“type”:“email”,“field”:“emailAddress”}:

info@xxx.de

{“id”:“text08”,“type”:“text”}:

FB

{“id”:“text4”,“type”:“text”}:

{{189972487__data__notiz}}

{“id”:“text6”,“type”:“text”}:

xxx
{“id”:“text9”,“type”:“text”}:

yyy

{“id”:“text2”,“type”:“text”}:

{{189972487__data__was_ist_dein_größtes_problem_&_wie_lange?}}

{“id”:“text3”,“type”:“text”}:

{{189972487__data__wieviel_könntest_du_sofort_investieren?}}

{“id”:“text63”,“type”:“text”}:

{{189972487__data__willst_du_unbedingt_etwas_ändern?}}

{“id”:“text32”,“type”:“text”}:

{{189972487__data__produkt}}

{“id”:“link”,“type”:“link”,“field”:“linkUrl”}:

www.vvv.de

{“id”:“datum”,“type”:“date”}:

2023-03-07T11:00:00+00:00

{“id”:“status5”,“type”:“color”}:

{{189972487__data__qualität}}

{“id”:“text58”,“type”:“text”}:

{{189972487__dealspipeline__name}}

link:

1:

{“id”:“link”,“type”:“link”,“field”:“linkUrl”}:

www.vvv.de

E-Mail:

1:

{“id”:“email”,“type”:“email”,“field”:“emailAddress”}:

info@vvv.de

Fields with no value:

group_id

25

Hello @ovokevinxo,

Those look like the variables for your mutation, would you be able to send the mutation itself with the actual values of the variables you are using? (not with the names of the variables in it)

It should look something like:

mutation {
  change_multiple_column_values(item_id:1234567890, board_id:1122334455, column_values: "{\"phone\" : {\"phone\" : \"+12025550169\", \"countryShortName\" : \"US\"}}") {
    id
  }
}

or something similar to that.

You can build your mutation in your Playground which should make this easier for you:

  1. Click on your profile picture or initials
  2. Click on “Developers”
  3. Click on “Developer”
  4. Click on “API Playground”

Looking forward to hearing from you!

Cheers,
Matias

26

Oh sorry I´m using zapier to send the data. It´s the wrong topic here right? I created a new topic

1 Like