Google Drive: GFile, Export as Text<\/div>
Stores a Google file as Workflow data after converting it to a Text file. It is also possible to change the file name. If a file other than a Google file (Docs\/Slides) is specified an error will occur.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> U: Select HTTP_Authz Setting *<\/span><\/li>\n
- <\/i><\/span> A1: Set FILE-ID in Drive *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B1: Set File Name if you want to save as a different name#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B2: Select FILE DATA that stores Exported File (append) *<\/span><\/li>\n
- <\/i><\/span> B3: Select STRING DATA that stores File Name in Drive (update)<\/li>\n
- <\/i><\/span> B4: Select STRING DATA that stores Mime-Type in Drive (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get ( "AuthzConfU" ); \/\/\/ REQUIRED\n engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst strInputfileId = configs.get ( "StrConfA1" ); \/\/\/ REQUIRED\n if( strInputfileId === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: FileID} is empty \\n" );\n }\nlet strSaveas = configs.get ( "StrConfB1" ); \/\/ NotRequired\n if( strSaveas === "" ){\n engine.log( " AutomatedTask ConfigWarning:" +\n " Config {B1: ExportedSaveas} is empty" );\n }\nconst filesPocketDownload = configs.getObject( "SelectConfB2" ); \/\/\/ REQUIRED\nconst strPocketNameOnDrive = configs.getObject( "SelectConfB3" ); \/\/ NotRequired\nconst strPocketMimetype = configs.getObject( "SelectConfB4" ); \/\/ NotRequired\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet filesAttached = engine.findData( filesPocketDownload ); \/\/ java.util.ArrayList\nif( filesAttached === null ) {\n engine.log( " AutomatedTask FilesArray {B2} (empty)" );\n filesAttached = new java.util.ArrayList();\n}else{\n engine.log( " AutomatedTask FilesArray {B2}: " +\n filesAttached.size() + " files" );\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ Gets a file's metadata by ID.\n\/\/\/ Google Workspace for Developers > Google Drive for Developers > v3\n\/\/\/ https:\/\/developers.google.com\/drive\/api\/v3\/reference\/files\/get\n\/\/ request1, prepare\nlet request1Uri = "https:\/\/www.googleapis.com\/drive\/v3\/files\/" + strInputfileId;\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n request1 = request1.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n request1 = request1.queryParam( "supportsAllDrives", "true" );\n\/\/ request1, try\nconst response1 = request1.get( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest1 Start: " + request1Uri );\nconst response1Code = response1.getStatusCode() + "";\nconst response1Body = response1.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response1Code );\nif( response1Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response1Code + "\\n" + response1Body + "\\n" );\n}\n\/\/ response1, parse\n\/* engine.log( response1Body ); \/\/ debug\n{\n "kind": "drive#file",\n "id": "0BwSW_lixFpUuQ2JyV1pqU3VzTGs",\n "name": "Questetra-Intro-en.pdf",\n "mimeType": "application\/pdf"\n}\n*\/\nconst response1Obj = JSON.parse( response1Body );\nengine.log( " AutomatedTask ApiResponse: File Name OnDrive: " + response1Obj.name );\nengine.log( " AutomatedTask ApiResponse: File MIME-Type: " + response1Obj.mimeType );\nif( strSaveas === "" ){\n strSaveas = response1Obj.name + ".txt";\n}\n\n\/\/\/ Export as PDF from Google Drive to BPMS.\n\/\/\/ Google Workspace for Developers > Google Drive for Developers > v3\n\/\/\/ https:\/\/developers.google.com\/drive\/api\/v3\/reference\/files\/export\nlet request2Uri = "https:\/\/www.googleapis.com\/drive\/v3\/files\/" + strInputfileId + "\/export";\nlet request2 = httpClient.begin(); \/\/ HttpRequestWrapper\n request2 = request2.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n request2 = request2.queryParam( "mimeType", "text\/plain" );\n\/\/ request2, try\nconst response2 = request2.get( request2Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest2 Start: " + request2Uri );\nconst response2Code = response2.getStatusCode() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response2Code );\nif( response2Code !== "200"){\n const response2Body = response2.getResponseAsString() + "";\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response2Code + "\\n" + response2Body + "\\n" );\n}\n\/\/ response2, parse\nconst fileTmp = new com.questetra.bpms.core.event.scripttask.NewQfile(\n strSaveas, response2.getContentType(), response2.getResponse()\n );\nfilesAttached.add( fileTmp );\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( filesPocketDownload, filesAttached );\n\nif( strPocketNameOnDrive !== null ){\n engine.setData( strPocketNameOnDrive, response1Obj.name );\n}\nif( strPocketMimetype !== null ){\n engine.setData( strPocketMimetype, response1Obj.mimeType );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nNotes:\n- Text extraction of contracts and manuals created with Google Docs is automated.\n- The File ID can be obtained from the URI or the sharing settings screen.\n- The exported content is limited to 10MB.\n- To extract string data (string type) from text file (file type), \n - Converter (Text File to String type data)\n - https:\/\/support.questetra.com\/addons\/converter-textfile-to-string\/\nNotes-ja:\n- Google \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3067\u4f5c\u6210\u3055\u308c\u305f\u5951\u7d04\u66f8\u3084\u30de\u30cb\u30e5\u30a2\u30eb\u306e\u30c6\u30ad\u30b9\u30c8\u60c5\u5831\u62bd\u51fa\u3092\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\u3002\n- File ID \u306f URI \u3084\u5171\u6709\u8a2d\u5b9a\u753b\u9762\u7b49\u304b\u3089\u53d6\u5f97\u3057\u307e\u3059\u3002\n- Export\u3055\u308c\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u30b5\u30a4\u30ba\u4e0a\u9650\u306f 10MB \u3067\u3059\u3002\n- \u30c6\u30ad\u30b9\u30c8\uff08\u30d5\u30a1\u30a4\u30eb\u578b\uff09\u304b\u3089\u6587\u5b57\u5217\u30c7\u30fc\u30bf\uff08\u6587\u5b57\u5217\u578b\uff09\u3092\u62bd\u51fa\u3059\u308b\u306b\u306f\u5225\u9014\u81ea\u52d5\u5de5\u7a0b\u3092\u914d\u7f6e\u3057\u307e\u3059\u3002\n - \u30b3\u30f3\u30d0\u30fc\u30bf \uff08\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb to \u6587\u5b57\u578b\u30c7\u30fc\u30bf\uff09\n - https:\/\/support.questetra.com\/ja\/addons\/converter-textfile-to-string\/\n\nAPPENDIX-en\n- Setting example of "HTTP Authentication" (OAuth2)\n - Authorization Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n - Token Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/token\n - Scope:\n - https:\/\/www.googleapis.com\/auth\/drive.readonly\n - Client ID, Consumer Secret:\n - ( from https:\/\/console.developers.google.com\/ )\n - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\nAPPENDIX-ja\n- "HTTP\u8a8d\u8a3c"\uff08OAuth2\uff09\u306e\u8a2d\u5b9a\u4f8b\n - Authorization Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n - Token Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/token\n - Scope:\n - https:\/\/www.googleapis.com\/auth\/drive.readonly\n - Client ID, Consumer Secret:\n - ( from https:\/\/console.developers.google.com\/ )\n - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- Google-Drive-GFile-Export-as-Text-2021.xml<\/a><\/li>\n\n\n\n
- Google-Drive-GFile-Export-as-Text-2023.xml<\/a>\n
- \n
- 2023-08-15 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
2021-04-08 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/google-drive-gfile-export-as-text-2021\/<\/a>
<\/i> The Addon-import feature is available with Professional<\/strong><\/span> edition.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- Text extraction of contracts and manuals created with Google Docs is automated.<\/li>\n\n\n\n
- The File ID can be obtained from the URI or the sharing settings screen.<\/li>\n\n\n\n
- The exported content is limited to 10MB.<\/li>\n\n\n\n
- To extract string data (string type) from text file (file type):\n
- \n
- Converter (Text File to String type data)<\/li>\n\n\n\n
- https:\/\/support.questetra.com\/addons\/converter-textfile-to-string\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Stores](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/04\/Google-Drive-GFile-Export-as-Text-2021-execution.png?resize=1200%2C675&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/04\/Google-Drive-GFile-Export-as-Text-2021-config-en-869x630.png?resize=869%2C630&ssl=1\")
<\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- \n
- Setting example of “HTTP Authentication” (OAuth2)\n
- \n
- Authorization Endpoint URL:\n
- \n
- https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Token Endpoint URL:\n
- https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Authorization Endpoint URL:\n
- Setting example of “HTTP Authentication” (OAuth2)\n
- Google-Drive-GFile-Export-as-Text-2023.xml<\/a>\n
- <\/i><\/span> A1: Set FILE-ID in Drive *<\/span>#{EL}<\/sup><\/span><\/li>\n