Hello,

I'm syncing my workbook to a few API datasources (http://api.aceproject.com/explorer/?fct=getprojects), but having some difficulty updating the query string whenever I need to generate a new GUID.

The current method I'm using for creating the connection is the "From Web" connection wizard, which creates an XML table. From there I update the query with VBA, but the issue is that it stores the GUID in plain text in "Connections", which poses a security concern.

I tried setting up the connection using Power Query, and while it obscures the GUID, I can't figure out how to update it easily whenever the GUID changes.

Which leads me here... What *IS* the best type of data connection to use for an API (Website Query) where I need to periodically update the query string?

I can format the data through the API as DataSet or XML. I've noticed PoweryQuery seems to like the DataSet format better because when I use XML it adds "Property:..." in front of each column title. Before I spend more time trying to figure out how to update the source for PowerQuery I want to make sure there isn't a "best practice" way for doing this that I'm overlooking.