getting json value with vb.net

Question

new to this site so please bear with me.

this is the code i use to get json data:

response = HttpReq.responsetext

this is the response i get:

{"status":200,"message":"Order(s) created successfully","data":[{"index":0,"referenceId":"307103f84dc94ee188d1111db0cdad86","orderNumber":"7081035854","shipmentOrderTypeCd":"DELIVER","orderState":"FORWARD"}],"hasError":false}

how do i get the referenceId in the following format so that i can use the value to update my database?

referenceId = 307103f84dc94ee188d1111db0cdad86

all help appreciated. Thanks

You can do string split and fetch the text or you can use Newtonsoft to read the property. refer: stackoverflow.com/a/21677364/443244 — Sangram Nandkhile
– Sangram Nandkhile, Commented May 3, 2018 at 6:41

Poat · Accepted Answer · 2018-05-04 01:22:26Z

0

This is a common thing where I work, as we deal with JSON from API requests.

By far the easiest IMO is to use JSON.Net. Here's how to get in NuGet: https://www.nuget.org/packages/newtonsoft.json/

Super easy example: https://www.newtonsoft.com/json/help/html/DeserializeObject.htm

So in your case you'd have a class similar to your response (can do a paste special in VS to make a class automatically from a response) And then Newtonsoft does the rest like so:

Dim orderResponse As Order = JsonConvert.DeserializeObject(Of Order)(HttpReq.responsetext)
Console.WriteLine(orderResponse.Data(0).referenceId); //maybe depending on your class you deserialize into

answered May 4, 2018 at 1:22

Poat

3852 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

getting json value with vb.net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related