Workflows Tips #36: Kandji Connector, Build Your First Workflow Online Meetup and Count Number of Rows in a Table
Tags: nocode, workflows, kandji, automation
Published: 2022-09-12 18:58:16

---
title: Workflows Tips #36: Kandji Connector, Build Your First Workflow Online Meetup and Count Number of Rows in a Table
published: true
date: 2022-09-12 06:41:15 UTC
tags: NoCode,Workflows,Kandji, automation
canonical_url: https://maxkatz.net/2022/09/09/workflows-tips-36-kandji-connector-build-your-first-workflow-online-meetup-and-count-number-of-rows-in-a-table/
---

Welcome to another Okta Workflows Tips post. Read all other tips ⤵️
{% embed https://dev.to/oktaworkflows/okta-workflows-tips-57bj %}

In this post:

- Kandji connector video
- Build Your First No-Code Workflow Automation online meetup
- Count number of rows in a table

Workflows has a new [Kandji](http://kandji.io) [connector](https://help.okta.com/wf/en-us/Content/Topics/Workflows/connector-reference/kandji/kandji.htm) that allows to automate Apple device management.

[![Kandji connector in Okta Workflows](https://katzmax.files.wordpress.com/2022/09/workflows_tips36_kandji_connector.png?w=836)](https://katzmax.files.wordpress.com/2022/09/workflows_tips36_kandji_connector.png)
<figcaption>Kandji connector in Okta Workflows</figcaption>

Watch this short [video](https://youtu.be/ogx7jvBWVFM) to learn how the Kandji connector in Workflow helps with Apple device management:

{% youtube ogx7jvBWVFM %}


_The video features [Arek Dreyer](https://www.linkedin.com/in/arekdreyer/). Arek is a Senior Product Engineer at [kandji.io](http://kandji.io/), which provides next-generation Apple device management for macOS, iOS, iPadOS, and tvOS. Arek spent over 20 years as an independent trainer, author, and consultant, and in 2021 he joined Kandji. He was super happy to discover the [community of admins](https://www.macadmins.org/) that love helping each other solve problems in the Okta Workflows space._

## Online meetup: Build Your First No-Code Workflow Automation in 25 Minutes

We have another no-slides online meetup is coming up 🚀.

**🔮 Why it’s worth your time**

Join this no-slides online meetup to learn how to build your first no-code workflow automation with Okta Workflows in 25 minutes.

**🔭 You will learn**

You will learn step-by-step how to build your first no-code workflow automation and also: 

- Building a flow with the basic building blocks (events, schedule, actions, functions, and connectors)
- Testing and running a flow

And, stick around to get your questions answered. This is a no slides session (well, maybe just one or two at the beginning).

**🎟 When and register**

- When:  **Wednesday, September 28, 9 a.m. PT**
- I want to attend: [register now](https://www.crowdcast.io/e/build-first-nocode-workflow-automation)

📡 And one more thing, follow our [events channel](http://crowdcast.io/oktaworkflows) to get notified when we go live.

## Count number of rows in a table

To count the number of rows in a table use **[Tables – Search Rows](https://help.okta.com/wf/en-us/Content/Topics/Workflows/function-reference/Tables/stash_searchrows2.htm)** to search a table without a condition. This will return all the rows (see a note at the end about this). Then, use **[List – Length](https://help.okta.com/wf/en-us/Content/Topics/Workflows/function-reference/List/list_length.htm)** card to return the number of items in the list.

[![Counting rows in a table](https://katzmax.files.wordpress.com/2022/09/workflows_tips36_count_rows_table.png?w=988)](https://katzmax.files.wordpress.com/2022/09/workflows_tips36_count_rows_table.png)
<figcaption>Counting rows in a table</figcaption>

This is a _simple_ solution. It will work up to the limit of the search rows card:

> Maximum number of records to return. If a filter or limit is not applied to the table search, a maximum of 3,500 rows from the selected table will be read by the Search Rows function card.
> 
> <cite><a href="https://help.okta.com/wf/en-us/Content/Topics/Workflows/function-reference/Tables/stash_searchrows2.htm" target="_blank" rel="noreferrer noopener">https://help.okta.com/wf/en-us/Content/Topics/Workflows/function-reference/Tables/stash_searchrows2.htm</a></cite>

This is a good solution if a table has less than 3,500 records.

Here is a solution from [Tim LaBorn](https://www.linkedin.com/in/tim-laborn-b0574a10/) (Senior Technical Support Engineer for Workflows at Okta) if you have more than 3,500 records:

> The table itself has a maximum of 100k rows. It is possible to return a list of all rows but that would take considerably more logic than the example provided. The search Rows card has the ability to set an offset. You could potentially make a Helper flow that search a table in a loop growing by the offset value you are using while combining lists until the search rows returns no results then stops the loop. The final combined table could then have the length used against it to get the total count.
> 
> <cite><a href="https://support.okta.com/help/s/question/0D54z000082Z1ndCAC/workflows-function-to-return-the-number-of-rows-in-a-table?language=en_US" target="_blank" rel="noreferrer noopener">https://support.okta.com/help/s/question/0D54z000082Z1ndCAC/workflows-function-to-return-the-number-of-rows-in-a-table?language=en_US</a></cite>

* * *

**Two resources to help you learn more**: 

🎥 Short how-to [Workflows videos](https://youtube.com/playlist?list=PLIid085fSVdvyK8F4xuk49EchBPmAVNHG) to help you become a better automation builder.

📘 Read our [Workflows How-To Guides](https://maxkatz.net/okta-workflows-how-to-guides/) based on community member questions.