I have a question regarding the Google Analytics Query node. I am trying to loop and get x-times 10.000 results until the Google Analytics Query node comes back with an empty table. But how would I do it? I tried using the empty table switch and also the table row to variable node to look for an empty variable but could not get it to work.
You can not wrap a if around a loop end. If constructs as well as loops have to be treated like brackets. If you are opening a bracket, you need to close if before another one opens up.
What you need to do inside the loop is: Generate a flow variable containing the number of rows and use this flow variable to finnish the loop when it is 0.
It is worth to mention that Google Analytics does sampling. The bigger the timeframe the less accurate are the numbers delivered by the API. So a month doesn't deliver accurate results - choose exporting daily results instead and merge them in the end. This is why i use the first chunk loop to deliver smaller timeframes. Whether sampling will be applied can be checked using the Query Explorer — Google Analytics Demos & Tools.
Hi Andy. New to knime and suffering from information overload.
I know this is a long shot (given the time difference in posts), but I arrived at this forum because I was looking for information on how to loop GA api calls and this is the first place that seemed to have relevant information that made sense. I was wondering if you would be able to share the actual workflow (obviously with sensitive information removed) for the image your shared to see some of the inner workings. I think I understand it in principle, but it would be really helpful to see the variable flow etc.