Great, so I’ve done some setup. As you can see, this is no longer grayed out. And over the course of this, what we can see is I’m now able to run this template.
So what I’m going to do is click run here, I will run it once, like so. And what I would expect to see is a list of users being pulled down, and then those users being appended into Google Sheets.
So now that the cycle is run, we can look at the data that has been pulled down from Salesforce in the step data. And this will look at each transaction as it comes through.
Collection Splitting
So here I have one user, despite the total size being seven. For each of these transactions, as you can see here, one of seven split. Each of these transactions contain the information for a single user.
Now, this transaction splitting is something offered within Cyclr and it’s collection splitting essentially. So when an array comes down, instead of sending them all through as a single array, it splits them across into individual objects and sends them out to the system.
Now in some cases, this is very useful as you have advanced filters, you want to move things objects out or get extra information for each individual object. And in other scenarios, you might be able to just map directly into the array.
So for this first one, what I’ve done is I’ve taken that information and push them through into the Google Sheet spreadsheet one at a time. So I made one call to get the information. And here I can see what I’ve sent out, which is seven individual calls with the information that has been acquired from the Salesforce demo connector.
And here I can see what I’ve sent out which is seven individual calls with the information that’s been acquired from the Salesforce connect. Now that’s fine. And that’s seven different calls, but if I wanted to make it so that I just uploaded the array directly, Google Sheets is an example of an API where you can upload the array, I can turn off this collection splitting.
So what I’ll do here is I’ll run this again, just to show you the difference between these two states of Cycle.
Okay, so we can see that this Cycle is run again. Now, if I look at the step data, what I’ll see is a single request, and it has the information for each user that has been pulled down. And that’s all been appended and sent into the spreadsheet as a single call.
So this can increase task efficiency, provided the API allows it, and you manage it correctly.