Change Column Value with PHP Variable

monday Apps & Developers
4

Thanks for your response on this. Much appreciated. Unfortunately it is still not working though. I am getting this error:

Variable columnVal of type JSON! was provided invalid value

And the code I am using is shown below:

$token = [MYTOKEN];
$tempUrl = "https://api.monday.com/v2/";

$office_id = 212; //THIS VALUE IS ACTUALLY COMING FROM MYSQL DATABASE QUERY

$headers = ['Content-Type: application/json', 'User-Agent: [MYTEAM] GraphQL Client', 'Authorization: ' . $token];

$query = 'mutation ($columnVal: JSON!) { change_column_value (board_id: [BOARD_ID], item_id: [ITEM_ID], column_id: [COLUMN_ID], value: $columnVal) { id } }';

$vars = ['variables' => [
    'columnVal' => $office_id
]];

$data = @file_get_contents($tempUrl, false, stream_context_create([
 'http' => [
 'method' => 'POST',
 'header' => $headers,
 'content' => json_encode(['query' => $query, 'variables' => $vars]),
 ]
]));