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?