2022 Jul 02 3:27 PM
Hello Experts,
I would like to update two cells of google spreadsheet using batch update & google api v4. I am getting one error:
"{ "error": { "code": 400, "message": "Invalid JSON payload received. Unknown name \"valueInputOption\" at 'data': Cannot find field.\nInvalid JSON payload received. Unknown name \"data\" at 'data': Cannot find field.", "status": "INVALID_ARGUMEN"
My payload in sap abap is:
CONCATENATE
'{'
' "valueInputOption": "USER_ENTERED",'
' "data": ['
' {'
' "range": "Inspections!R5C31",'
' "majorDimension": "ROWS",'
' "values": ['
' ["12345"]'
' ]'
' }'
' ]'
'}' INTO lv_json.
Could you please help me to correct my error? It will be very grateful.
Thanks,
Arindam
2022 Jul 20 2:17 PM
post the full code, now it is not clear how you run this payload