Retrieving User Defined Tables

Get single value from User Defined Table

To retrieve data from user defined table use this function

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 CPI 15.70

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" }
] }

Last updated

Was this helpful?