I m trying to connect to web endpoint to form a repository in excel.I'm quiet new to this.The scenario is

i have a endpoint where i need to pass two data dynamically in the query so i get respective data in the excel

i need to pass today's date and start date of the month .

how can i do that?

the variable in the query should be auto updated with dates so that the results are as expected.

I have established the connectivity from excel to endpoint .Not sure how can i pass dates