Skip to main content
Best answer

Gravity forms to Monday.com: phone number not working - “invalid API for column value” error

  • September 6, 2021
  • 3 replies
  • 301 views

Hi,

I’ve been trying to integrate gravity forms with monday. it all works fine except for the phone number column, it doesn’t like the number given on gravity forms and says its invalid API for column vaue whereas all other column values work. I have tried multiple examples of phone numbers and all say invalid api for column value. is this an issue with gravity forms or just monday? or a zapier issue?

Best answer by SamBBest answer by SamB

Welcome to the Community @SLL! :)

Judging by the wording of the error it sounds like the phone number isn’t being sent in a format that monday.com is expecting. 

Monday.com have written up a guide on how to setup data when integrating with their app through Zapier - https://support.monday.com/hc/en-us/articles/360014205860-Zapier-JSON-Formatting-Examples

In that guide it looks as though there’s are a couple different ways phone numbers should be added depending on the type of phone number being added:
87378353509874f82fdd8afd99ea1dcd.png

If only the phone number was added to the phone number field can you try adding the phone number in the relevant format (with or without Country Flag) as per monday.com’s documentation and see if that gets it working? 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7381 replies
  • Answer
  • September 9, 2021

Welcome to the Community @SLL! :)

Judging by the wording of the error it sounds like the phone number isn’t being sent in a format that monday.com is expecting. 

Monday.com have written up a guide on how to setup data when integrating with their app through Zapier - https://support.monday.com/hc/en-us/articles/360014205860-Zapier-JSON-Formatting-Examples

In that guide it looks as though there’s are a couple different ways phone numbers should be added depending on the type of phone number being added:
87378353509874f82fdd8afd99ea1dcd.png

If only the phone number was added to the phone number field can you try adding the phone number in the relevant format (with or without Country Flag) as per monday.com’s documentation and see if that gets it working? 


  • Beginner
  • 2 replies
  • October 12, 2021

Probably a little late to help you but I had the same problem and when I changed the setting to international on the gravity form phone field it worked great. Hope this helps somebody else.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7381 replies
  • October 13, 2021

Thanks for sharing the solution you found here, @JayX8. I’m sure it will be helpful to others in the Community too! :)