It seems that REST API can only access a subset of tables or views inside the ILMT or BFI database? If so, how do I identify which table or view from the database?
I have a custom computer property named “serial_number” created from BFI portal. It is created inside dbo.computer_properties view.
I have no problem selecting this serial_number column from Computers and Hardware Inventory reports.
Using ServiceNow integration with BFI, how do I run REST API against this dbo.computer_properities view to get the information from my custom computer property called “serial_number”? This custom serial_number property contains a specific format for the serial number. Customer wants to extract this custom serial_number property into ServiceNow. Please advise.
You would use the computer_details association to pull back custom computer properties. See documentation here.
Any custom computer property added to the Computer Properties panel in BFI is available via this association. Use the following to retrieve the computer properties identifiers:
Thank you itsmpro92. I will have a look. Can someone modify or customize the REST API *.json files (computer_details.json) provided by BFI to add additional table or field information?