Single Record Creation APIAPI Explorer

Introduction

API Introduction

You can add one record to a certain form through the Single Record Creation API.

Note:

If you use the API to create a record, the following events can be triggered: record submission notifying, aggregation table calculation & validation, data operation log recording, and data volume statistics. It is also possible to decide whether to initiate a workflow through request parameters. However, validations on duplicate value and required field will not be triggered.

Records creating and updating are forbidden in the system fields and the following fields.

  • Divider
  • Signature
  • RelatedData and RelatedQuery
  • Serial No. (Automatically generated)

Version Description

API Version

Updated Time

Version Description

V 1

2022.10.28

The API request frequency is increased from five times per second to 20 times per second. The parameters "app_id" and "entry_id" are put in the body and the API route changed to "POST app/entry/data/create".

2023.08.31

A new request parameter "data_creator" is added.

API Calling

Add a record to a certain form.

Request URL: https://api.jodoo.com/api/v5/app/entry/data/create

Request Frequency: 20 times per second

Request Method: POST

Request Parameters:

Parameter

Type

Required

Description

Default

app_id

String

Yes

App ID

/

entry_id

String

Yes

Form ID

/

data

JSON

Yes

Records to add.

/

data_creator

String

No

The member who submits data. The value for "data_creator" is the member's NO.. You can obtain the member number through the contact APIs.

Business owner

is_start_workflow

Bool

No

Whether to initiate workflows (Only work in workflow forms)

false

is_start_trigger

Bool

No

Whether to trigger Automations

false

transaction_id

String

No

Transaction ID (transaction_id) is used to bind a batch of uploaded files. If the data includes attachments or images, the transaction_id must be the same as that in the API for accessing upload credentials and URL.

/

Request Example:

