o365 web connector Parameters in the URL; in particular what is the Appid used for?
Article Number: 000054087 | Last Modified: 2018/11/21
A customer may be interested in understanding what can be contained within the parameters in the URL e.g. appID what is it for ?
The parameters that can be taken do depend on the connector that you’re using, but all the URLs define the connector you are using and the table that’s being referenced, i.e. connectorID=Office365Connector&table=ListItemsFromID
The parameters that follow tend to then reflect the parameters that are used on a specific table, so on using the ListFolders table, because a value was entered (/shared documents) into the Folder parameter, it now appears in the URL, i.e.
Because of the way you can manipulate Qlik script, in your application you can change the values on the fly, i.e. replace the folder name with a variable, which can be swapped out, ….=ListFolders&folder=$(‘aVariableWithMyFolderName’)&appID=
What is the appID userd for?
This is enabled/used when you’ve got users set up in QWC
(step 3: https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Install/Advanced_install.htm ).
A user will have a unique ID assigned to them (you’ll see this listed with QWC), so that when the request for data is sent from Qlik to QWC, the appID is sent over too and QWC knows which authenticated account to use the details of. It maybe that you have a QWC account set up with a main set of Sharepoint credentials, which will have it’s own appID. So, when a developer is finished developing a Qlik app, they can then change the appID in the load script from their appID to the main one for production – you could also set this up a variable in the Qlik app so you can toggle between development appID and production appID.