DragOnce runtime API enables your application to interact with data stored in DragOnce. Through the RESTful API provided, developers can create, query, remove, modify and trigger pre-defined business rules. To facilitate the integration, different identifiers have been provided throughout the application management panel, including but not limited to storage IDs (equivalent to page and form IDs), column IDs (equivalent to widget IDs) and business rules ID (equivalent to workflow IDs).
API keys and related info are required before using DragOnce Runtime API. Please follow the steps below to obtain the required info.
Navigate to "Administration Panel" in DragOnce
Navigate to "API Key" UI (If this page is not available, please contact support)
Click on "New" button
Select a target user
Click on "New API Key" to generate key
Configure the API & Environment Scope for the generated key
Copy and save the required info (E-Mail, Subscriber ID, API Key(s)) on the screen
Note: The API Key will be masked after save. It is important to keep it for further use.
Click "Save" (The keys are not truly activated before save.)
IDs are required before performing runtime action. Please follow the steps below to obtain the required info.
Navigate to "App Management" in DragOnce
Click on "ID" button between "Company logo" and "Side menu"
Select at "Side menu" to navigate between App IDs List and Environment IDs List
Navigate to "App Management" in DragOnce
Select a target App
Click on "ID List" button at "Side menu"
Select tabs at the top of the page to navigate between "Page IDs List", "Workflow IDs List" and "Report IDs List"
Widget IDs
Page IDs List => Page
Available Dropdown Options
Page IDs List => Page => Dropdown Widget
Form Validation Rule IDs
Page IDs List => Page => Form Widget
Table Column IDs
Page IDs List => Page => Table Widget
State IDs
Workflow IDs List => Workflow
Edge IDs
Workflow IDs List => Workflow
Edge Validation IDs
Workflow IDs List => Workflow => Edge
Report Parameter IDs
Report IDs List => Report
This API allows creating a new single record. Please follow the steps below.
Prepare IDs and parameters described in Init Record
Execute the network request (Init Record) to retrieve temporary record ID ( tmp_record_id )
(Optional) Use the above tmp_record_id to perform Upload File/ Upload Image
Prepare the parameters described in Commit Form Record
Execute the network request: Commit Form Record
To retrieve records through table widget. Please follow the steps below.
Prepare IDs and parameters as described in List Table Record
Note: If need to retrieve records from other pages. Only the parameter page_number and list_mode can be changed.
Apply the IDs
Execute the network request
To retrieve a single record through the form widget. Please follow the steps below.
Prepare IDs and parameters as described in Get Form Record
Apply the IDs and parameters
Execute the network request: Get Form Record
This API allows updating one single record. Please follow the steps below.
Prepare the record ID of the target record
Prepare the parameters described in Commit Form Record
Execute the network request: Commit Form Record with the record ID ( record_id )
Prepare the record ID of the target record
Prepare IDs and parameters described in Init Record
Execute the network request (Init Record) with the record ID ( record_id ) to retrieve temporary record ID ( tmp_record_id ) for the target record
(Optional) Use the above tmp_record_id to perform Upload File / Upload Image
Prepare the parameters described in Commit Form Record
Execute the network request: Commit Form Record with the temporary record ID ( tmp_record_id )
This API allows deleting one or multiple records. Please follow the steps below.
Prepare the required IDs and parameters as described in Delete Form Record
Apply the IDs
Execute the network request: Delete Form Record
This is the documentation for DragOnce Runtime API.
Base Path: api.DragOnce.intra
Version: v1
Full Path: https://api.DragOnce.intra/v1
The following headers are required in every request made to this API.
X-DragOnce-API-Key
API Key generated in DragOnce Admin Panel.
X-DragOnce-Email
E-mail associated with the above API Key.
X-DragOnce-Subscriber-ID
Subscriber which account of above E-mail belongs to.
su_enable
string (optional)
If this key is present in the request parameter, this request will try to process using super admin mode in DragOnce. Only presence is checked and value is always ignored.
su_on_behalf
string (optional)
To use this key, the su_enable key must present in request.
If this key is present in request, the request will try to process using super admin on behalf mode in DragOnce.
The value of this key is the user ID of the user which the request should on behalf of.
URL: POST: /runtime/file/upload
Upload a file to a form record.
Request:
Type: multipart/form-data
Parameters:
environment
string
If this key is present in the request parameter, this request will try to process using super admin mode in DragOnce. Only presence is checked and value is always ignored.
developing, ENV123456, production, etc.
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
widget_id
string
Widget ID of the file uploader.
R_123456
record_id
string
Record ID of the target record.
(Pass the real record_id if for existing record; tmp_record_id , which returned when Init Form Record, for new record)
123456789012345678901234
form_id
string
Form that contains the file uploader.
R_123456
file
string
Form that contains the file uploader.
Response:
Type: application/json
file_id
string
The file id of the uploaded file used in DragOnce. This file id can be used in commit form operation to present it on records.
file_id
string
The file id of the uploaded file used in DragOnce. This file id can be used in commit form operation to present it on records.
Example:
{
"file_id": "123456789xxxxxx"
}
URL: POST: /runtime/file/download
Download specific file with file ID.
Request:
Type: application/x-www-form-urlencoded
Parameters:
environment
string
Environment that this API call is targeting.
developing , ENV123456 , production , etc.
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
widget_id
string
Widget ID of the file uploader.
R_123456
file_id
string
File ID of the target file.
123456789012345678901234
Response:
Type: image/png , application/pdf , etc. (Depends on the file)
N/A
file
A file response with Content-Disposition: attachment header.
Upload Image
URL: POST: /runtime/image/upload
Upload an image to a form record.
Request:
Type: multipart/form-data
Parameters:
environment
string
Environment that this API call is targeting.
developing , ENV123456 , production , etc.
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
widget_id
string
Widget ID of the image uploader.
R_123456
record_id
string
Record ID of the target record.
(Pass the real record_id if for existing record; tmp_record_id , which returned when Init Form Record, for new record)
123456789012345678901234
form_id
string
Form that contains the image uploader.
R_123456
image
string
Local image that will be uploaded.
Response:
Type: application/json
image_id
string
The image id of the uploaded file used in DragOnce. This image id can be used in commit form operation to present it on records.
Example:
{
"image_id": "123456789xxxxxx"
}
URL: POST: /runtime/image/download
Download an image with a given image ID.
Request:
Type: application/x-www-form-urlencoded
Parameters:
environment
string
Environment that this API call is targeting.
developing , ENV123456 ,
production , etc.
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
image_id
string
Image ID of target image.
123456789012345678901234
widget_id
string
Widget ID of the image uploader.
R_123456
form_id
string
Form that contains the image uploader.
R_123456
record_id
string
Record ID the image is uploaded to.
123456789012345678901234
image_size
string (optional)
Size for response image in px.
The response image will be an aspect fit square rect in given size.
An image of 300x200 with image_size of 150 will become 150x100.
Missing / original will result in original size. Default: original
original , 150 , 800 , etc
Response:
Type: image/png , image/jpeg , etc. (Depends on the file)
N/A
file
A file response with Content-Disposition: attachment header.
URL: POST: /runtime/report/download
Generate and download a report.
Request:
Type: application/x-www-form-urlencoded
Parameters:
environment
string
Environment that this API call is targeting.
developing , ENV123456 , production , etc.
app
string
App that contains the form.
App123456
report_id
string
ID of the report.
NR123456
report_params
string
(json object)(optional)
A stringify JSON object which contains following key-value pairs. {Parameter Key}: {Value} The format of each parameter type as follows:
{
"P_strxxx": "My Dynamic Report Title","P_numxxx": 123.45,
"P_dtxxxx": 1502954495000,
"tz_P_dtxxxx": "522",
"P_datexx": 1501545600000,
"P_timexx": 86399000,
"P_userxx":["u1234567890","u2345678901"], "P_dataid": "1234567890xxxxxx"
}
N/A
file
A file response with Content-Disposition: attachment header.
URL: POST: /runtime/record/list/table
List the records in a specific table.
Request:
Type: application/x-www-form-urlencoded
Parameters:
environment
string
Environment that this API call is targeting.
developing , ENV123456 , production , etc.
app
string
App that contains the table.
App123456
page
string
Page that contains the table.
Page123456
table_id
string
Table ID of the target table.
R_123456
page_number
integer (optional)
Page Number that you want to retrieve.
Default: 1
1
page_size
integer (optional)
Page Size that you want to retrieve.
Default: 10
50
sort_by_field
string (optional)
Field used for sorting the records. The value should be one of the column ids. Only one field can be used.
createTime
sort_by_desc
string (optional)
Is the record sorted in descending order. Default is in ascending order, set to 1 for sort in descending order.
1
ref_form_id
string (optional)
Reference Form ID which the reference table is pointing at. This field is used only when retrieving reference table records.
R_123456
form_id
string (optional)
Form ID that contains the reference table. This field is used only when retrieving reference table records.
R_123456
record_id
string (optional)
Record ID that contains the reference table. This field is used only when retrieving reference table records.
123456789012345678901234
table_filter
string
(json object)
(optional)
Filter used in the table/reference table. It is a key-value pair object where key is the widget id and value is the filter value.
{
"R_123456": "filter" }
list_mode
string (optional)
Specific response to return original / formatted data, or both.
Note: For formatted / both , only data which will shown on table are formatted, those that are not shown will be sent as original data.
Default: original
original / formatted / both
Response:
list_mode: both
Type: application/json
data
array
Array of Records. See Record Model below for details.
original_data
array
Array of Records. See Record Model below for details.
{
"data": [
/* Record 1 */,
/* Record 2 */
],
"original_data": [
/* Record 1 (Original) */,
/* Record 2 (Original) */
]
}
list_mode: formatted / original
Type: application/json
N/A
array
Array of Records. See Record Model below for details.
[
/* Record 1 */,
/* Record 2 */
]
Type: application/json
record_id
string
ID of the given record.
workflow
string
ID of the workflow state of the given record.
owner
string
Owner's user ID of the given record.
leb
string
Last edited by user ID of the given record.
let
object
Last edit time of the given record.
createTime
object
Creation time of the given record.
emailStatus
string (optional)
Email Status of the given record. Only for list_mode: formatted . See Email Status below for details.
Column Ids
any
Value of the column.
Example:
Formatted:
{
"record_id": "59a3f67c3a0e6709e803b695",
"workflow": "Waiting to Approve",
"owner": "kelvin",
"leb": "kelvin",
"let": "21/09/2017 03:26 下午 +08:00",
"createTime": "28/08/2017 06:54 下午 +08:00",
"emailStatus": "No Request",
"R_5ch97t": "100",
"R_mlk8th": "b"
}
Original:
{
"record_id": "59a3f67c3a0e6709e803b695",
"workflow": "Wx07bu6h",
"owner": "u1234567890",
"leb": "u2345678901",
"let": {
"sec": 1505978784,
"usec": 25000
},
"createTime": {
"sec": 1503917693,
"usec": 59000
},
"R_5ch97t": 100,
"R_mlk8th": "b"
}
Formatted, createTime & leb are not selected to shown in DragOnce:
{
"record_id": "59a3f67c3a0e6709e803b695", "workflow": "Waiting to Approve",
"owner": "kelvin",
"leb": "u2345678901",
"let": "21/09/2017 03:26 下午 +08:00", "createTime": {
"sec": 1503917693,
"usec": 59000
},
"emailStatus": "No Request",
"R_5ch97t": "100",
"R_mlk8th": "b"
}
URL: POST: /runtime/record/get
Get a specific record in one form.
Request:
Type: application/x-www-form-urlencoded
Parameters:
Key Type Description Example
environment
string
Environment that this API call is targeting.
developing , ENV123456 , production , etc.
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
form_id
string
Form ID of the target record.
R_123456
record_id
string
Record ID of the target record.
123456789012345678901234
Response:
success
Type: application/json
record_id
string
ID of the given record.
workflow
string
ID of the workflow state of the given record.
owner
string
Owner's user ID of the given record.
leb
string
Last edited by user ID of the given record.
let
object
Last edit time of the given record.
createTime
object
Creation time of the given record.
workflow_timestamp
object
Last workflow action time of the given record.
unique_key
integer
Unique key of the given record.
delegated_to
object
The given record has been delegated to which user by who.
widget ids
string
Data of the widgets in the record. All the data will be in raw (non-translated) format.
Example:
{
"record_id": "599c0c0f3a0e67091828b035",
"workflow": "W1234567",
"owner": "u1234567890",
"let": {
"sec": 1503541326,
"usec": 999000
},
"createTime": {
"sec": 1503398927,
"usec": 459000
},
"R_5ch97t": 1,
"R_mlk8th": "2",
"leb": "u2234567890",
"workflow_timestamp": {
"sec": 1503398927,
"usec": 459000
},
"unique_key": 16,
"delegated_to": {
"u2234567890": "u1234567890"
}
}
URL: POST: /runtime/record/delete
Delete records from form.
Request:
Type: application/x-www-form-urlencoded
Parameters:
environment
string
Environment that this API call is targeting.
developing , ENV123456 , production , etc.
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
record_id
array
Record ID(s) to be deleted.
record_id[]=123456789012345678901234& record_id[]=432156789012345678901234
success
Type: application/json
successful
int
Number of records successfully deleted.
failed
int
Number of records failed to delete.
Example:
{
"successful": 1,
"failed": 0
}
URL: POST: /runtime/record/init
Initialize the record in a specific form for further action. This call is a must before committing the record with mode: save , workflow , discard .
Request:
Type: application/x-www-form-urlencoded
Parameters:
environment
string
Environment that this API call is targeting.
developing , ENV123456 ,
production , etc.
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
form_id
string
Form id of the target record.
Page1234R_12345656
record_id
string (optional)
Record id of the existing record. Needed when getting a temporary record of an existing record.
123456789012345678901234
Response:
success
Type: application/json
tmp_record_id
string
Temporary Record ID for part of the commit actions.
unique_key
int (optional)
Unique key of the current record if record_id is provided.
Example:
{
"tmp_record_id":"59a3ec3a3a0e6702791cf238",
"unique_key":17
}
URL: POST: /runtime/record/commit
Add or update the record in a specific form.
Request:
Type: application/x-www-form-urlencoded
Parameters:
action
string
The action you want to do with the record. Available options are: save , workflow , delegate , undelegate , discard , undo or withdraw.
save , workflow ,
delegate , etc.
environment
string
Environment that this API call is targeting.
developing , production
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
record_id
string
(optional)
Record ID of the target record. This field is required if the action is delegate , undelegate , undo or withdraw.
123456789012345678901234
tmp_record_id
string
(optional)
Temporary Record ID of the target record.Retrieved by calling init form record. This field is required if the action is save , workflow or discard.
123456789012345678901234
form_id
string
(optional)
Form id of the target record. This field is required if the action is saved , workflow or discarded.
R_123456
workflow_id
string
(optional)
Workflow Action (Edge) ID of the target action. This field is required if the action is workflow . Empty workflow id will consider as save action.
E1234567
data
string
(json object) (optional)
Data of the widgets in target record. Accept the field only when the action is saved or workflow
{
"R_123456": "1"
"R_abcdef": 2
}
delegate_user
string
(optional)
The user id of the delegate user. This field is required if the action is delegated.
u1234567
Response:
Success
Type: application/json
status
string
The result of the commit action. Return only
when the commit
action is successful.
"ok"
RError
string
(optional)
The description of the commit error. Return only when the commit action is failed.
"Reference Error"
validation
Object (optional)
The error of the current workflow validation. The action invalidates the validation rules defined in the form. Return only when the commit action is failed.
"ok"
workflow_validation
Object (optional)
The error of the current workflow action. The action invalidate the
validation rules defined in the workflow edge. Return only when the commit action is
failed.
"required": {
"e": true,
"t": "1",
"i": {
"R_wt2ryg": "1"
},
"m": "Input Box should not be empty for the action: "
}
Example:
{
"status": "ok"
}
URL: POST: /runtime/record/create
Create the record in a specific form.
Note that this action is a convenient method to wrap up the action Create Record and does not support file upload.
Request:
Type: application/x-www-form-urlencoded
Parameters:
action
string
The action you want to do with the record. Available options are: save , workflow.
save
environment
string
Environment that this API call is targeting.
developing ,
production
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
form_id
string
(optional)
Form id of the target record.
R_123456
workflow_id
string
(optional)
Workflow Action (Edge) ID of the target action. This field is required if the action is workflow . Empty workflow id will consider as save action.
E1234567
data
string
(json object)
(optional)
Data which needs to be translated before saving in the target record. See Data Translation Object for details.
Response:
Success
Type: application/json
success
integer
The success result count of the action.
123
failed
integer
The failed result count of the action.
123
errors
array (optional)
The error occurred between the process for each failed result. The key will not be sent if no error occurred.
[ "Error Msg 1", "Error Msg 2" ]
Example:
{
"success": 5,
"failed": 2,
"errors": [
"Error Msg 1",
"Error Msg 2"
]
}
URL: POST: /runtime/record/update
Update the record in a specific form.
Note that this action is a convenient method to wrap up the action Update Record and does not support file upload.
Request:
Type: application/x-www-form-urlencoded
Parameters:
action
string
The action you want to do with the record. Available options are: save , workflow.
save
environment
string
Environment that this API call is targeting.
developing , production
app
string
App that contains the form.
App123456
page
string
Page that contains the form.
Page123456
record_id
string (optional)
Record ID of the target record.
123456789012345678901234
form_id
string (optional)
Form id of the target record.
R_123456
workflow_id
string (optional)
Workflow Action (Edge) ID of the target action. This field is required if the action is workflow. Empty workflow id will consider as save action
E1234567
data
string
(json object)
(optional)
Data of the widgets in target record.
{
"R_123456": "1"
"R_abcdef": 2
}
data_trans
string
(json object)
(optional)
Data which needs to be translated before saving in the target record.
See Data Translation Object for details.
record_id_by_value
string
(json object)
(optional)
idget value for searching the target record.
record_id_by_value will be ignored if
record_id is not empty.
See Record ID By Value Object for details.
Response:
Success
Type: application/json
success
integer
The success result count of the action.
123
failed
integer
The failed result count of the action.
123
errors
array
(optional)
The error occurred between the process for each failed result. The key will not be sent if no error occurred.
[ "Error Msg 1", "Error Msg 2" ]
Example:
{
"success": 5,
"failed": 2,
"errors": [
"Error Msg 1",
"Error Msg 2"
]
}
URL: GET: /translate/staff
Get a list of staff record(s) matching given criteria(s).
In order to use this API, your user type must be Root Administrator / HR.
Request:
Type: Query Parameters
Parameters:
The request must contain at least one of the following criteria: user_id, login_email, staff_id, username, description.
environment
string
Environment that this API call is targeting.
developing , ENV123456 , production , etc.
user_id
string
The user ID returned in form data, etc.
u1234567890
login_email
string
The login E-mail used by the user.
user@company.com
staff_id
string
The staff ID field content in user's info.
s20170101
username
string
The username field content in user's info.
testing_user
description
string
The description field content in user's info. The comparison is done ignoring the case.
I am a testing user
Response:
array
Array of JSON objects containing user(s) info that match given criteria.
Structure for each JSON object in array:
Example:
[
{
"time": 1503907200000,
"hourly_usage": {
"count": 1,
"data_in": 0,
"data_out": 0.0001234
}
},
{
"time": 1503910800000,
"hourly_usage": {
"count": 2,
"data_in": 0.0002345,
"data_out": 0
}
}
]
If an error occurs during a request, a DragOnce_error key must be returned in response, and the response type must be application/json .
In addition, a DragOnce_error_description may also provide for a more detailed description of the error. In the format of:
{
"DragOnce_error": "some_key",
"DragOnce_error_description": "Description of error."
}
invalid_param
Invalid / Missing parameter(s).
The API did not receive enough parameter to process the request or some parameter(s) are invalid.
Note this error also apply to missing headers.
invalid_key
Invalid API Key provided.
The API received the given API Key in header, but cannot pass the validation.
invalid_api_scope
The given API is not allowed to access this API.
The request try to access this API without granting permission in DragOnce Admin Panel.
invalid_env_scope
The given API is not allowed to access this environment.
The request tries to access an environment without granting permission in the DragOnce Admin Panel.
usage_exceed_limit
The given API has exceeded usage limit.
Hourly / Day usage limit exceeded.
upload_failed
The upload task could not be completed.
The upload task could not be completed.
download_failed
The download task could not be completed.
The download task could not be completed.
form_validation_failed
Some of the value does not pass the form validation.
Please refer to the requirements of your company for more detail, and make sure the values passed are valid.
invalid_form_commit_action
The commit action
'{some_action}' does not exist.
The string passed as action does not match any of the predefined keys. Please refer to the Commit Form Record for allowed actions.
system_down
DragOnce is down for
maintenance. Please try again later.
DragOnce is down for maintenance.
unknown_error
Unknown errors occur. Please contact support to report this issue.
Please contact support to report this issue.
This is the properties used / returned in DragOnce Runtime API.
Widget Value Definition
The following are the value formats which must follow when using DragOnce API for form operations.
Input Box, Auto-
Complete
String
string
Input Box, Auto-
Complete
Integer
int
Input Box, Auto-
Complete
Percent
double
This value indicates the real value of the percentage. i.e. 12.3% will pass as 0.123
Selection Box,
Dropdown Menu
Use Widget Values From Other Form
string
The record ID which contains the value in the selected field.
Selection Box,
Dropdown Menu
Use Customized Options, Reuse Customized Options
string
The customized option ID which can be found on DragOnce ID List.
Selection Box,
Dropdown Menu
Use Workflow States
string
Workflow ID which can be found on DragOnce ID List.
Selection Box,
Dropdown Menu
Use Email Status
string (enum)
One of the enum defined in Email Status
Date & Time
Datetime
long
Millisecond timestamp. i.e. Unix timestamp * 1000
Date & Time
Date
long
Millisecond timestamp of the date's 00:00:00.
Date & Time
Time
int
Millisecond timestamp from 1970-01-01 00:00:00 to 1970- 01-01 23:59:59.
User & Group
User
array
Array of user ID(s).
User & Group
Group
array
Array of group ID(s).
User & Group
User and Group
array
Array of user ID(s) and/or group ID(s).
File Uploader
object
An Object where the key is the File ID. The value is an object contains the keys below:
"5a09128e3a0e670f8119ff59": {
"n": "abc.pdf",
"s": "9173"
}
Image Uploader
object
An Object where the key is the Image ID.
The value is an object contains the keys below:
"5a0912813a0e670f7d64fc14": {
"c": "IMG_2826.JPG",
"d": 1510543998
}
Email status is returned as enum in DragOnce. The following are the descriptions of each enum.
0
No Request
1
Request Processing
2
Failed
3
Email Processing
4
Sent
5
Bounce Back
6
Partially Failed
7
Partially Read
8
Read
9
No New Request
Timezone in DragOnce is represented by pre-defined IDs as follows.
771
(GMT-12:00) International Date Line West
723
(GMT-11:00) Midway Island, Samoa
756
(GMT-10:00) Hawaii
745
(GMT-09:00) Alaska
289
(GMT-08:00) Pacific Time (US and Canada); Tijuana
761
(GMT-07:00) Mountain Time (US and Canada)
203
(GMT-07:00) Chihuahua, La Paz, Mazatlan
749
(GMT-07:00) Arizona
750
(GMT-06:00) Central Time (US and Canada)
490
(GMT-06:00) Saskatchewan
217
(GMT-06:00) Guadalajara, Mexico City, Monterrey
486
(GMT-06:00) Central America
488
(GMT-05:00) Eastern Time (US and Canada)
754
(GMT-05:00) Indiana (East)
95
(GMT-05:00) Bogota, Lima, Quito
484
(GMT-04:00) Atlantic Time (Canada)
189
(GMT-04:00) Caracas, La Paz
265
(GMT-04:00) Santiago
493
(GMT-03:30) Newfoundland and Labrador
481
(GMT-03:00) Brasilia
98
(GMT-03:00) Buenos Aires, Georgetown
87
(GMT-03:00) Greenland
438
(GMT-02:00) Mid-Atlantic
422
(GMT-01:00) Azores
428
(GMT-01:00) Cape Verde Islands
522
(GMT) Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London
15
(GMT) Casablanca, Monrovia
532
(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
600
(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb
538
(GMT+01:00) Brussels, Copenhagen, Madrid, Paris
524
(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
17
(GMT+01:00) West Central Africa
540
(GMT+02:00) Bucharest
14
(GMT+02:00) Cairo
554
(GMT+02:00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius
528
(GMT+02:00) Athens, Istanbul, Minsk
365
(GMT+02:00) Jerusalem
27
(GMT+02:00) Harare, Pretoria
611
(GMT+03:00) Moscow, St. Petersburg, Volgograd
377
(GMT+03:00) Kuwait, Riyadh
46
(GMT+03:00) Nairobi
331
(GMT+03:00) Baghdad
406
(GMT+03:30) Tehran
383
(GMT+04:00) Abu Dhabi, Muscat
333
(GMT+04:00) Baku, Tbilisi, Yerevan
367
(GMT+04:30) Kabul
399
(GMT+05:00) Ekaterinburg
369
(GMT+05:00) Islamabad, Karachi, Tashkent
373
(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi
371
(GMT+05:45) Kathmandu
348
(GMT+06:00) Astana, Dhaka
338
(GMT+06:00) Sri Jayawardenepura
324
(GMT+06:00) Almaty, Novosibirsk
395
(GMT+06:30) Yangon Rangoon
335
(GMT+07:00) Bangkok, Hanoi, Jakarta
359
(GMT+07:00) Krasnoyarsk
644
(GMT+08:00) Beijing, Chongqing, Hong Kong SAR, Urumqi
375
(GMT+08:00) Kuala Lumpur, Singapore
403
(GMT+08:00) Taipei
466
(GMT+08:00) Perth
414
(GMT+08:00) Irkutsk, Ulaanbaatar
400
(GMT+09:00) Seoul
412
(GMT+09:00) Osaka, Sapporo, Tokyo
360
(GMT+09:00) Yakutsk
452
(GMT+09:30) Darwin
443
(GMT+09:30) Adelaide
448
(GMT+10:00) Canberra, Melbourne, Sydney
445
(GMT+10:00) Brisbane
454
(GMT+10:00) Hobart
419
(GMT+10:00) Vladivostok
702
(GMT+10:00) Guam, Port Moresby
398
(GMT+11:00) Magadan, Solomon Islands, New Caledonia
696
(GMT+12:00) Fiji Islands, Kamchatka, Marshall Islands
686
(GMT+12:00) Auckland, Wellington
726
(GMT+13:00) Nuku'alofa
Data which needs to be translated before saving in the target record.
If provided, the matching widget will translate from the given format to DragOnce format before saving into the DragOnce system. Which allows client programs to send the value without translating it. It allows easier integration between systems.
type
string
There are 7 types of translation.
Allowed values:
format
string
(optional)
Apply to type 1 , 2 & 3 only.
Must follow the PHP standard:
http://php.net/manual/en/datetime.createfromformat.php (Opens new window)
Ymd
tran_table
string
(json object) (optional)
See Data Translation Table Object for details.
Examples:
1
{
"type": "1",
"format":"Ymd"
}
Depends on format.
2
{
"type": "2",
"format":"YmdHis"
}
Depends on format.
3
{
"type": "3",
"format":"His"
}
Depends on format.
4
{
"type": "4"
}
Array of user login ID(s).
5
{
"type": "5"
}
Array of group name(s);
6
{
"type": "6"
}
Array of user login ID(s) and / or group name(s);
7
{
"type": "7",
"tran_table": {Data Translation Table Object}
}
Array of value exist in a given Data Translation Table Object mapping.
Type: string (json object)
app
string
App that contains the table.
App123456
page
string
Page that contains the table.
Page123456
table_id
string
Table ID of the table.
R_123456
map_column
string
Column ID (Widget ID) that shows the translations.
R_234567
table_filter
string
(json object) (optional)
Filter used in the table. It is a key-value pair object where key is the widget id and value is the filter value.
{
"R_345678": "filter"
}
Example:
{
"app": "App123456",
"page": "Page123456",
"table_id": "R_123456",
"map_column": "R_234567",
"table_filter": {
"R_345678": "filter"
}
}
Type: string (json object)
app
string
App that contains the table.
App123456
page
string
Page that contains the table.
Page123456
table_id
string
Table ID of the table.
R_123456
table_filter
string
(json object) (optional)
Filter used in the table. It is a key-value pair object where key is the widget id and value is the filter value.
{
"R_345678": "filter"
}
sort_by_field
string (optional)
Field used for sorting the records. The value should be one of the column ids. Only one field can be used.
R_456789
sort_by_desc
integer (optional)
Is the record sorted in descending order. Default is in ascending order, set to 1 for sort in descending order.
1
max_update
integer (optional)
Maximum number of records to be updated. Default value is 1
The maximum value is 1000.
123
Example:
{
"app": "App123456",
"page": "Page123456",
"table_id": "R_123456",
"table_filter": {
"R_345678": "filter"
},
"sort_by_field": "R_456789",
"sort_by_desc": "1",
"max_update": "123"
}