Getting location updates from audit trail using Excel data query
I'm not a seasoned API user, so forgive me if this is an overly simple question. I'm trying to help a client track when changes are made to their location settings, and would like to do so using Excel's data connection capabilities. Where I'm currently stuck is trying to construct the data connection in Excel. I can run the JSON query in the API reference interface and it works (maybe not perfectly, but it doesn't error out). But when I go to build it in Excel, I'm clearly missing something. If anyone has an example of how they set up an Excel data query to pull audit trail information and would be willing to share, that would be immensely helpful.