0

I'm writing some VBA code that retrieves results from a web service. Here is the result:

Response.Content : "{
    "CancelTaxResult": {
        "DocId": "74856298",
        "TransactionId": 1017269429,
        "ResultCode": "Success"
    }
}

I can't for the life of me figure out how to get the values of DocId, TransactionId, or ResultCode

I see the attached in Watches

enter image description here

Can someone point me in right direction?

Community
  • 1
  • 1
mark1234
  • 1,110
  • 2
  • 24
  • 41
  • http://stackoverflow.com/questions/5354718/vba-json-parser-or-dll/5355201?s=1|2.3641#5355201 or http://stackoverflow.com/questions/15073370/vba-creating-substrings-out-of-json-and-reformatting-into-columns/15075670?s=3|1.7347#15075670 – Tim Williams Feb 27 '15 at 01:13
  • Thanks looked at those and still no luck. I'm not looking for a JSON parser. Everything else I have is working,. Just can;t figure this last bit out – mark1234 Feb 27 '15 at 12:21
  • Might help to explain what is we're looking at in that watch window and how you got it. – Tim Williams Feb 27 '15 at 15:51

1 Answers1

0

Figured it out:

Response.Data("CancelTaxResult")("DocId")

mark1234
  • 1,110
  • 2
  • 24
  • 41