How to upload attachments via workflow or API
Users can write documents or images to the worksheet via workflow or API, if workflow, it supports URL only; if API, it supports two methods, both URL and Base64.
I. Upload Attachments via Workflow
The workflow triggered by Webhook receives external data to add to the worksheet or update the data in worksheets, and can upload attachments at the same time.
In the [Add Record] node or [Update Record] node of the workflow, the content passed in the attachment field must be a Json string consisting of one or more file addresses.
When uploading a file, the format is: url1 or ["url1"], for example:
https://help.nocoly.com/logo.png
or["https://help.nocoly.com/logo.png"]
When uploading multiple files, it must be in the format of : ["url1", "url2"], for example:
["https://help.nocoly.com/logo.png","https://help.nocoly.com/img/introduction.mp4"]
.
Workflow Configuration
If you want to upload attachments via the [Add Record] node or [Update Record] node, select the text field as the file field.
For example, in the worksheet below, write the download link of the file to a text field [Download Link] first, and then through the workflow, automatically download and save it to the [File] field.
1. Configure the trigger node
2. Write the download link to file field
3. Test
Write the download link into the field in the correct format. Just copy the following content directly (including []).
["https://help.nocoly.com/logo.png","https://help.nocoly.com/img/introduction.mp4"]
II. Upload Attachments via API
More details are in the figure below.
Parameter Introduction
{
controlId: //ID of the file control;
"value": //Links to external files. If there are multiple files, separate them with English commas;
"editType":0 //Data update type. 0-Overwrite existing file; 1-Add current file (Default: 0-Overwrite. This parameter may not be passed for new records, but is required for updated records);
"valueType":1//Ways to upload files. 1-external file link; 2-file stream byte-encoded base64 string (Default: 1. When it is 1, the external link is placed in the value parameter; when it is 2, the file stream base64 information is placed in the controlFiles parameter below);
"controlFiles":[{
"baseFile":"QABAAQQQAAG9nCwAAAA==", //base64 string (file stream byte encoding);
"fileName":"File name with suffix.xlsx" //File name with suffix;
}]
}
URL-Example
If uploading 1 file, the value assigned to the attachment field is "url1", for example,
"https://help.nocoly.com/logo.png"
If uploading multiple files, the format is "url1,url2", for example,
"https://help.nocoly.com/logo.png,https://help.nocoly.com/logo.png"
.
{
"appKey": "0a265**3a155de01",
"sign": "ZmFkZjExMmNlY***NDA4ZjI5N2YxZDEwMjlkZWNkOTRkNTg5NjBkYWQzOTYxYjgwMWM4ZDg5NzYwOGMxZjZmOA==",
"worksheetId": "61111f2eb94**ac37d7d6e",
"controls": [
{
"controlId": "61111f2eb94aac37d7d6f",
"value": "Test"
},
{
"controlId":"61111f2eb10caac37d7d71",
"value":"https://help.nocoly.com/logo.png",
"editType":0,
"valueType":1//Setting1
}
]
}
Base64 File Stream - Example
{
"appKey": "0a265**3a155de01",
"sign": "ZmFkZjExMmNlY***NDA4ZjI5N2YxZDEwMjlkZWNkOTRkNTg5NjBkYWQzOTYxYjgwMWM4ZDg5NzYwOGMxZjZmOA==",
"worksheetId": "61111f2eb94**ac37d7d6e",
"controls": [
{
"controlId": "61111f2eb94aac37d7d6f",
"value": "Test"
},
{
"controlId":"61111f2eb10caac37d7d71",
"editType":0,
"valueType":2,//Setting2
"controlFiles":[
{
"baseFile":"QABAAQQQAAG9nCwAAAA==",
"fileName":"File name with suffix.xlsx"
}]
}
]
}
Possible Timeout Issues
If you are using the interface for adding records in bulk and need to upload attachments at the same time, you may encounter the timeout problem because you need to wait until the attachments are uploaded before the successful status is returned.
Suggested Method
Write the URL of the attachment to a text field first to ensure that the basic data can be written quickly, and then upload the attachment through the workflow. See the example above for more details.
III. Comparison of Writing Attachments via API and Workflow
The main difference is the format of the file address.
The format in the workflow is: ["url1", "url2"].
The format in the API is: "url1,url2".
IV. Format of URL
- The URL of the attachment must be accessible by the server of HAP.
- Attachments can be downloaded and saved directly through the URL.
- The end of the URL must be the extension.
Correct URL:
Have questions about this article? Send us feedback