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
Run Alteryx as an Administrator and then run the workflow. This piece of code is able to install libraries:
You wont be able to get data from this website without some trick, they are blocking "normal" connections to it. This workflow is a way of doing a trick to pass through.
After running the workflow
it is showing this error:
Error: Dynamic Input (26): Error opening table: Microsoft JET Database Engine: 'Outstanding on Feb 09, 2023$' is not a valid name. Make
for 2nd line of code it is showing
---------------------------------------------------------------------------ModuleNotFoundError Traceback (most recent call last)<ipython-input-2-d981db0f628f> in <module> 15 from selenium.webdriver.chrome.service import Service 16 ---> 17 from webdriver_manager.chrome import ChromeDriverManagerModuleNotFoundError: No module named 'webdriver_manager'
@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
