How to use VLOOKUP for API?
Along the way of our commercial B2B SaaS product development, that empowers frontline employees with intuitive text interface to poorly-accessible corporate data to inform and speed business decisions with significant benefits for enterprises,
WE created a lot of useful and powerful software tools for testing apart of our main product. For example we've created VBA Excel function VLOOKUPWEB, that works same as VLOOKUP but for API JSON format responses.
You can use it for free. Source code and video tutorial is published on our NLSQL github profile (link below)
NLSQL GitHub profile