I’m currently setting up a meeting database and using zapier to link data between Calendly and monday. I’ve been playing around with a zap on Zapier and made some progress after reading the Json formatting page. However I’ve run into some issues with a couple columns that I’m having difficulty linking properly.
I can’t seem to get the phone column and Date + time working as I get the error (invalid value, please check our API documentation for the correct data) with every variation of the structure I can think off. Date and time seems to have an issue as the data pulled from calendly is a combination of Date and time and the Json seems to ask for them split for the format which I’m not sure how to do. For phone I’m not really sure as it seems like it should work with the current set up. It could also be an issue on Calendly’s end where the data sent is packaged in a way where its hard to use in JSON, I’m not too sure.
I’m quite new to this so I am probably missing something, any help would be hugely appreciated.
My current solution is to just put the info into a text column but I would love to be able to put the data into the dynamic columns (eg a clickable email link)
Attached below is some screenshots for context
Thanks for your time