SAP to Google spreadsheet batch update

arindam_samanta — Sat, 02 Jul 2022 14:27:16 GMT

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

Re: SAP to Google spreadsheet batch update

Astashonok — Wed, 20 Jul 2022 13:17:35 GMT

post the full code, now it is not clear how you run this payload

topic Re: SAP to Google spreadsheet batch update in Application Development and Automation Discussions

SAP to Google spreadsheet batch update

Re: SAP to Google spreadsheet batch update