Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
hafaneh
Contributor III
Contributor III

API DAILY

hello everyone,  
i have this api that needs a date to get the data from it and i want it this url to get the date auto for the next day 

 

i was using this 


LET vStartDate = Num(Date#('01-10-2023', 'DD-MM-YYYY'));
LET vEndDate = Num(Date#('15-10-2023', 'DD-MM-YYYY'));

FOR vDate = $(vStartDate) TO $(vEndDate)
LET vStart = Date(vDate, 'YYYY-MM-DD');
LET vEnd = Date(vDate + 1, 'YYYY-MM-DD');

.....
LET vUrl = vUrl & '&start=' & Date(vStart, 'YYYY-MM-DD');
LET vUrl = vUrl & '&end=' & Date(vEnd, 'YYYY-MM-DD');
LET vUrl = vUrl & '&page=1';
LET vUrl = vUrl & '&Accept=text/json';

next vDate

i have the data till the date (15) but i want when i load the data to get the next day without editing the date by hand everytime

 

anyone can help me with this? 

1 Reply
hafaneh
Contributor III
Contributor III
Author

and when i do this 

LET vStartDate = Date#('01-10-2023', 'DD-MM-YYYY');
LET vEndDate = Date#('31-10-2023', 'DD-MM-YYYY');

FOR i = 0 TO vEndDate - vStartDate

LET vCurrentDate = Date(vStartDate + i, 'YYYY-MM-DD');

LET vStart = vCurrentDate;
LET vEnd = vCurrentDate + 1;
next i 

i get an error i get to the new date like 16 but i get an error after how to stop it