Tanvi
Member
- Joined
- Feb 24, 2022
- Messages
- 10
- Programming Experience
- 1-3
Hi Team,
Following is the code from C# (from API source code) which returns as List from JSON output.
Now I am trying to access these lists from VBA, but I am not able to view them in VBA.
I've done all the initial setups like creating an interface, GUID, and all namespaces. I am able to access the methods from VBA, but not the lists returned from C#.
Please guide me, as I am still connecting the dots.
Following is the code from C# (from API source code) which returns as List from JSON output.
Now I am trying to access these lists from VBA, but I am not able to view them in VBA.
I've done all the initial setups like creating an interface, GUID, and all namespaces. I am able to access the methods from VBA, but not the lists returned from C#.
Please guide me, as I am still connecting the dots.
C#:
public OutputBaseClass getOrderBook()
{
OutputBaseClass res = new OutputBaseClass();
GetOrderBookResponse bres = JsonConvert.DeserializeObject<GetOrderBookResponse>(Json);
res.GetOrderBookResponse = bres; //here in this response I am getting a list
res.status = bres.status
}
public class OutputBaseClass
{
public List<OrderBookData> data { get; set; }
public GetOrderBookResponse GetOrderBookResponse { get; set; }
public bool status { get; set; }
}
public class GetOrderBookResponse
{
public List<OrderBookData> data { get; set; }
public bool status { get; set; }
}