Hi, Im trying to make a Zap between Monday and Followupboss. Unfortunately Monday’s side dosen’t pick up the columns that I need to send over to Followupboss.
I’ve managed to get a JSON query setup to pick up the values from Monday with this:
With this I guess I need to setup a Javascript with Code by Zapier but Im not sure how to move forward from here. Is Javascript the way to go? If so, I have never used Javascript and is this something that requires a lot of experience?
Best answer by MercologyBest answer by Mercology
@Robin.H To do this in the Code atep, you need to:
Get the Authorization Key from you Monday.com account
Build the query string as JSON
Complete the code and test.
Here is a code snippet you can use to complete this task:
////Set the authorization key//var authKey = "xxxxxxxxxxxx";
////Build query as JSON - must be one string//var myQuery = JSON/stringify({“query”: {boards(ids: xxxxxxxx) {items { column_values(ids: [\"telefon\", "\e_post\", "\plats\"]) {title text id}}}}
//
//Build GET options
//
const options = {
url: 'https://api.monday.com/v2/',
method: 'GET',
headers: {
'Content-Type': 'application/json',
'Accept': 'application/json',
'Authorization': authKey
},
params: myQuery
}
//
//Send the request
//
return z.request(options)
.then((response) => {
response.throwForStatus();
const results = z.JSON.parse(response.content);
});
//
//Return the results
//
return results;
Let’s try using a Javascript template for the variables in the query:
Replace the current var myQuery… with the following:
var boardId="xxxxx"; //if this is a number, remove the quotes...var field1="telefon";
var field2="e_post";
var field3="plats";
var myQuery = `"query": {boards(ids: ${boardId}) {items {column_values(ids: [\"${field1}\", \"${field2}\", \"${field3}\"]) {title text id}}}}`;
If this doesn’t work, are you available for a Zoom call? Let me know, happy to jump on to debug.
Hey again, I realise there is quite the timezone differens between the US and Sweden
I will discuss this with my colleagues on monday and see if this is the way for us to solve this problem or if its out of our scope. Or maybe a solution for the future!
Incase we choose to try this way, what is the easiest way for me to contact you and setup a zoom call?
The syntax is the tricky part as we are converting a GraphML query into JSON. Once we get the syntax, this will work. I will private message you about getting together in Zoom.
When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
More about cookies
Customize which cookies to allow
Marketing cookies
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Social media cookies
label
These cookies are set by a range of social media services that we have added to the site to enable you to share our content with your friends and networks. They are capable of tracking your browser across other sites and building up a profile of your interests. This may impact the content and messages you see on other websites you visit. If you do not allow these cookies you may not be able to use or see these sharing tools.
Analytics/performance cookies
These cookies enable the website to provide enhanced functionality and personalization, and allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. These cookies may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly and we will not know how you are using our site.
Functional cookies
label
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
Essential cookies
Always active
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.