Table Module

Ex Create Row

Create a New Row for Table

Request

Parameters

FieldDescription
keySlug of the field/column that needs to be populated (e.g., name, contract_value, renewal_date, etc.)
valueNew value of the field (depends on column type)

Body

{
    "key": "value"
}

Response

Created Table Row


Documentation for Column Types

1. Text

  • Description: Handles plain textual data.
  • Input Example: "Hello, World!"
  • Output Example: "Hello, World!"

2. RichText

  • Description: Manages text with rich text formatting elements.
  • Input Example: "Hello, World!"
  • Output Example: "In a visual medium: Hello, World!"

3. DateInterval (DATEDELTA)

  • Description: Represents an interval of dates. Intervals allowed: "month", "week", "day", "year" and "hour".
  • Input Example: {"size": 10, "interval": "day"}
  • Output Example: {"size": 10, "interval": "day"}

4. Date

  • Description: Manages a single date value. Input as %Y-%m-%d format, output as ISO 8601 format.
  • Input Example: "2023-01-01"
  • Output Example: "2023-10-03T14:12:07.797100"

5. SingleSelect

  • Description: Handles the selection of a single option from a set of choices. Input is the key of the option to be selected, output is the value of the option selected.
  • Input Example: "banana"
  • Output Example: "banana"

6. Binary

  • Description: Manages binary values, typically representing true or false.
  • Input Example: true
  • Output Example: true

7. MultiSelect

  • Description: Handles the selection of multiple options from a list. Input is the list of keys of the options to be selected, output is the list of values of the options selected.
  • Input Example: ["slack", "gmail"]
  • Output Example: ["slack", "gmail"]

8. Phone

  • Description: Processes phone number data.
  • Input Example: "+1-123-456-7890"
  • Output Example: "+1-123-456-7890"

9. Email

  • Description: Manages email address information.
  • Input Example: "user@example.com"
  • Output Example: "user@example.com"

10. User

  • Description: Validates and saves expent user-related data.
  • Input Example: [76]
  • Output Example:
    {
      "type": "USER",
      "id": "76",
      "name": "Barry Allen",
      "email": "hsalf@speed.com"
    }
    

11. Team

  • Description: Validates and saves expent team-related data.
  • Input Example: [33]
  • Output Example: {"type": "TEAM", "id": "32", "name": "Avengers", "email": null}

12. Number

  • Description: Manages numerical values.
  • Input Example: 42
  • Output Example: 42

13. File

  • Description: Processes file data.
  • Input Example: {"filename": "document.txt", "filetype": "txt", "url": "http://example.com/document.txt"}
  • Output Example: "document.txt (txt) - [Link](http://example.com/document.txt)"

14. Url

  • Description: Manages web URLs.
  • Input Example: "http://example.com"
  • Output Example: "http://example.com"

15. Currency

  • Description: Processes currency data.
  • Input Example: {"amount": 100, "currency": "USD"}
  • Output Example: "100 USD"

Note: The exact nature of input and output may vary based on specific system requirements and configurations.

post/v2/module/table/{id}/row

Path parameters

idstring required

Headers

authorizationstring required

The authorization token can be retrieved by calling the OAuth authentication API. The value for this header parameter follows the format "Bearer    access_token" (excluding the quotes). For example: <br /> Bearer MZA1YJMYZDKTZTFMMI0ZYZG1LTLMMDGTYTG4NJG2YZC3NJGY

The authorization token can be retrieved by calling the OAuth authentication API. The value for this header parameter follows the format "Bearer    access_token" (excluding the quotes). For example: <br /> Bearer MZA1YJMYZDKTZTFMMI0ZYZG1LTLMMDGTYTG4NJG2YZC3NJGY

Request body

object required

Response

Successful Response

idstring required
created_atstring date-time required
updated_atstring date-time required
valuesobject required
permittedboolean
overrided_valuesobject
archived_atstring date-time

Changes

No recorded changes to this endpoint across all 1 revision of this API.