Hi
I'm looking to download the data from web into Alteryx
The format should be same
Sl. No. ISIN Nomenclature Date of issue Date of maturity Outstanding Stock (Rs.)
Website Link: https://m.rbi.org.in/scripts/bs_viewcontent.aspx?Id=3973
Gu @BRRLL99
It is just a matter of configuring the dynamic input template file with your directories.
Try the attached package, it is alreading doing it.
Hi @BRRLL99
Unfortunately, this page has some kind of protection to avoid non human users. I believe that you wont be able to do that with the download tool.
What i believe that is a good way to proceed here is to try to mimic a user using a RPA (Automation Anywhere/UiPath) or Python + Selenium.
Using python + selenium this shouldnt be too complicated, i cant do it right now, but during the next hours if you cant find another solution i am going to try.
I tried different ways, But there are static, not dynamic
Could you please try after 1 hour
Here it is, using python + selenium. Be aware that you will need to run alteryx as admin and install the necessary libraries to run it.
It is basically accessing the main page as a normal user, clicking on download file and then importing the downloaded file to the workflow.
It's not opening
It is showing Tool ID 19 is not in the document
there might be mis communication from my end
I just need the website data in the workflow
for ex: If i run the workflow I will receive updated data from website, no need for website link and download
@BRRLL99
Run this as adm:
Thq for your help
I code is running without any errors
But at the end Dynamic Input (26): Error opening table: Microsoft JET Database Engine: 'Outstanding on Feb 09, 2023$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.\3125 = -537199594
ErrorLink: Dynamic Input (26): https://community.alteryx.com/t5/*/*/ta-p/733391?utm_source=designer&utm_medium=resultsgrid|Can't find the file: "C:\Users\user01\Downloads\STRIPS8BED7129C25F411B9B72AC91E069DAE8.XLS|||`Outstanding on Feb 09, 2023$`". Make sure the file path is correct.
These are the two types of errors I'm Receiving
