Fiddler: catching cookie names and values

Nelson78 · Sep 16, 2020

Hello everybody.

I'm using excel vba and

VBA Code:

Set objHTTP = CreateObject("MSXML2.XMLHTTP")

to navigate a site.

This is the code:

Code:

    With objHTTP
        .Open "GET", URL, False
        .setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
        .send
        strResponse = .responseText

        Sheets(2).Range("a1") = strResponse
        
    End With

Now, I need to catch names and values concerning the 4 cookies you can see in Fiddler (I've cripted them with red lines, but I think the matter is understandable),

How can I perform the task?

Thank's in advance.

Anthony47 · Sep 17, 2020

Can you share which is the response of the request, ie Sheets(2).Range("a1") content?

Bye

Nelson78 · Sep 17, 2020

Unfortunately not entirely.

This is the beginning:

VBA Code:

<meta name="viewport" content="width=device-width">

<HTML>

<HEAD>

<meta name="viewport" content="width=device-width">

It is the login page.

Anthony47 · Sep 17, 2020

Nelson78 said:
Unfortunately not entirely

Unfortunately, with that level of information we cannot even be sure that the information you look for are in the response you receive from the server. I am not able to help, sorry; maybe someone else...

Bye

Nelson78 · Sep 18, 2020

Anthony47 said:
Unfortunately, with that level of information we cannot even be sure that the information you look for are in the response you receive from the server. I am not able to help, sorry; maybe someone else...

Bye

Concretely, I see 4 cookies

Anthony47 said:
Unfortunately, with that level of information we cannot even be sure that the information you look for are in the response you receive from the server. I am not able to help, sorry; maybe someone else...

Bye

Ok, I understand it's hard to help me, but unfortunately data are not public.

Any way, I went a little bit forward.

Maybe this is a more general issue.

I've been sending a post request:

VBA Code:

Dim LoginRequest As Object
    Set LoginRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
    LoginRequest.Open "POST", "yyyyyyyyyy", False
    LoginRequest.setRequestHeader "Accept", "text/html, application/xhtml+xml, */*"
    LoginRequest.setRequestHeader "Referer", "xxxxxxxxxx"
    LoginRequest.setRequestHeader "Accept-Language", "it-IT"
    LoginRequest.setRequestHeader "User-Agent", "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
    LoginRequest.setRequestHeader "Content-type", "application/x-www-form-urlencoded"
    LoginRequest.setRequestHeader "Connection", "Keep-Alive"
    LoginRequest.setRequestHeader "Cookie", ck1
    LoginRequest.setRequestHeader "Cookie", ck2
    LoginRequest.setRequestHeader "Cookie", ck3
    LoginRequest.send

How can I read the request I've sent, to check whether it is correct or not?

Anthony47 · Sep 18, 2020

For example:

Code:

Dim xmlResponse As New DOMDocument
'
'
LoginRequest.send
'Read response:
xmlResponse.LoadXML (LoginRequest.responseText)

Now you can analyze contents of xmlResponse

A recent discussion that deals with something similar: VBA XML SelectNodes - script errors out when nodes are missing

Bye

Fiddler: catching cookie names and values

Nelson78

Well-known Member

Excel Facts

Anthony47

Well-known Member

Nelson78

Well-known Member

Anthony47

Well-known Member

Nelson78

Well-known Member

Anthony47

Well-known Member

Similar threads

Forum statistics

Share this page

Fiddler: catching cookie names and values

Nelson78

Well-known Member

Excel Facts

Anthony47

Well-known Member

Nelson78

Well-known Member

Anthony47

Well-known Member

Nelson78

Well-known Member

Anthony47

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock