Discussion about developing the ProcessMaker application and suggestions for improving it

Moderator: amosbatto

By fredericb
#825730
Hello,

i trie to update a google sheet with a PHP trigger :
Code: Select all
$ss_id ="1ddgkZLlCk22XAKpMExL4e1x6EGbc0rWRpyIeuhULlEg";	
$ss_range = "A2";
$overWriteParameters = [];
$pathParameters = [
    "spreadsheetId" => $ss_id ,
	"range" => $ss_range,
];
$queryParameters = [];
$requestBody =json_encode(array("values"=>array(array(10))));
$r = executeRestConnector('updateSheet', $overWriteParameters, $pathParameters, $queryParameters, $requestBody);

@@var_SS_Result = $requestBody;	
@@var_SS_Result .= $r->{'message'}->{'values'};
@@var_SS_Result .= $r->{'message'};	

i get allways the same error :
{"values":[[10]]}
Client error: `PUT https://sheets.googleapis.com/v4/spread ... Option=RAW` resulted in a `400 Bad Request` response:
{
"error": {
"code": 400,
"message": "Invalid JSON payload received. Unknown name \"\": Root element must be a (truncated...)


i have tried to change every possibilty in $requestBody .. but nothing correct
Do you some idea ?
User avatar
By amosbatto
#825782
Can you get other Google Sheets endpoints to work? Is it only that one where you have the problem or is it every sheets.googleapis.com/v4/spreadsheets/ endpoint?

Hi Support, I think this is good. I too have fixe[…]

Hi, I'm facing the same error and when I run : […]

Routing Logic

Hi All I am doing a process, where i have 3 tasks […]

Hi @amosbatto, thanks a lot. at least the message[…]