<JsonProperty(PropertyName:="valueofid")>
    Public Property valueofid As String   'Correction here, should be "valueofid", instead of name "self"
End Class
>>>>>>

Since data in JSON format is returned.  you can try to use RestSharp (RestSharp.dll) and  Newtonsoft.Json. (free download somewhere, Newtonsoft.Json.dll). which can help you to manipulate JSON data easily.
>>sample of...

Based on your question of choosing between SSIS and ASP.NET:
Last year I completed a task with similar target, I was using tools: VB.NET (windows application), RestSharp and Newtonsoft.Json. My...