How to Upload and Download Files to and from kintone

File transfer between kintone and Questetra through API

 

The other day, I was asked about how to configure Questetra to exchange files with kintone. Here, I want to summarize my solution.
 
kintone_qbpms_file
 


As explained in the following articles, you are required to:
Retrieve record data and obtain a file key from it → Call the Download File API with the aforementioned file key

“kintone REST API: Download File”
 
To configure these procedures in Questetra, the following settings are required:

  • Retrieving record data in a “Throwing Message Intermediate Event (HTTP)”
  • Extracting file Key out of the response
  • Download file in a “Throwing Message Intermediate Event (HTTP)”

 
A sample Process Model is shown below.
download file
 
* You can use an add-on for communicating with kintone, as described in a previous article .
 
Download the archive here (.qar file is zipped)
kintone_download

 


As explained in the following aticles, you are required to:
Call the Upload File API and obtain a file key → Associate the obtained file with the record

“kintone REST API: Upload File”
 
To configure those procedures in Questetra, the following settings are required.

  • Upload a file in “Throwing Message Intermediate Event (HTTP)”
  • Extracting file Key out of the response
  • Preparing JSON data for updating the record
  • Updating the record information in “Throwing Message Intermediate Event (HTTP)”

 
A sample Process Model is shown below.
upload file
 
* Even though the Parameter name for file uploading is not mentioned in kintone’s reference API, it worked well with “file”.
* Please note that although JSON data is prepared in “Service Task” (Data Assignment), there will be problems in cases where you must consider escaping, such as when containing double quotations or line breaks.
 
Download the archive here (.qar file is zipped)
kintone_upload

 

Questetra Ver. 11.0.0 has enhanced API functions to become capable to connect with more Cloud services, including kintone. I hope you improve business efficiency by connecting with various Cloud services with Questetra.

 

About Kusaka Tsuyoshi

営業をやってますが、もともとエンジニアなので、プログラミングもやります。
View all posts by Kusaka Tsuyoshi

Recommendations
Prev article - 50. Questetra Tips A Sample for Developers: Add-on for API Connection with kintone
Next article - 50. Questetra Tips What is Budget Management for Eliminating Over-budget Approval Request?
Another article - Kusaka Tsuyoshi Handle Script Step Well! : Solution for Error (1)

Archive

 RSS