{
    "app_id": "59264073a2a60c0c08e20bfb",
    "entry_id": "59264073a2a60c0c08e20bfd",
    "transaction_id": "87cd7d71-c6df-4281-9927-469094395677",   //Transaction ID
    "data": {
        "_widget_1432728651402": { // Single Line
            "value": "Jodoo"
        },
        "_widget_1432728651403": { // Number
            "value": 100
        },
        "_widget_1432728651404": { // Multi Line
            "value": "Jodoo is a powerful and easy-to-use tool to build apps. \nIt can make your ideas come true "
        },
        "_widget_1432728651405": { // Radio, Single Select
            "value": "Option 1"
        },
        "_widget_1432728651406": { // Checkbox,Multi Select
            "value": [
                "Option 1, Option 2, Option 3"
            ]
        },
        "_widget_1432728651407": { // Date&Time
            "value": "2018-01-01T10:10:10.000Z"
        },
        "_widget_1432728651412": {  // Address
            "value": {
                "province": "United Kingdom",
                "city": "London",
                "district": "Westminster",
                "detail": "10 Downing Street"
            }
        },
        "_widget_1432728651413": { // Locate
            "value": {
                "province": "United Kingdom",
                "city": "London",
                "district": "Westminster",
                "detail": "10 Downing Street",
                "lnglatXY": [
                    120.31237,
                    31.49099
                ]
            }
        },
        "_widget_1528854613291": { // Subform
            "value": [
                { // The structure of subform records are the same as that of form records
                    "_widget_1528854614409": {
                        "value": "Subform record 1"
                    },
                    "_widget_1528854615499": {
                        "value": 100               
            }
        },
        "_widget_1652345009126": { //Member(a member's username)
            "value": "jian"
        },
        "_widget_1652345009143": { //Members (members' username array)
            "value": [
                "Joo",
                "do"
            ]
        },
        "_widget_1652345009157": { //Department(a department's dept_no)
            "value": 12
        },
        "_widget_1652345009174": { //Departments(departments' dept_no array)
            "value": [
                12,
                13
            ]
        },
        "_widget_1432728651408": { // Attachment(File key array)
            "value": ["6b559cf1-b16c-43bd-a211-8fa8fdeae2ef","6b559cf1-b16c-43bd-a211-646ab85da8cb"]
        },
        "_widget_1432728652567": { // Image(File key array)
            "value": ["6b559cf1-b16c-43bd-a211-74389cd8ae76","6b559cf1-b16c-43bd-a211-564e56a65bd6"]
        },
        "_widget_1432728651408": { // Attachment(File key array)
            "value": ["6b559cf1-b16c-43bd-a211-8fa8fdeae2ef","6b559cf1-b16c-43bd-a211-646ab85da8cb"]
        },
        "_widget_1432728652567": { // Image(File key array)
            "value": ["6b559cf1-b16c-43bd-a211-74389cd8ae76","6b559cf1-b16c-43bd-a211-564e56a65bd6"]
        }
    }
}

Responses:

Parameter

Type

Description

data

JSON

Return the complete records after submission, with the same content as the Single Record Query API.

{
    "data": {
        "_id": "59e9a2fe283ffa7c11b1ddbf",  
        "appId": "59264073a2a60c0c08e20bfb",
        "entryId": "59264073a2a60c0c08e20bfd",
        "creator": {
            "name": "Jodoo",
            "username": "Jodoo",
            "status": 1,
            "type": 0,
            "departments": [1, 3],
            "integrate_id": "Jodoo"
        },
        "updater": {
            "name": "Jodoo",
            "username": "Jodoo",
            "status": 1,
            "type": 0,
            "departments": [1, 3],
            "integrate_id": "Jodoo"
        },
        "createTime": "2017-10-20T22:41:51.430Z", // Created Time
        "updateTime": "2017-10-20T11:12:15.293Z", // Updated Time
        "_widget_1432728651402": "Jodoo",  // Single Line
        "_widget_1432728651403": 100, // Number
        "_widget_1432728651404": "Jodoo is a powerful and easy-to-use to build apps. It can make your ideas come true", // Multi Line
        "_widget_1432728651405": "Option 1", // Radio, Single Select
        "_widget_1432728651406": [ // Checkbox, Multi Select
            "Option 1, Option 2, Option 3"
        ],
        "_widget_1432728651407": "2018-01-01T10:10:10.000Z", // Date&Time
        "_widget_1432728651408": { // RelatedData
            "id": "5b28effa49b561455dfda91e",
            "key": "Jodoo"
        },
        "_widget_1432728651409": [ // Image
            {
                "name": "image.jpg",
                "size": 262144,
                "mime": "image/jpeg",
                "url": "https://files.jiandaoyun.com/lepxaifzcapghupffcaswikmhnyp"
            }
        ],
        "_widget_1432728651410": [ // Attachment
            {
                "name": "Product Documentation.pdf",
                "size": 524288,
                "mime": "application/pdf",
                "url": "https://files.jiandaoyun.com/bogrebbkdbkfsbuldnjujoenclle"
            }
        ],
        "_widget_1432728651411": { // Signature
            "name": "image.png",
            "size": 262144,
            "mime": "image/png",
            "url": "https://files.jiandaoyun.com/sxbikbrchwlylrgqwyfkjbjmuncp"
        },
        "_widget_1432728651414": { // Member
            "name": "Jodoo",
            "username": "Jodoo",
            "status": 1,
            "type": 0,
            "departments": [1, 3],
            "integrate_id": "Jodoo"
        },
        "_widget_1432728651415": [ // Members
            {
                "name": "Jodoo",
                "username": "Jodoo",
                "status": 1,
                "type": 0,
                "departments": [1, 3],
                "integrate_id": "Jodoo"
            }
        ],
        "_widget_1432728651416": {  // Department
            "name": "Manager Department",
            "dept_no": 1,
            "type": 0,
            "parent_no": 2,
            "status": 1,
            "integrate_id": 1
        },
        "_widget_1432728651417": [ // Departments
            {
                "name": "Manager Department",
                "dept_no": 1,
                "type": 0,
                "parent_no": 2,
                "status": 1,
                "integrate_id": 1
            }
        ],
        "_widget_1432728651408": [ // SubForm
            {
                // ... 
            }
        ],
    }
}

Was this information helpful?
Yes
NoNo
Need more help? Contact support