I have a table in a klip where I have 2 columns: "offerid" and "goalid", which is properly configured and populated.
I also have a dropdown tied to a varaible "affid" which is also working fine.
I have a 3rd column in my table called "payouts", to populate it, I must call upon an API with all 3 of the above parameters, in order to receive the payout.
API (example, not working link) -
For the API to work, I realize that I must have all 3 parameters saved as variables.
It's easy and done with the drop down (affid).
But the other 2 columns are a bit more tricky.
Had I only had 1 column, I would have use a simple MAPFLAT to iterate over the offerid OR the goalid, saving to a varaible, calling the API each time...done!
However, since I have 2 parameters, and both are needed for each request, it is like a two-dimensional MAPFLAT (one inside the other).
I tried that, but the end result was that I got WAY too many rows as a results as the two mapflats multiplied each other.
Maybe there is another approach? I saw in the community an approach to use REPEAT within a MAPFLAT with a SET inside... didn't manage to get it to work.
At the end of the day, I just need your help to store for each row the 2 variables, so that I could pull the correct data from our API.