Use REST API to get lookup codes with Secured access
SummaryWe 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.