Hi @arunicbe,
Welcome to the community!
You’re missing the operator argument in your query (see more here). Since you’re filtering by the phone number as a string, you would use contains_text.
I added the operator and removed the + sign from the phone number string, and it successfully returned the items for me.
Here’s the updated query:
query { boards (ids: 1917599964) {
items_page (query_params: {rules: [{column_id: "mobile", compare_value: ["912222333345"], operator:contains_text}]}) {
cursor
items {
id
name
}
}
}
}
Let us know if you have other questions!
Best,
Rachel
                
     
                                    
            I just copied the query in my code. Now it is giving just null as result.
                
     
                                    
            I am using PHP to call the api. My full code is below:
<?php
$token = 'xxx';
$apiUrl = 'https://api.monday.com/v2';
$headers = ['Content-Type: application/json', 'Authorization: ' . $token];
	$query =	'query { boards (ids: 1917599964) { ' .
		' items_page (query_params: {rules: [{column_id: "mobile", compare_value: ["912222333345"], operator:contains_text}]}) { ' .
		' cursor ' .
		' items { ' .
		' id ' .
		' name ' .
		' } ' .
		' } ' .
		' } ' .
		' } ' ;
  
$data = @file_get_contents($apiUrl, false, stream_context_create([
 'http' => [
  'method' => 'POST',
  'header' => $headers,
  'content' => json_encode(['query' => $query]),
 ]
]));
$responseContent = json_decode($data, true);
echo json_encode($responseContent);
?>
Upon investigation,  I found PHP showing warning like this.
Warning: file_get_contents(https://api.monday.com/v2): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
However, another api call I have is working fine.
                
     
                                    
            Hello there @arunicbe,
Our logs appear to indicate that the column you are trying to use (of ID “mobile”) is not being found.
You can check the IDs of your board with a query like this one:
{
  boards(ids: 1234567890) {
    columns {
      id
      title
    }
  }
}
Also, I recommend using something like this instead of your query:
{
  items_page_by_column_values(
    limit: 50
    board_id: 1234567890
    columns: [{column_id: "phone__1", column_values: ["9720531111111"]}]
  ) {
    cursor
    items {
      id
      name
    }
  }
}
I hope that helps!
Cheers,
Matias
                
     
                                    
            
Both working. Thanks for your help.
                
     
                                    
            Happy to help @arunicbe !!!