Table Module

Ex Edit Row

Update an Existing Row for Table

Request

Parameters

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

Body

{
    "key": "value"
}

Response

Updated 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.

put/v2/module/table/{id}/row/{row_id}

Path parameters

idstring required
row_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.