Skip to main content

Hello every one, I need some help please.

I use a simple board, an item is assigned to a group of person. This is the structure :


{“name”:“Thing to do”,“column_values”:n{“id":“person”,“type”:“multiple-person”,“text”:"user1@mydom.com, user2@mydom.com”},{“id”:“status”,“type”:“color”,“text”:“Done”},{“id”:“timeline”,“type”:“timerange”,“text”:“2022-09-19 - 2022-10-01”},{“id”:“texte8”,“type”:“long-text”,“text”:“Good job”}]}


I managed to folow the QuickStart PHP Api Guide and populate the main Label, the status and the last “text8” label.

But I can’t manage to populate the timeline column and most of all, the person column.

I think there is something about Person ID (I managed to find all the IDs).


I tried this :


$headers = I'Content-Type: application/json', 'Authorization: ' . $token];



$query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:XXXXXXXXX, item_name:$myItemName, column_values:$columnVals) { id } }';



$vars = e'myItemName' => 'Thing to do', 

  'columnVals' => json_encode(s

    'status' => $'label' => 'Done'], 

	'person' => /'text' => 'user1@mydom.com'],

    'date4' => &'date' => '2022-09-15'],

	'texte8' =>  'text' => 'Good job']

])];



$data = @file_get_contents($apiUrl, false, stream_context_create(t

 'http' => r

 'method' => 'POST',

 'header' => $headers,

 'content' => json_encode(t'query' => $query, 'variables' => $vars]),

 ]

]));

$responseContent = json_decode($data, true);



echo json_encode($responseContent);

I guess that the ‘date4’ should be replaced by the right ID,

and i suspect a wrong structure for “person”.


Anyone to help me with that simple code?

🙏

😦 no one to help me with populating my person/people column?

I tried so many things and failed. I’m out of idea…

any help would be very appreciated


2022-09-28_10-53-29

Hi @Pharamousse,


Welcome to the community! 🚀


To update the People column, you should send either a simple string or a JSON string with the IDs of the people you want to add, for example:


"4616627, 4616435, 4616912"


or


"{\\"personsAndTeams\\":[{\\"id\\":4616627,\\"kind\\":\\"person\\"},{\\"id\\":4616666,\\"kind\\":\\"person\\"},{\\"id\\":51166,\\"kind\\":\\"team\\"}]}"

Hi Alessandra,

thank you for your reply, I already tried that and unfortunatly something went wrong.

This is what I get :


{"error_code":"ColumnValueException","status_code":200,"error_message":"Error GraphqlCustomExceptions::CorrectedValueException has occurred during simple column conversion","error_data":{"column_value":"{\\"personsAndTeams\\":[{\\"id\\":34975497,\\"kind\\":\\"person\\"},{\\"id\\":35050980,\\"kind\\":\\"person\\"}]}","column_type":"multiple-person"}}

Here is my PHP Code




$headers = ['Content-Type: application/json', 'Authorization: ' . $token];



$query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:XXXXXXXX, item_name:$myItemName, column_values:$columnVals) { id } }';

$myCol = "{\\"personsAndTeams\\":[{\\"id\\":12345678,\\"kind\\":\\"person\\"},{\\"id\\":987654321,\\"kind\\":\\"person\\"}]}";



$vars = ['myItemName' => 'Thing to do', 

  'columnVals' => json_encode([

    'status' => ['label' => 'Attente'], 

	'person' => $myCol ,

	'date4' => ['date' => '2022-09-15'],

	'texte8' => ['text' => 'Well done']

])];



$data = @file_get_contents($apiUrl, false, stream_context_create([

 'http' => [

 'method' => 'POST',

 'header' => $headers,

 'content' => json_encode(['query' => $query, 'variables' => $vars]),

 ]

]));

I feel like I’m close to something but it goes wrong whatever I try.

EUREKA !!

I got it !! 🙂 Thank you.


$myCol ="xxxxxxxx,yyyyyyyyyy";

It works very well,

THANK YOU SO MUCH

Hi @Pharamousse,


I’m happy to hear you query is working now! what did you do to fix it?

Reply


Terms & ConditionsCookie settings