Im working with the REST-connector. Which works fine! But, I need to change one of the query parameters every day. I need to send current date every time in the URL as a parameter and want to create a variable with this date. How can I accomplish this?
I created this script but it throws me an error "There is no open data connection. The generated URL is correct and I can copy it from the error message and paste it in the browser and it works. Any ideas what to do? How can I open the connection?
Im using QlikSense Business Cloud.
LET vStartDate = date(addmonths(Today(),-6),'D.M.YYYY');
I am having a similar issue wit a Rest connection where i need to have a dynamic date in the query parameter (yesterday). When i run the connection in legacy mode with the date as a QS variable, i get an authorization error. However, when i use the QS data connection with authorization, i can't figure out how to pass the QS variable to the data connection's query parameter. How are you retrieving the "&token=GUSER-31fbe38f-43d9-427f-8dfa-b6e82570" from the data connection in the above example? do you have a recommendation of how to execute my problem?