I actually don't know what a json document is, nor do I particularly care, all I worry about is getting access to our data files, and then doing what I need to do. For this I simply a Query
It used to be easy, as everything was hosted on an SQL server. But our newer data is stored differently, and accessed using a command such as "Source = Json.Document(Web.Contents("https://ats.ourcompany.com/p031/timesheets"))"
(I have a username and password to access the server)
If I already know the names of the other tables I want, I can simply change the address to "p031/projlist" etc, but I must KNOW the table name first. (Unlike SQL, where I can simply navigate and get a list of all tables at the next level)
Here, trying to navigate to the parent level, generates an error.
Is there any way to download a list of the tables or json documents available?