Parsing the output of a API call, VB.net

Question

I call an API in Visual Basic and it returns me this:

"access_token": "21652337f6733aec846eecd28bc421642a040ed68fd288bb2e1b96a3fa3",
"token_type": "bearer",
"expires_in": 7776000,
"created_at": 1471158248

I can save this response to a variable, but how do I filter out everything but the Access Token and then save that to a variable?

Thanks.

That looks like part of a JSON response (maybe an OAuth token) which means it should be deserialized or maybe parsed. — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Aug 14, 2016 at 12:33

FloatingKiwi · Accepted Answer · 2016-08-14 09:11:44Z

1

Public Function GetAccessToken(input As String) As String
    Dim result = System.Text.RegularExpressions.Regex.Match(input, """access_token"":\s*""([^""]*)""")
    If result.Success Then
        Return result.Groups(1).Value
    End If
    Return ""
End Function

answered Aug 14, 2016 at 9:11

FloatingKiwi

4,5161 gold badge20 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

dpskipper Over a year ago

Thanks that worked but its not complete. The output I get from your code gives me the whole access_token line. I just want the actual random string minus quotations. So my output would look like: 21652337f6733aec846eecd28bc421642a040ed68fd288bb2e1b96a3fa3 ...No more no less. Thanks for the help.

FloatingKiwi Over a year ago

Odd, are you sure you copied it exactly? There's only 1 capture group defined so groups(0) would give the whole line, groups(1) should give your value.

dpskipper Over a year ago

Well, no. I didn't quite copy it exactly as your Public Function would not work inside of my sub, so i had to Frankenstein it with my very limited knowledge of VB. The line I did use was this one: Dim result = System.Text.RegularExpressions.Regex.Match(input, """access_token"":\s*""([^""]*)""") and when I printed the output of result.value I get the whole access token line. I did manage to work around this in the most convoluted method possible, but it does work. If you could make this one line only include the access token minus quotations I would be very happy.

FloatingKiwi Over a year ago

Instead of printing result.Value print result.Groups(1).Value. However trying to fit things onto one line is generally a bad practice.

Collectives™ on Stack Overflow

Parsing the output of a API call, VB.net

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related