Escaping password with special characters.

[philb]

Hi,

I've used Macro Scheduler to create a macro that opens an excel document, filters the data and saves it out. I time how long it takes and upload the results to a time series database.

The macro works with my testing credentials and everything reaches the database however when i use the proper credentials it fails.

I know how to escape special characters for the database itself but i wanted to know how i would escpape the characters in MS. The credentials are sent as part of the URL like below

Code: Select all

Let>URL=https://myserver.local:8086/write?db=macro_test&u=philb&p=P@ssW0rD!.

Obviously i've omitted the real password, but the one above is similar in that it contains the same special characters.

I've read a couple of topics on here and looked in the manual but i wasn't able to work it out from there, is someone able to offer some advice? The characters i need to escape specifially are @ ! and .

Thanks

[Marcus Tettmar]

Maybe you need to URL Encode it?
https://www.mjtnet.com/blog/2018/04/02/ ... -requests/

[philb]

Hi Marcus,

Thanks for the response. Sorry i've only just seen this today, I'm in between different projects and have just got back round to this but I will give that a try this now.

Thanks for your time.