Hey, I´m trying to send contacts with zapier to Monday but get many times problems with the phone number.
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
I tried the number with 0, +49 or nothing and its not working with this contact. Other accounts are working. I can´t find the problem.
Hello @ovokevinxo,
I just created a Zap with a test account.
You can pass values like:
And it works well.
Let me know if this helps!
Cheers,
Matias
Not working 
Invalid value for {“phone”=>“4917655791111”, “countryShortName”=>“DE”} on PhoneColumn. invalid value, please check our API documentation for the correct data structure for this column. https://developer.monday.com/api-reference/docs/change-column…
Hello again,
Can you please provide a screen recording or screenshots of your entire zap’s configuration (do not include any sensitive information).
Please mention me with a @ when you reply so I see the notification!
Cheers,
Matias
Its easier to copy the whole text instead having screenshots.
DATA OUT
id:
60e983e9-67d2-403c-9430-59382cd19183
data:
quelle:
FB
produkt:
Fundament
webseite:
qualität:
Mittel
follow-up_datum:
2023-05-01T10:00:00.000Z
datum_der_eintragung:
2023-03-07T11:00:00.000Z
global_contact_email:
global_contact_phone:
17655791111
global_contact_company:
Lead
global_contact_lastName:
vvv
global_contact_firstName:
mmm
beschreibung_der_situation:
text example
welches_ziel_möchtest_du_erreichen?:
text example
isArchived:
false
lastContactAttempt:
2023-03-23T17:59:00.000Z
email:
tenantId:
070b6adb-d9eb-4179-bf10-837692e674b4
authorId:
4ac42152-f72c-4a7a-9896-99350e29a982
createdAt:
2023-03-07T20:08:28.103Z
updatedAt:
2023-04-16T20:51:00.783Z
filterData:
quelle:
fb
produkt:
fundament
webseite:
qualität:
sehr gut
follow-up_datum:
2023-05-01t10:00:00.000z
datum_der_eintragung:
2023-03-07t11:00:00.000z
global_contact_email:
global_contact_phone:
17655791111
global_contact_company:
lead
global_contact_lastname:
vvv
global_contact_firstname:
bbb
beschreibung_der_situation:
text example
welches_ziel_möchtest_du_erreichen?:
text example
Fields with no value:
importId
querystring
DATA IN:
board_id:
1180055514
item_name:
bbb vvv
{“id”:“status”,“type”:“color”}:
Neuer Lead
{“id”:“phone”,“type”:“phone”}:
17655791111
{“id”:“email”,“type”:“email”,“field”:“emailAddress”}:
{“id”:“text08”,“type”:“text”}:
FB
{“id”:“text4”,“type”:“text”}:
{{189972487__data__notiz}}
{“id”:“text6”,“type”:“text”}:
text example
{“id”:“text9”,“type”:“text”}:
text example
{“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”}:
Fundament
{“id”:“link”,“type”:“link”,“field”:“linkUrl”}:
{“id”:“datum”,“type”:“date”}:
2023-03-07T11:00:00+00:00
{“id”:“status5”,“type”:“color”}:
Sehr Gut
{“id”:“text58”,“type”:“text”}:
{{189972487__dealspipeline__name}}
E-Mail:
1:
{“id”:“email”,“type”:“email”,“field”:“emailAddress”}:
link:
1:
{“id”:“link”,“type”:“link”,“field”:“linkUrl”}:
Fields with no value:
group_id
Hello again,
I just tested this again using 17655791111 (as in what you sent) and it worked fine as well.
I will need you to please send screenshots or a screen recording to check your entire configuration since I can not reproduce the issue. I might be able to see what is causing the issue if I see this.
Looking forward to hearing from you.
Cheers,
Matias
With all the private data of the zap its a bit difficult. Can I send a screenrecord to you private somehow?
Sometimes it is working and sometimes always the phone error. I used with both the same way to write the number down.
Hello @ovokevinxo
Thank you for that information!
What happens if you do not use the plus symbol and use the number + the country name like this:
Do you get an error in that case?
Hey @Matias.Monday
Same problem, I tried all different ways
+49
49
0
nothing
with DE at the end
without DE
Hello @ovokevinxo
What happens if you use 4917655791111 DE?
Does that work?
Can you send a screenshot of what you are sending to the phone column (you can use a fake number if you don’t want to show the one you are using, but it has to have the exact same format and number of characters).
Hello Matias.Monday,
I too am having the same issue with getting an error code coming through into Monday. I have attached 2 screenshots. One is a Zapier test that comes through fine with number, and the name is formatted correctly. IN the second screenshot you will see that I went through our contact us form through squarespace into Monday, and the results provided no number and the name field was coming through with the headers. Any advice on how we can change this.
We have also tried changing our form on our website to just have text fields instead of number format. We copied 4917655791111 DE from this last comment as well. Each time it errors.
Hello there @mromska,
It looks like the issue lies on passing values between parenthesis.
Instead of (917) 257-1935, you should pass 9172571935 and the two letters for the country afterwards.
I am not sure how you can format this in Zapier before you send it our way, but I believe there could be a tool for that. You can ask Zapier’s team about it.
Can you please show me a screenshot of the zap using “4917655791111 DE” and showing an error?
