Hi Karthik
As you have mentioned, we can pass value of date as a parameter to url. Here is a thread in SO with similar use case, with only change, in the source data set you can use the below expression in relative url. (No need to use parameters in data set)
@concat('?CreatedAt=',addDays(utcNow(),-1))
Based on the format of the date, we could use the below expression.
@concat('?CreatedAt=',formatDateTime(addDays(utcNow(),-1),'MM/dd/yyyy')