Converting a record of multiple of the same structures into a list of that structure

Converting a record of multiple of the same structures into a list of that structure

  

Hello,

I am trying to get information from this web service https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=MSFT&apikey=demo and as a response I receive 100 separate structures. What I want, if it is possible, is to convert the response into a list of that structure without having to append 100 times.

Attached, you can see a picture of the actual response.

Do you have any ideas on how I should proceed?

Thank you in advance for your answers.

Kind regards,

Larisa



Solution

Hi Larisa,

That's a f*cked up REST service if ever I saw one... There's unfortunately no out-of-the-box solution for this. I think the most sensible way would be to add an On After Response handler and convert the JSON to something OS can handle.

Solution

Hi Kilian,

While checking the documentation, I also found this solution before asking, but I was hoping for an easier one.

Thank you for your response.


Kind regards,

Larisa

Hi Larisa,

Sorry that I can't make it any easier :). But it really is an extremely weird format... Good luck!