Batch mode: Workflow with password protect CSV file

[Miriam17]

Hi,

I want to run a workflow in batch mode. I used the CSV reader with an URL Input.
The batch mode is working with an “normal” CSV file, but if I use a password protect CSV file it’s not working.
Is there a possibility to run the workflow in batch mode with a password protect CSV file? How can i handle the password entry in batch mode?

It would be great if you could help me here

Thanks a lot.

Kind regards
Miriam

[goodvirus]

Hi,

could you elaborate how the file is password protected? CSV is just a textfile and has no password. Is it a htppasswd login? Username and password?
Could you share the url?

Kind regards,

Paul

[Miriam17]

Hi Paul,

thank you for you reply. You’re right, the feed URL is protected with a username & password. I can’t share the direct URL, but it looks like this: https://feeds.minubo.com/download/XXXXX.

When I run the workflow directly in Knime, it works perfectly when I enter the username and password in the field that appears.

Is this also possible with batch mode ?

Kind regards
Miriam

[goodvirus]

Hi @Miriam17,

I´m currently not having an example website, but you could just give the url the login information: something like this: https://user:password@https://feeds.minubo.com/download/XXXXX

Can you try that?

Kind regards,

Paul

[Miriam17]

Hi Paul,
I tried it, but i get an error message : " The specified file XXXX does not exist."
If i enter the link with password directly in the browser, then the download works. So it just does not work in Knime.

Kind regards
Miriam

[goodvirus]

Hi @Miriam17,

sorry I pasted it wrong this should be correct: https://user:password@feeds.minubo.com/download/XXXXX can you try it out (sorry again I can’t test it, because I don’t have a password protected website)

[Miriam17]

Hi Paul,

thank you for the info, but I had already tested it in the correct format and have received the above message.

[goodvirus]

Than I´m out of options, but I have found a forum post, maybe it helps?: 401 response - Authorization request header not working (HttpReceiver)