Hello I am trying to a simple HTTP post quest based on my google sheet values.
But I cant map the value of the rows, what am I doing wrong?
Can I also catch the response in a email action or Excel file? or update the row?
Each row is a different bundle. You don’t need to use the map function. Just map the company
You will get an http request for each row that the google sheet module will return.
1 Like
Thank for your fast reply however when I map it like this:
And I run the HTTP the values aren’t pulling though:
And when the call is finished nothing has passed or is created:
And I want to log the response:
So when it is 200 do this, when it is 400 then to this etc.
But the first question is why is the mapping not working?
Anybody know why it is not working?
What I don’t understand is this:
The fields are mapped correct but where is this 30 coming from?
And when I run it everything is blank and nothing is created because only the 30 is passed.
And after the HTTP call and I cleared the 30 I get this:
Anybody an idea why this is happening?
If you “Run this module only” on the HTTP module, you’re going to have to enter in each value that would otherwise get its value from a previous module.
Google Sheets Watch New Rows is going to return 1 bundle for each row that is “new”.
That means HTTP is going to run once for each bundle/row.
When you look at the Watch New Rows output when mapping its output to another module, you’re only going to see an example (one row) of the data.
When the scenario runs, it will run for each row of actual data.
All you need to do is map the values from Google Sheets to HTTP like you did here:
1 Like