I am currently building an app using JSON data. I have the source file locally hosted with windows IIS and I am using Sense's REST connector to retrieve it. I was wondering whether it was possible to read the filename of the JSON file and load it in a table. I know of the FileName() function but as the REST connector generates an SQL script I'm not sure if it is possible to use it.
Does anyone have ideas on how to best go about this?
