Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP to Google spreadsheet batch update

arindam_samanta
Participant
0 Kudos
513

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

1 REPLY 1

Astashonok
Participant
0 Kudos
306

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