How can we unpack a JSON file from an HTTP request

Question

[{"EmployeeID":1,"Name":"Alice","Age":20,"SSN":123456789}]

This is JSON file returned from a SQL query. I want to extract the name from this JSON file

Can you please elaborate on what you are trying to accomplish? — Pubudu, Jul 07 '18 at 17:14

score 1 · Answer 1 · answered Jul 09 '18 at 05:12

I found it:

As this returns a set of records from the table, indexing can be used as follows

var employee = retrieveById(empID); // returns as an array of records

string employeeName = employee[0].Name; // to extract the name from the 0th index(1st record)

1 Answers1