JS Client API
  • Getting Started
  • Rule Engine Unique Functions
  • Custom Form Window Functions
  • Use Cases & Code Samples
  • Known Issues
  • Retrieving Data
    • Retrieving Standard Resources
    • Retrieving User Defined Tables
    • Retrieving Attachments
    • Retrieving Items in Transaction Scope
    • Retrieving Transaction Lines
    • ADAL
  • Updating Data
    • Adding Objects to Standard Resources
    • Updating Standard resources
    • Updating User Defined Table
    • Updating Items in Transaction Scope
    • Adding Transaction Lines
    • Removing Transaction Lines
Powered by GitBook
On this page
  1. Updating Data

Updating User Defined Table

PreviousUpdating Standard resourcesNextUpdating Items in Transaction Scope

Last updated 17 days ago

Was this helpful?

CtrlK

Was this helpful?

Data Update Methods

Upsert a Single User Defined Table Value

  • Description: Inserts or updates a single value in a UDT using the upsert function, requiring table, mainKey, and secondaryKey to identify the record, and value for the data.

  • Syntax:

    pepperi.api.userDefinedTables.upsert({
      table: "<tableName>",
      mainKey: "<mainKey>",
      secondaryKey: "<secondaryKey>",
      value: "<value>"
    });
  • Example:

    pepperi.api.userDefinedTables.upsert({
      table: "myTable",
      mainKey: "Item123",
      secondaryKey: "Category124",
      value: "my value"
    });
  • Returns:

    {
        "success": true
    }