The request URL looks like this:
How can I create some kind of setup (or loop) where I can easily retrieve the data from an entire year per month per state? The data itself doesn't have some kind of timestamp, so I'll have to retrieve each month separately.
So for example:
2022-01-01 till 2022-01-31 for Ohio
2022-01-01 till 2022-01-31 for Florida
2022-02-01 till 2022-02-31 for Ohio
2022-02-01 till 2022-02-31 for Florida
etc...
Best answer by ebygomm
No need for a loop, if you have a start date for the year, you can clone a feature 12 times, then create start and end dates for each month based on the copynumber
e.g. for the start date for a month
@DateTimeAdd(@Value(startofyear),P@Value(_copynum)M)Then for the end date you can add a month and minus a day to get the last day of the month
@DateTimeAdd(@DateTimeAdd(@Value(startdate),P1M),-P1D)Then you should have everything needed to create your request url once you join in the state info
+31No need for a loop, if you have a start date for the year, you can clone a feature 12 times, then create start and end dates for each month based on the copynumber
e.g. for the start date for a month
@DateTimeAdd(@Value(startofyear),P@Value(_copynum)M)Then for the end date you can add a month and minus a day to get the last day of the month
@DateTimeAdd(@DateTimeAdd(@Value(startdate),P1M),-P1D)Then you should have everything needed to create your request url once you join in the state info
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
