{"id":143130,"date":"2023-03-02T17:21:38","date_gmt":"2023-03-02T08:21:38","guid":{"rendered":"https:\/\/support.questetra.com\/?p=143130"},"modified":"2023-03-02T17:21:40","modified_gmt":"2023-03-02T08:21:40","slug":"climber-webinvoice-file-upload","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/climber-webinvoice-file-upload\/","title":{"rendered":"ClimberCloud: Upload Web Invoice File"},"content":{"rendered":"\n

ClimberCloud: Upload Web Invoice File<\/strong><\/h4>\n\n\n\n

ClimberCloud: Upload Web Invoice File<\/a><\/p>\n\n\n\n

Uploads a ClimberCloud Web Invoice file to a specified content ID in ClimberCloud.
* ClimberCloud\u00ae is a registered trademark of NTT DATA Business Brains Corporation.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
conf_TenantId<\/dt>
C1: Tenant ID *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_ApiKey<\/dt>
C2: API Key *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_PdfFile<\/dt>
C3: Invoice PDF file to be uploaded (fixed to one file) *<\/span><\/dd>\n
conf_ListIndexNames<\/dt>
C4: Column names (separated by semicolons) to be added to the search attribute *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_ListIndexData<\/dt>
C5: Data to be added to search attributes (separated by semicolons) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_CustomerId<\/dt>
C6: Business partner ID to whom invoices should be sent *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_Subject<\/dt>
C7: Subject of invoice *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_isAutoRelease<\/dt>
C8: Do you want to automatically publish invoices?<\/dd>\n
conf_ContentsId<\/dt>
C9: Content ID of the upload destination *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_log<\/dt>
X: Data Items to be stored in communication log (update)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\n\nmain();\nfunction main(){\n\/\/\/\/ == Config Retrieving ==\nconst tenantId         = configs.get( "conf_TenantId" ) + "";\nconst apiKey           = configs.get( "conf_ApiKey" ) + "";\nconst contentsId       = configs.get( "conf_ContentsId" ) + "";\n\nconst listIndexNames   = configs.get( "conf_ListIndexNames" ) + "";\nconst listIndexData    = configs.get( "conf_ListIndexData" ) + "";\nconst customerId       = configs.get( "conf_CustomerId" ) + "";\nconst subject          = configs.get( "conf_Subject" ) + "";\n\nconst isAutoRelease = configs.getObject( "conf_isAutoRelease" );\n\nconst dataId_pdfFile   = configs.get( "conf_PdfFile" );\nconst dataId_log       = configs.get( "conf_log" );\n\n\n\/\/\/\/ == Calculating ==\nif ( tenantId == "" ) {\n  throw `Tenant ID none.`;\n}\nif ( apiKey == "" ) {\n  throw `API key none.`;\n}\nif ( contentsId == "" ) {\n  throw `Contents ID none.`;\n}\nif ( customerId == "" ) {\n  throw `Customer ID none.`;\n}\nif ( subject == "" ) {\n  throw `Subject none.`;\n}\n\nlet arrayListIndexNames = listIndexNames.split(";");\nlet arrayListIndexData = listIndexData.split(";");\nif (arrayListIndexNames.length != arrayListIndexData.length) {\n  throw `List Index length not equal.`;\n}\n\nlet accessLog = "";\n\n\n\/\/File Base64 conversion\n\/\/Maximum file size is 10 MB\nconst files = engine.findDataByNumber( dataId_pdfFile );\nlet base64Text = "";\nif (( !files ) || ( files.length != 1 )) {\n  throw `PDF File Num invalid.`;\n}\nconst file = files.get(0);\/\/1 file fixed\nif ( file.getLength() > 10485760 ) {\n  throw `PDF File size over.`;\n}\nfileRepository.readFile(file, 10485760, function(bytes) {\n  base64Text += base64.encodeToString(bytes);\n});\n\/\/engine.log("base64Text:" + base64Text);\n\nlet isAutoReleaseValue = 0;\nif (isAutoRelease) {\n  isAutoReleaseValue = 1;\n}\n\n\n\/\/JSON generation\nlet indexObjects = [];\nfor ( let i = 0; i < arrayListIndexNames.length; i++) {\n  let indexName = arrayListIndexNames[i];\n  let indexData = arrayListIndexData[i];\n  let indexObject = {};\n  indexObject.KeyName = indexName;\n  indexObject.KeyData = indexData;\n  indexObjects.push( indexObject );\n}\n\nlet fileObjects = [];\nlet fileObject = {};\nfileObject.file_data = base64Text;\nfileObject.file_name = file.getName();\nfileObjects.push( fileObject );\n\nlet requestObj = {};\n  requestObj.contents_id = contentsId;\n  requestObj.customer_id = customerId;\n  requestObj.subject = subject;\n  requestObj.is_auto_release = isAutoReleaseValue;\n  requestObj.listIndex = indexObjects;\n  requestObj.listFile = fileObjects;\n\/\/engine.log("json:" + JSON.stringify(requestObj));\n\n\n\/\/API call\nconst uri = "https:\/\/api.climber-cloud.jp\/api\/ContractPdf";\nlet response = httpClient.begin()\n  .header( "X-Tenant", tenantId )\n  .header( "X-ApiKey", apiKey )\n  .body( JSON.stringify(requestObj), "application\/json" )\n  .post( uri );\naccessLog += "---POST request--- " + response.getStatusCode() + "\\n";\naccessLog += response.getResponseAsString() + "\\n";\nengine.log("res:" + response.getResponseAsString());\n\nconst status = response.getStatusCode();\nif( status >= 300 ){\n  engine.log(accessLog);\n  throw `Failed in POST request. status: ${status}`;\n}\n\n\n\/\/API call result confirmation\nconst jsonObj = JSON.parse( response.getResponseAsString() );\nconst isSuccess = jsonObj.isSuccess + "";\nengine.log("isSuccess:" + isSuccess);\nif ( isSuccess !== "0") {\n  const message = jsonObj.message + "";\n  engine.log("message:" + message);\n  throw `Failed in request. isSuccess: ${isSuccess} message: ${message}`;\n}\n\n\n\/\/\/\/ == Data Updating ==\nif ( dataId_log !== "" ) {\n  engine.setDataByNumber( dataId_log, accessLog );\n}\n\n}\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n