Flow connecting excel with HTTP API followed by excel output

Like (0) Share

Report

Posted on 4 Jun 2020 11:50:49 by Sportynick

Hi all,

Currently have a HTTP node that is able to connect to an API via post request.

Issue is that only one item is checked each time as a script is typed { "Name": "ABC", "Number": "12345A" } into the input body for checking and expected results are received in output body.

Which nodes should be connected to do batch checking of data?

Intent is to get data from rows stored in two columns (i.e. Name, Number) in an excel file on OneDrive. Results from output body will then be nicely fitted to a new worksheet in the same excel file (perhaps 1 line per input row checked).

Thanks in advance for helping.

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

ChristianAbata 8,949 Most Valuable Professional on 04 Jun 2020 at 12:03:00

Like (2)

Report

Re: Flow connecting excel with HTTP API followed by excel output

hi @Sportynick what you need to do is get your http output response when runs well and then use it to parse json, after that you are going to be able to use every data inside your response see

In my example I'm using the output compose response, just imagine that ir your json http response.

You can see this video https://www.youtube.com/watch?v=eSwdxAJQmJU&t=3s to learn how to use apis.

Was this reply helpful? Yes No