Here’s a basic snippet of PHP that lets me execute queries against the v2 API and return the data as JSON. I hope it can provide a leg up and save someone time as they get started.
Just enter your own API key, change the URL to match yours, and put in your query.
$token = ' Personal API Token]';
$tempUrl = "https://api.monday.com/v2/";
thanks, I’ve tried to create a board with a group “test” that contains a simple title and a note column (type:text). I want to add an item with this query below.
It works, but it doesn’t add the value in the text column “note”. the column stays empty… 😦
first of all, lets make sure that you have the correct column id for the notes column.
you can try out this query via our GraphiQL try it yourself interface to see all columns of that board:
query{
boards (ids: xxxxxxxxx){
columns{
id
title
type
}
}
}
now that you are sure you have the correct column ID lets look at the mutation itself.
since the column values are a string inside a string they need to be escaped, like so:
column_values: "{\\"note\\": \\"a easy text here\\"}"
let us know if it worked 🙂
I have used this Code to create a pulse/item and change columns values in a board. It works well. I am working on moving changing the code from the API v1 to API v2. In v1 when I create a new pulse/item in a group it places the new pulse/item at the top of the group.
I noticed with v2 it places the pulse/item at the bottom of the group. Is there anyway to make a new pulse/item go to the top like it does with v1?
Thanks for the response. I have another question. How do I insert variables in this code? I would like to pass $_POST data from a web form to this code so it can dynamically add the value to the column with the variable $columnValue. How do I go about doing this?
You can dynamically update variables by including references to variables in your query and then passing the actual data for these variables in another “variables” JSON string in the request body. For example, this request would let you dynamically populate the board ID, item name, and columns in a mutation.
Query string (“query” value in request body)
mutation ($board: Int!, $name: String!, $column: JSON!) {
create_item( board_id: $board, item_name: $name, column_values:$column) {
id
column_values {
id
value
}
}
}
mutation snippet works fine through “…/v2/try-it-yourself” page.
Hey @alextop – are you using “https://swhatpresents].monday.com/v2” as the URL, or is this dummy data? This is not a valid URL, I’d suggest using https://api.monday.com/v2 🙂
thanks !
i have replaced the url but is is something else (
Are you receiving an error from our server? If you are, it indicates your query isn’t formatted correctly and I can help you figure out what the problem with it is.
If your code isn’t sending a request to our server at all, that means there’s an issue with your code (as opposed to the query). I’m not super familiar with PHP and can’t really help you debug syntax errors.
To figure out if the issue is with your query or the code itself, let’s try a simple query first (before moving to a mutation). Can you try the code below and let me know if it works?
yes I have fixed , the reason was that I missed CURLOPT_HTTPHEADER information.
I have another question. When I create a new item and populate columns, I can fill the cells with Text type, but not with Long Text format. IDs of columns are correct (taken from query). Has someone complained on similar issue with Long Text format ?
Oh nice!
The long text column has a different structure as the text column – check our documentation at developers.monday.com for a full example.
Cheers!
Dipro
hi Dipro,
i have found and fixed. Thanks a lot for your support !
the code works fine with constant “item_name” (like: item_name: “superuser”. However, once i declare variable $name, (the code is above) i got parse error. What am I doing wrong with variables value, or something else ?
Hey Alex! The query structure looks correct. Are you sending the variables as a variables value in your HTTP request?
Your request’s body should look like this:
{ “query” : your query here],
“variables” : byour variables here] }
Hi Dipro, thank you for your help.
i understand now where my mistake is: I put my variables in wrong place.
Cheers,
Alex
Hi,
I am trying to create a page that would insert a new pulse on one of our boards. The above threads really helped and I was able to create a pulse with one column, however, when I am trying to insert data in each column I am getting a Parse error on " : " (STRING).
This is what I’m trying to run:
<?php
$token = ' MY TOKEN]';
$tempUrl = "https://api.monday.com/v2/";
Hey @Stephen, sorry for the late response here we just saw this.
Were you able to get your code working?
I suspect the issue here is that you are sending strings inside the JSON string without escaping them. I would suggest sending the column values in a format like so: column_values : "{\\"text\\" : \\"hello world\\"}"
Yes, we were able to get it to work 🙂 Thanks for the follow up, I appreciate it.
Newbie here! I want to use basically this same HEADER you have to create an API Connector in DOMO. But my authentication fails, even though I know the username and password is correct.
my code looks like this: (encodedData is the actual username and password)
