api data

[Superfly69]

Hi,

I hope someone can help please.  Many thanks in advance.

What I want to be able to do is to make an API call to retrieve data, filter this data and then update a row in excel with it.

I am able to make the API call and retrieve the data with Parse Json. 

But I am not sure how to handle the data which is several hundred rows to update the table in excel.  I've tried a number of different ways following some other posts but am unable to make it work.  I think I need to initialize a variable and do a apply for each loop but both of these parts I dont really understand...

The error I receive is:

The variable 'alerts' of type 'Array' cannot be initialized or updated with value of type 'Object'. The variable 'alerts' only supports values of types 'Array'.

[vikulkar]

Hi @Superfly69 ,

You can make use of the Parse JSON action to parse the output of the API call.

There are many useful links available online on how to use this action and how to retrieve the output.

One link you might find helpful is: http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

Thanks and Regards,

   Vikas K

[Superfly69]

Thanks Vikas.

Yes I am using Parse Json and have reviewed the link.

My flow is running now but when it gets to the last step which is to update a row in excel all of the inputs are null...

Any idea why ?

https://ibb.co/9hQdSCW