Integrate with google drive

Scriptcase 9 General
#1

Dear

I use MySQL. I want to let my user to use scriptcase form to upload file and then store the file to google drive.
Can anyone share code with this kind of implementation?
What I was doing is, I created a datatype of blob in the database and let scriptcase to upload file to mysql.
Then, I was trying to use google apps script to fetch the file form mysql and upload it to google drive.
I failed to do so, and I think the problem is Jdbc Blob is not the same as the blob used in google apps script.
…
Or Does anyone have experience uploading file to google drive by PHP?

Thank you!

#2

I Have seen the video in youtube which step by step you can create a google Drive API in order to upload files to your gmail account. Video https://www.youtube.com/watch?v=nQnK2k1tEIM . The Video is simple and i’ve done it, i can succesfully upload my files.
But here is my QUESTION: In the video the user goes to Tools => Api => Add new, and complete all the inputs (Name, Mode, Gateaway, App Name, JSON OAUTH, Auth Code)
Can i do this dynamically inside my code ? I have done this dynamically inside my code with dropBox but is different, i don’t know how to do this with google drive because the manual is pity. I searched the scriptcase Manual and they provide this function (sc_api_upload):

sc_api_upload([
‘settings’ => [
‘app_name’ => ‘scriptcase’,
‘gateway’ => ‘google_drive’,
‘json_oauth’ => ‘’,
‘auth_code’ => ‘’,
‘token_code’ => ‘’,
],
‘file’ => {file},
‘destination’ => ‘’,
]);

Can i do this in order to have the same result with the video? EXAMPLE

sc_api_upload([
‘settings’ => [
‘app_name’ => ‘scriptcase’,
‘gateway’ => ‘google_drive’,
‘json_oauth’ => ‘myJson_oauth’,
‘auth_code’ => ‘myAuth_code’,
‘token_code’ => ‘’, ?What is this ?
],
‘file’ => {file},
‘destination’ => ‘’,
]);

I don’t know what to place in file => {file} is it required ?
I don’t know what to place in destination => '' is it required ?
And what is token_ code=>''? In the Manual of scriptcase token_code the description is blank white empty, they are not saying anything or even in the video is nowhere. What is it ? is it required ?

Thank you everyone

#3

Hi, can you solve?
I need do it **dynamically inside my code **

#4

Hi, I don’t know if SC has the guide for we can work?

#5

I Need Help for step to step i can use the macros ( sc_api_download and sc_api_upload). with Google Drive.

#6

This problem was reported some time ago. Sc team please we need you solve it.