JS Client API
  • Getting Started
  • Rule Engine Unique Functions
  • Custom Form Window Functions
  • Known Issues
  • Use Cases & Code Samples
  • 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
  • Get single value from User Defined Table
  • Get list of values from User Defined Table

Was this helpful?

  1. Retrieving Data

Retrieving User Defined Tables

PreviousRetrieving Standard ResourcesNextRetrieving Attachments

Last updated 6 years ago

Was this helpful?

Get single value from User Defined Table

To retrieve data from user defined table use this function

To retrieve single value data from a user defined table you must provide both mainKey and secondaryKey parameters.

Example:

pepperi.api.userDefinedTables.get(
{ table:"myTable",mainKey:"Item123", secondaryKey:"Categorgy124" });

Returns:

{"success":true,"value":"1"}

Get list of values from User Defined Table

THIS FUNCTION EXISTS ONLY FROM

To retrieve list of values from a user defined table you must provide at least tableName while mainKey and secondaryKey are optional.

currentAccountScope default value is true , in case you want to load the entire data from disk set it to false.

Example:

pepperi.api.userDefinedTables.getList(
{ table:"myTable",mainKey:"Item123", currentAccountScope: true});

Returns:

{ success :true, objects: [
{ mainKey: "ABCD12" , secondaryKey : "GFT4" , value: "23.5" },
{ mainKey : ABCD12 , secondaryKey : "GFT5" , value: "5656.5" }
] }
CPI 15.70