My workbook (Extract Connection) will use a custom SQL query that relies on a "userid" parameter value in the URL Filter on username in a custom SQL query . However, since this is an Extract Connection (db doesn't support live), I would like to trigger a "refresh now" for each connection using the "Update Workbook Now" api call. In the api call, how can I specify the userid parameter value?
Can I just do something like the following?
Thank you for your help
I found out that this is an unscalable solution with multiple users querying the workbook at the same time... Still could be useful to know how to pass parameters in api calls!