{"id":148565,"date":"2023-07-27T15:09:20","date_gmt":"2023-07-27T06:09:20","guid":{"rendered":"https:\/\/support.questetra.com\/?p=148565"},"modified":"2023-07-27T15:09:23","modified_gmt":"2023-07-27T06:09:23","slug":"dropbox-upload-202307","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/dropbox-upload-202307\/","title":{"rendered":"Upload to Dropbox"},"content":{"rendered":"\n

Upload to Dropbox<\/strong><\/h4>\n\n\n\n

Dropbox \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/a><\/p>\n\n\n\n

Upload files to specified directory in Dropbox. You can specify whether to overwrite files with the same name.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
conf_OAuth2<\/dt>
C1: OAuth2 Setting *<\/span><\/dd>\n
conf_Directory<\/dt>
C2: Directory on Dropbox (e.g. “\/aaa\/bbb\/”) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_uploadedFile<\/dt>
C3: FILE DATA for Upload *<\/span><\/dd>\n
conf_isOverWrite<\/dt>
C4: is overwrite the existing file<\/dd>\n
conf_fileId<\/dt>
C5: STRING DATA for file ids (update)<\/dd>\n
conf_fileUrl<\/dt>
C6: STRING DATA for file urls (update)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\n\/\/ Upload to Dropbox via DropboxAPI v2 (ver. 202307)\n\n\/\/ OAuth2 config sample at [OAuth 2.0 Setting]\n\/\/ - Authorization Endpoint URL: https:\/\/www.dropbox.com\/oauth2\/authorize?token_access_type=offline\n\/\/ - Token Endpoint URL: https:\/\/api.dropboxapi.com\/oauth2\/token\n\/\/ - Scope: \n\/\/ - Consumer Key: (Get by Dropbox)\n\/\/ - Consumer Secret: (Get by Dropbox)\n\nconst SIZE_LIMIT = 94371840; \/\/File size border of Questetra (90MB)\n\nmain();\nfunction main(){\n\n  \/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 \/ Config Retrieving ==\n  const oauth2        = configs.get( "conf_OAuth2" ) + "";\n  const directory     = configs.get( "conf_Directory" ) + "";\n  const isOverWrite   = configs.getObject( "conf_isOverWrite" );\n  const idDataDef     = configs.getObject("conf_fileId");\n  const urlDataDef    = configs.getObject("conf_fileUrl");\n\n  \/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 \/ Data Retrieving ==\n  const files = engine.findData(configs.getObject("conf_uploadedFile"));\n  if (files === null) {\n    engine.log("no file");\n    return;\n  }\n\n  \/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\n  checkDirectory(directory)\n  checkFile(files, idDataDef, urlDataDef);\n\n  let uploadedFileData = [[], []]; \/\/0:ID,1:URL\n\n  for (let i = 0; i < files.size(); i++) {\n    engine.log("upload filename:" + files.get(i).getName());\n    upload(oauth2, files.get(i), directory, uploadedFileData, isOverWrite);\n  }\n\n  \/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\n  setData(idDataDef, uploadedFileData[0]);\n  setData(urlDataDef, uploadedFileData[1]);\n}\n\n\/**\n * \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u5148\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u540d\u306e\u30c1\u30a7\u30c3\u30af\n * @param {String} directory  \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u5148\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u540d\n *\/\nfunction checkDirectory(directory) {\n  \/\/\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u30c1\u30a7\u30c3\u30af\u3001\u30b9\u30e9\u30c3\u30b7\u30e5\u59cb\u307e\u308a\u30fb\u30b9\u30e9\u30c3\u30b7\u30e5\u7d42\u308f\u308a\u304b\u3069\u3046\u304b\n  const regex = \/^\\\/.*\\\/$\/;\n  if (!(regex.test(directory))) {\n    throw "Invalid directory";\n  }\n}\n\n\/**\n * \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3088\u3046\u3068\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u6570\u30fb\u30b5\u30a4\u30ba\u304c\u9069\u5207\u304b\u3069\u3046\u304b\u30c1\u30a7\u30c3\u30af\n * @param {Array<File>} files  \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3088\u3046\u3068\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u914d\u5217\n * @param {ProcessDataDefinitionView} idDataDef  ID \u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView\n * @param {ProcessDataDefinitionView} urlDataDef  URL \u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView\n *\/\nfunction checkFile(files, idDataDef, urlDataDef) {\n  const fileNum = files.size(); \/\/number of files\n  if (fileNum > httpClient.getRequestingLimit()) {\n    throw "Number of requests is over the limit";\n  }\n\n  \/\/1\u3064\u3067\u3082\u30d5\u30a1\u30a4\u30eb\u30b5\u30a4\u30ba\u30aa\u30fc\u30d0\u30fc\u3042\u3063\u305f\u3089\u4e2d\u6b62\n  files.forEach(file => {\n    engine.log(`Uploading: ${file.getName()}`);\n    if (file.getLength() > SIZE_LIMIT) {\n      throw "There is a file over the size limit";\n    }\n  });\n\n  checkfileNum(idDataDef, fileNum);\n  checkfileNum(urlDataDef, fileNum);\n}\n\n\/**\n * \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u304c\u8907\u6570\u3067 \u30d1\u30b9\u30fbURL \u51fa\u529b\u5148\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u5358\u4e00\u884c\u306a\u3089\u30a8\u30e9\u30fc\u306b\u3059\u308b\n * @param {ProcessDataDefinitionView} dataDef  \u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView\n * @param {Number} fileNum  \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3088\u3046\u3068\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u500b\u6570\n *\/\nfunction checkfileNum(dataDef, fileNum) {\n  if (dataDef !== null) {\n    \/\/Multiple Judge\n    if (dataDef.matchDataType("STRING_TEXTFIELD") && fileNum > 1) {\n      throw "Multiple files are set though the Data Item to save the output is Single-line String."\n    }\n  }\n}\n\n\/**\n * \u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3002\u4e00\u56de\u306b\u3064\u304d\u4e00\u3064\u306e\u307f\u3002\n * @param {String} oauth2  OAuth2 \u8a2d\u5b9a\n * @param {File} file  \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u30d5\u30a1\u30a4\u30eb\n * @param {String} directory  \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u5148\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u540d\n * @param {Array<Array<String>>} uploadedFileData  \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u306e\u60c5\u5831\u3092\u683c\u7d0d\u3059\u308b\u4e8c\u6b21\u5143\u914d\u5217\n * @param {Boolean} isOverWrite  \u540c\u540d\u30d5\u30a1\u30a4\u30eb\u3092\u4e0a\u66f8\u304d\u3059\u308b\u304b\n *\/\nfunction upload(oauth2, file, directory, uploadedFileData, isOverWrite) {\n\n  const uri = "https:\/\/content.dropboxapi.com\/2\/files\/upload";\n  let json;\n  if ( isOverWrite ) {\n    json = '{"path": "' + directory + escaper.escapeJson(file.getName()) + '", "mode": "overwrite"}';\n  } else {\n    json = '{"path": "' + directory + escaper.escapeJson(file.getName()) + '"}';\n  }\n  \/\/engine.log("json:"+json);\n\n  let response = httpClient.begin()\n    .authSetting( oauth2 )\n    .header( "Dropbox-API-Arg", json )\n    .body( file, "application\/octet-stream" )\n    .post( uri );\n  engine.log("---POST request--- " + response.getStatusCode());\n  const responseString = response.getResponseAsString();\n  engine.log(responseString);\n\n  const status = response.getStatusCode();\n  if( status >= 300 ){\n    engine.log("Failed to upload status:" + status);\n    throw `Failed to upload\\nstatus: ${status}\\nfile: ${file.getName()}`;\n  }\n  engine.log("upload successful");\n  addOutputToArray(responseString, uploadedFileData);\n}\n\n\/**\n * \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u30c7\u30fc\u30bf\u306eID\u3068URL\u3092\u914d\u5217\u306b\u30bb\u30c3\u30c8\u3059\u308b\u3002\n * @param {String} responseStr  \u9001\u4fe1\u6642\u306e\u30ec\u30b9\u30dd\u30f3\u30b9\u3092\u30c6\u30ad\u30b9\u30c8\u51fa\u529b\u3057\u305f\u3082\u306e\n * @param {Array<String>} uploadedFileData  \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u306e\u60c5\u5831\u304c\u683c\u7d0d\u3055\u308c\u308b\u914d\u5217\n *\/\nfunction addOutputToArray(responseStr, uploadedFileData) {\n  const json = JSON.parse(responseStr);\n  uploadedFileData[0].push(json.id);\n  uploadedFileData[1].push(`https:\/\/www.dropbox.com\/home${json.path_display}`);\n}\n\n\/**\n * \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u30c7\u30fc\u30bf\u306e\u30d1\u30b9\u3068URL\u3092\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u51fa\u529b\u3059\u308b\u3002\n * @param {ProcessDataDefinitionView} dataDef  \u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView\n * @param {Array<String>} uploadedFileData  \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u306e\u60c5\u5831\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u914d\u5217\n *\/\nfunction setData(dataDef, uploadedFileData) {\n  if (dataDef !== null) {\n    engine.setData(dataDef, uploadedFileData.join('\\n'));\n  }\n}\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n