I just wanted to add to this, that you can also count items using a code step if you feel confident with that. The main advantage here is that it would be a single step.

The ‘list’ input value should be line item list you want to count.

The output will be the number of items:

Here is the code to copy and paste:

var count = inputData.list.split(',').length;
output = {count: count};

Hi there! I have a Webhook GET step that returns a JSON array and Zapier plays nicely through the elements of the array. However, I don’t want my whole Zap to be played as many times as items in the array. I only want a few steps to be played for each element, but then I want to “break the loop” and play all remaining steps only ONCE.

I am not using a Code step as of now (and also am not intimate with programming). So I do not know how I can break the loop since I didn’t figure out how to determine the size of the array (it is variable)...Is there a way to “break the loop”?

@David@Zapwise 

Unfortunately not! I wonder if you could use Zapier Storage to store parts of the array each time it runs, then somehow trigger a followup zap on the contents of that.

Hi Andrew…thanks for your reply! 

...hmm are you saying this can’t be done or this can’t be done WITHOUT a code step

From what I understand from this post...

...it’s is “common practice” to do this when you work with line items. Or am I misinterpreting this conversation? If so, I probably could turn my array into line items quite easily...Probably is a bit heavy on tasks but well...I’m just surprised there is no go-to solution with a Code step.

...thinking about it again: So does this mean, I don’t actually have access to the actual JSON array but Zapier processes it before it is passed to my Zap and only forwards one item at a time? I’m new to this, but noticed that in Postman I GET the whole array whereas in Zapier I only always GET one item. Is Zapier’s behaviour with arrays as input described anywhere?

And thinking a little more...I could probably store everything I need from the array in Zapier Storage and trigger a second Zap BEFORE the array is processed, have the second Zap WAIT for an arbitrarily fixed amount of time, and then run based on the assumption that by that time, the first Zap has completed with all iterations and that it can access the data from the array in the Zapier Storage. But, that looks to me very dirty and not cool.

So..thinking a bit more ...could i not build an array/line item object via Zapier Storage and then use this in a second Zap, once this first one Zap has completed running through all the items of the JSON Array?

Hi @David@Zapwise 

Yes, I think that might work. You certainly don’t need a code step to do it that way.

Report back and let us know how it goes!

I just wanted to add to this, that you can also count items using a code step if you feel confident with that. The main advantage here is that it would be a single step.

 

The ‘list’ input value should be line item list you want to count.

The output will be the number of items:

 

 

Here is the code to copy and paste:

var count = inputData.list.split(',').length;
output = {count: count};

 

Thank you so much for sharing this. It’s proving very useful to me. Although I don’t suppose there is a version of the code that would only count lines containing a specified string of text? i.e. “Shipping”. That would be amazing!

@MGZ 

Here you go 

var count = inputData.list.split(',')
var shipping = count.filter(function (shipping) {
  return shipping == "Shipping";
}).length;

output = {shipping};

var count = inputData.list.split(',')
var shipping = count.filter(function (shipping) {
  return shipping == "Shipping";
}).length;

output = {shipping};

Thank you so much! I’ll give it a go :-)

I just wanted to add to this, that you can also count items using a code step if you feel confident with that. The main advantage here is that it would be a single step.

 

The ‘list’ input value should be line item list you want to count.

The output will be the number of items:

 

 

Here is the code to copy and paste:

var count = inputData.list.split(',').length;
output = {count: count};

 

You just saved my day! I was looking for exactly this for hours, until I found this topic and got it working in less than 10 seconds!

var count = inputData.list.split(',')
var shipping = count.filter(function (shipping) {
  return shipping == "Shipping";
}).length;

output = {shipping};

This is awesome! Question: Can this be modified so that it looks for 4 different words and return the individual count of those 4 words?

@PaulKortman, thank you for this, I’ve got it working great, except when no line items are available. My zap fails because there is nothing to sum.

In my case I have two ticket types and I am trying to sum them but either of them could be zero and therefore in some cases there are no line items available to be summed.

I have tried IF(ISBLANK but that doesn’t work because the SUM function is still evaluated.

I need both ticket type quantities for another system for billing purposes.

Any idea how I can handle this scenario?

Hi, this was really helpful in a project where I need to count a set of inbound line items. I had some issues with the SUM( ) step so I made a tweak that adds a (now FREE 🤩) Formatter step and should be able to handle empty and single-value lists as well.

After the “Line Item to Text” bit where you have text output like (1,1,1,1,1), use Formatter → Text → Replace. Find , and leave the Replace field blank so that it will remove all the commas from your output, leaving you with 11111 etc.

Then you can use Formatter → Text → Length on that output to get the total count of line-items.