How To use iterations for API

[petchd]

Hi All,

I am fairly new to UFT and I am looking for some advice. Currently I have a API Test which contains several GUI Tests, currently I have the API running two iterations which works correctly but my issue is the last GUI test inputs data from the global sheet, I want it to be able to work its way through the data (a row at a time) with each iteration I perform, it is important though that the GUI tests before this test be run first. I hope this make sense, essentially I want the API test to run however many iterations I want but the last GUI test must change the row it pulls data from. I hope someone can help me with this.

[petchd]

Also attached an example flow of what I am trying to achieve, so essentially everytime I run this flow I want the "enter Order Number and Search.Action 1" to get information from the next row on the table