You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Use REST API to get lookup codes with Secured access

Received Response
edited Nov 3, 2020 4:05PM in Inventory Management 3 comments


We want to retrieve values from a secured lookup code in Excel VBCS to display user friendly names


I am creating a spreadsheet for the maintenance of subinventory items with the VBCS add-in. This works fine. I want to create a List of Value for the lookup code INV_MATERIAL_PLANNING. The REST API 'standardLookupsLOV' is not retrieving the lookup code because it is a secured lookup: REST Access Secured = "Secure". The manual says: 

Secure: Lookup isn't available to users as part of the generic resource. To make it available securely, you must create a specific resource, assign it to a role, and assign that role to select users.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!