Forum Discussion

CraigA's avatar
CraigA
Icon for OneStream Employee rankOneStream Employee
3 years ago

Unable to use BRApi.Database.LookupRowFieldValue in Spreadsheet BR

Hi all. We have a spreadsheet rule that needs to pull a value from another database table. The lookup runs successfully in an existing Dashboard Extender, and I was initially requesting the amount ...
Extenders
Spreadsheet
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

Try doing that lookup explicitly, see if it raises any error. If you don't know how, look at this solution, particularly the section where we open the connection and execute a query. I would also check the rights of your user; depending on the connection configuration in server properties, they might not be able to query it.