Invoke REST API and store the json response to snowflake table
I want to invoke the REST API and the API params will be dynamic. params will be start_date and end_date. end_date should be current_timestamp and start_date should be 1 day before. I could use custom connector for static API endpoint, but is it possible to pass those dates to the API endpoint dynamically?