Σε απευθείας σύνδεση Url κωδικοποιητή

Is there a built-in way to URL encode a string in Excel VBA or do I need to hand roll this functionality?

I'm using Fiddler to capture some interactive web configuration and then programmatically replicating the steps through PowerShell. Many of the POST calls are using content type application/x-www-form-urlencoded.

Example (dot and dash are encoded but equal is not):Content-Type: application/x-www-form-urlencodedvalue1=some%2Ething&value2=srv%2DD001

Using a .NET library to URL encode along with various online tools, the raw string values don't match up with capture in Fiddler and in particular the "=" equal signs are not changed. Is there a specific way I need to construct the body of key pair values such that the equal sign is preserved and not URL encoded? Also I'm not quite sure how the encoding comes up with "&" as the delimiter for each key value pair.

I can construct the body as Fiddler is capturing it - but ideally I'd like to pass the values in a well structured format and let the encode process take care of the formatting.

I want to represent all characters in a string as in this table.

But when I do

raw = 'æøå'encoded = raw.encode('cp1252')print(encoded)

I get

>>> b'\xe6\xf8\xe5'

What I want is

>>> %E6%F8%E5

as a string for use in a URL.

I'm POSTing data to an external API (using PHP, if it's relevant).

Should I URL-encode the POST variables that I pass?

Or do I only need to URL-encode GET data?

Thanks!

UPDATE: This is my PHP, in case it is relevant:

$fields = array(    'mediaupload'=>$file_field,    'username'=>urlencode($_POST["username"]),    'password'=>urlencode($_POST["password"]),    'latitude'=>urlencode($_POST["latitude"]),    'longitude'=>urlencode($_POST["longitude"]),    'datetime'=>urlencode($_POST["datetime"]),    'category'=>urlencode($_POST["category"]),    'metacategory'=>urlencode($_POST["metacategory"]),    'caption'=>($_POST["description"]));$fields_string = http_build_query($fields);$ch = curl_init();curl_setopt($ch, CURLOPT_URL,$url);curl_setopt($ch,CURLOPT_POST,count($fields));curl_setopt($ch,CURLOPT_POSTFIELDS,$fields);curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);$response = curl_exec($ch);

newbie here, int the following the it takes in a file as a parameter and concatenates it to the directory string, it then looks for the file and using streams fetches and serves the file to the browser for downloading. This code is susceptible to directory traversal and im not sure how to go about hardening the code to counteract this.

<%         if(request.getParameter("file")!=null)        {            String context = request.getContextPath();            int BUFSIZE = 4096;               String filePath;            filePath = request.getParameter("file");            File file = new File(getServletContext().getRealPath("/") +context);            file = new File(file.getParent()+"/documents/"+filePath);                   int length   = 0;            ServletOutputStream outStream = response.getOutputStream();            //response.setContentType("text/html");            response.setContentLength((int)file.length());            String fileName = (new File(filePath)).getName();            response.setHeader("Content-Disposition", "attachment; filename=\"" + fileName + "\"");            //response.setHeader("Content-Disposition", "attachment; filename=\"" +new Random().nextInt(10000)+ "\"");            byte[] byteBuffer = new byte[BUFSIZE];            DataInputStream in = new DataInputStream(new FileInputStream(file));            while ((in != null) && ((length = in.read(byteBuffer)) != -1))            {            outStream.write(byteBuffer,0,length);            }            in.close();            outStream.close();        }        else        {        }

%>