Hi Klipfolio Gurus,
I have been trying to load data from multiple pages dynamically and use it in one klip only from CallRail API
I have read this great post where you have answered in detail and also this one with more explanations - however, I am still facing issues in loading datasets through Callrail API in certain steps within it.
My problems are as follows:
1. How many data sources are you finally loading in the klip? Static or dynamic or both of them?
2. Where is the final query with "MAP" exactly added?
3. How to make sure MAP reads all rows of all datasets - currently, it shows up only same data or reads it only 4 times etc as shown below?
My formulae and the state currently - it's only showing 4 values when I divide by 250 or if I use "total_records" - it just repeats the same data for total number of rows or shows up 4 times.
Note: $page = 2 and both static and dynamic datasources are added in this klip for now.