DEV Community: Max Katz

A Flow to Audit Inactive Google Workspace Users in Okta

Max Katz — Wed, 21 Sep 2022 19:59:56 +0000

Okta Workflows community flows are flows shared by community members. These flows show how to solve a particular problem. You might have the same problem you are trying to solve or a similar one. Either way, these community flows will help you learn and build automations.

A directory of all other Okta Workflows community-created flows ⤵️

All Okta Workflows Community-Created Flows

Okta Workflows Staff for Okta Workflows ・ Sep 21 ・ 1 min read

#nocode #workflows #okta #ipaas

This flow Bilal Habib, IT Infrastructure Engineer for MADE.COM

This flopack audits Google Workspace users similar to the template for Auditing Inactive Okta Users

Bilal Habib

A flow from audit inactive Google Workspace users

Learn more and download the flow from GitHub.

More resources to help you learn :

🎥 Short how-to Workflows videos to help you become a better automation builder.

🍿 A collection of helpful Workflows tips.

A Flow to Automatically Generate Shipping Labels and Email Them to Users

Max Katz — Wed, 21 Sep 2022 14:32:20 +0000

A directory of all other Okta Workflows community-created flows ⤵️

All Okta Workflows Community-Created Flows

Okta Workflows Staff for Okta Workflows ・ Sep 21 ・ 1 min read

#nocode #workflows #okta #ipaas

This workflow is from Jacob Waters, MacAdmins Slack Community member, and a Senior IT Engineer at Astronomer.

If anyone is interested, attached is a workflow I put together for automatically generating shipping labels and emailing them to users. Can be helpful with dealing with offboarded users, device swaps, broken devices, etc. Can easily do this to generate labels for new hire shipments as well.

Will need a ShipEngine and courier (Fedex, UPS, etc) accounts to do so.

Jacob Waters

Download the flow.

Generating shipping labels flow

More resources to help you learn :

🎥 Short how-to Workflows videos to help you become a better automation builder.

🍿 A collection of helpful Workflows tips.

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

Max Katz — Tue, 20 Sep 2022 23:00:10 +0000

Join another Okta Workflows online meetup ✨

🔮 Why it’s worth your time

Join this (fun) no-slides online meetup to learn how to process a list using a helper flow in Okta Workflows in 25 minutes.

🎟 When and register

When: Wednesday, September 28, 9 a.m. PT
I want to attend: register now

🔭 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).

👷🏻 Who should attend

Everyone is welcome of course, but if you want to know, these folks should attend:

Folks who are new to Workflows!
Folks who want to learn about No-Code, workflows and automation
IT Administrators, Integration Architects
Product Manager, Developers, Marketing Operations and Technology Leads
DevOps Engineers and Security Engineers

🎙 Speaker

Max Katz, Workflows Community Advocate (yes, that’s me 😜)

🎥 Previous online meetups

Looking for previous online meetups recordings? Go to our YouTube channel to watch all previous events.

A Flow to Help With Lifecycle Reporting

Max Katz — Tue, 20 Sep 2022 18:37:14 +0000

A directory of all other Okta Workflows community-created flows ⤵️

All Okta Workflows Community-Created Flows

Okta Workflows Staff ・ Sep 21 ・ 1 min read

#nocode #workflows #okta #ipaas

This flow is from Pete Viri. Pete is an Okta Certified Professional, with over of 10 years of IT experience currently working as a Senior IAM Engineer at Faire.

Hey Everyone, I wanted to share a flow I recently created to help with lifecycle reporting. This is a native feature in a lot of SIEM tools, but if you currently don’t have a service like that or want lightweight reporting, this flow will let you know when X users are being added/removed from apps within Y seconds.

This can help mitigate issues that arise from HRIS changes that may cause a large amount of people to be added or removed from apps via group rules. The only thing you need to do is configure your quantity (X) and time (Y) thresholds, and the slack channel you want it to post to.

Pete Viri

Lifecycle activity reporting flow

Download the flow (this is a link to a MacAdmins Slack channel. You need to be a member or join to download).

More resources to help you learn :

🎥 Short how-to Workflows videos to help you become a better automation builder.

🍿 A collection of helpful Workflows tips.

How to Remove Office 365 License From a User Account After Being Suspended for a Certain Time

Max Katz — Mon, 19 Sep 2022 23:34:05 +0000

Okta Workflows how-to guides are questions and answers from weekly community office hours, MacAdmins Workflows Slack channel, and other places.

Read all the other how-to guides ⤵️

All Okta Workflows How-To Guides

Okta Workflows Staff for Okta Workflows ・ Aug 23 ・ 2 min read

#nocode #okta #workflows #ipaas

On to the question.

How to remove Office 365 license a user account after being suspended for a certain time?

Note : I don’t yet have access to O360 Admin account (Workflows connection) so I’m proving a high-level overview of the solution. I will update this post once I have access to a O360 Admin connection.

The solution consists of two flows:

Save the time when user was suspended
- Trigger a flow with Okta – User Suspended card and save the time a user was suspended, their Okta ID, and any other information needed such as O365 login
Use Okta – Scheduled Flow card to check the table and compare the date now against the date a user was suspended
- If the difference between dates is greater than [X days], remove the license from the user and delete the row in a table

This is the first flow (save the time when user was suspended):

Save suspended user information to a table

Table with suspended user information:

Table with suspended user information

More resources to help you learn :

📺 Short how-to Workflows videos to help you become a better automation builder.

🍿 A collection of helpful Workflows tips.

Workflows Tips #37: Iterate Over Rows & Delete Rows in a Table Videos, Build Your First Flow Online Meetup

Max Katz — Fri, 16 Sep 2022 19:11:08 +0000

Welcome to another Okta Workflows Tips post. Read all other tips ⤵️

All Okta Workflows Tips

Okta Workflows Staff for Okta Workflows ・ Aug 23 ・ 3 min read

In this post:

How to iterate over rows in a table
How to delete multiple table rows
Register for build your first flow online meetup

How to iterate over rows in a table

In this vide you will learn how to iterate over rows in a table. The video is based How to Iterate Over Rows in a Table in Okta Workflows blog post.

How to delete multiple table rows

In this video you will learn how to delete multiple table rows in Okta Workflows. This video is based on How to Delete Multiple Table Rows blog post.

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

📡 And one more thing, follow our events channel to get notified when we go live.

Two resources to help you learn more:

🎥 Short how-to Workflows videos to help you become a better automation builder.

📘 Read our Workflows How-To Guides based on community member questions.

How to Iterate Over Rows in a Table in Okta Workflows

Max Katz — Tue, 13 Sep 2022 23:48:57 +0000

Okta Workflows how-to guides are questions and answers from weekly community office hours, MacAdmins Workflows Slack channel, and other places.

Read all the other how-to guides ⤵️

All Okta Workflows How-To Guides

Okta Workflows Staff for Okta Workflows ・ Aug 23 ・ 2 min read

#nocode #okta #workflows #ipaas

On to the question.

How to iterate over rows in a table?

To iterate over rows in a table you need

Find the rows (usually done with search)
Pass each row to a helper flow to process

Let’s look at an example using a table with all the countries in the world:

Country table

In the main flow, find the rows use the Tables – Search Rows card (max. 3,500 rows will be returned). To return all the rows don’t enter a search expression. Then pass the rows to a List – For Each card where a helper flow will process each record at a time.

This is the main flow:

Search for rows

In the List – For Each card, set the helper flow ( Helper Flow input).

Then set the value to pass to the helper flow ( Country row input).

In this flow you are passing the entire row or object (named item ) to the helper flow.

You can also pass a particular property from the object (row). To learn how to do that read How to Setup a Workflows Helper Flow (With For-Each and Streaming Cards).

This is the helper flow:

Helper flow to process a row from a table

A flow becomes a helper flow when the first card is On Demand – Helper Flow. This card has one input Country row. Its type is object because you are passing the entire object (row) to this flow.

You can use Object – Get Multiple card to read values from the object (row) passed to this flow. In this example you are reading the Country and its Code.

Learn more how to use Object – Get Multiple card: How to Read a JSON Path With Dot-Notation in Workflows.

Result running the flow (helper flow shown):

Getting country data flow

The helper flow will run 248 times for each country in the table. It will get the country and and country code.

More resources to help you learn :

📺 Short how-to Workflows videos to help you become a better automation builder.

🍿 A collection of helpful Workflows tips.

Workflows Tips #36: Kandji Connector, Build Your First Workflow Online Meetup and Count Number of Rows in a Table

Max Katz — Mon, 12 Sep 2022 06:41:15 +0000

Welcome to another Okta Workflows Tips post. Read all other tips ⤵️

All Okta Workflows Tips

Okta Workflows Staff for Okta Workflows ・ Aug 23 ・ 3 min read

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 connector that allows to automate Apple device management.

Kandji connector in Okta Workflows

Watch this short video to learn how the Kandji connector in Workflow helps with Apple device management:

The video features Arek Dreyer. Arek is a Senior Product Engineer at 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 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

📡 And one more thing, follow our events channel 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 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 card to return the number of items in the list.

Counting rows in a table

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.

https://help.okta.com/wf/en-us/Content/Topics/Workflows/function-reference/Tables/stash_searchrows2.htm

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

Here is a solution from Tim LaBorn (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.

https://support.okta.com/help/s/question/0D54z000082Z1ndCAC/workflows-function-to-return-the-number-of-rows-in-a-table?language=en_US

Two resources to help you learn more:

🎥 Short how-to Workflows videos to help you become a better automation builder.

📘 Read our Workflows How-To Guides based on community member questions.

How to Fix a 403 Forbidden Error When Using Search Systems Logs Card

Max Katz — Mon, 12 Sep 2022 05:11:11 +0000

Okta Workflows how-to guides are questions and answers from weekly community office hours, MacAdmins Workflows Slack channel, and other places.

Read all the other how-to guides ⤵️

All Okta Workflows How-To Guides

Okta Workflows Staff for Okta Workflows ・ Aug 23 ・ 2 min read

#nocode #okta #workflows #ipaas

On to the question.

How to fix 403 Forbidden error when using Search Systems Logs card?

Okta – Search Systems Logs card allows you to search the Okta log by a keyword (and also expression, set in Options ):

Search Systems Logs card

When a run a flow with this card, you might get a 403 Forbidden error:

403 Forbidden error with Search Systems Logs card

To fix this error you need to grand an additional scope to the Okta connection.

From the Admin Console , go to Applications > Applications
Click on Okta Workflows OAuth
Open Okta API Scopes tab
Find okta.logs.read scope and click Grant
For this scope to take affect, you need to reauthorize the connection being used

Granding a scope to a connection

After you reauthorize, run the flow again. The card is now able to search the logs:

Search Systems Logs card

🙏🏼 Thanks to Bryan Barrows (LinkedIn, blog) who helped with this question on MacAdmins Slack channel.

More resources to help you learn :

📺 Short how-to Workflows videos to help you become a better automation builder.

🍭 A collection of helpful Workflows tips.

Comparing a JavaScript for Loop With a Workflows for Each Card

Max Katz — Mon, 12 Sep 2022 04:41:41 +0000

This blog post compares a code-based (JavaScript) for loop with a no-code Workflows For Each card.

I thought it would be a fun blog post to write.

Thanks to Bryan Barrows for inspiring to write this blog. Bryan shared this image in our internal Slack to help a customer:

JavaScript for for-loop

Ok, so let’s start with a code-based for loop. The JavaScript code snippet below creates a list (array) of strings. Then a for loop iterates over the list and upper cases each item in the list.

// create a list (array) of strings
var groceries = ['Bread', 'Cheese', 'Milk', 'Eggs', 'Apples', 'Butter'];

// loop over the list and upper case each string
for (i=0; i<groceries.length; i++){
  console.log(groceries[i].toUpperCase()); 
}

Output running this code:

"BREAD"
"CHEESE"
"MILK"
"EGGS"
"APPLES"
"BUTTER"

You can view and run this code at JS Bin:

http://jsbin.com

Ok, now let’s look at the Workflows solution.

This is the main flow. It creates a list with List – Construct card. Then it passes the list to List – For Each card (that’s the for loop).

A list is passed to for each

So the above flow is this code:

// create a list (array) of strings
var groceries = ['Bread', 'Cheese', 'Milk', 'Eggs', 'Apples', 'Butter'];

// loop over the list and upper case each string
for (i=0; i<groceries.length; i++){

}

And this is helper flow. This flow does upper case to each item in the list:

A helper flow that does to upper case for each list item

And this flow is this code:

console.log(groceries[i].toUpperCase());

When you run this flow the helper flow is called six times and the result is each text item is converted with to upper case:

Running a flow

And this is how it looks all together:

Code-based (JavaScript) and Workflows solutions

Hope this was a fun comparison and thanks again to Bryan.

If you want to learn more about setting up a helper flow with for each card and streaming, read How to Setup a Workflows Helper Flow (With For-Each and Streaming Cards).

More resources to help you learn :

📺 Short how-to Workflows videos to help you become a better automation builder.

🍭 A collection of helpful Workflows tips.

Workflows Tips #33: Helper Flow Tips, Helper Flow Multiple Inputs and Build Your First Flow Replay

Max Katz — Tue, 06 Sep 2022 14:15:17 +0000

Welcome to another Okta Workflows Tips post. Read all other tips ⤵️

All Okta Workflows Tips

Okta Workflows Staff for Okta Workflows ・ Aug 23 ・ 3 min read

In this post:

Working with helper flow tips
Helper flow with multiple inputs
Webinar recording: Build Your First Flow with Okta Workflows

Working with helper flow tips

Last week I published How to Setup a Workflows Helper Flow (With For-Each and Streaming Cards). This guide shows how to setup a helper flow with For-Each card and the streaming option.

Jacob Walters from MacAdmins Slack channel shared more tips for working with helper flows:

Use a consistent and easily understood naming convention
If your workflows use multiple helper flows, be consistent with naming your variables across them
Helper flows can call themselves (loops and recursion)!
Cards like Reduce, Filter are effectively helper flows with loops and a defined output- great for iterating through lists

Helper flow with multiple inputs

This tip is ahaupt. ahaupt hangs out in the MacAdmins #okta-workflows Slack community.

As long as we are on the helper flow topic, here is a 15-second video on how to create a helper flow with multiple inputs and set inputs type:

Helper flow with multiple inputs

Webinar recording: Build Your First Flow with Okta Workflows

In this monthly webinar for beginners you will learn how to:

Authorize your Okta connector
Build a flow from scratch
Add a template to your Workflows environment
Import and export a flow or a folder

Watch the recording and register for the next session.

Two resources to help you learn more:

🎥 vShort how-to Workflows videos to help you become a better automation builder.

📘 Read our Workflows How-To Guides based on community member questions.

Workflows Tips #35: Duo Auth Connection, Helper Flows Online Meetup Recording, and a New Platform for Online Meetups

Max Katz — Tue, 06 Sep 2022 05:30:33 +0000

Welcome to another Okta Workflows Tips post. Read all other tips ⤵️

All Okta Workflows Tips

Okta Workflows Staff for Okta Workflows ・ Aug 23 ・ 3 min read

In this post:

Creating a Duo Auth connection in Workflows Connector Builder
Creating helper flows online meetup recording
New community platform for online meetups

Creating a Duo Auth connection in Workflows Connector Builder

This tip is from David Minnema. David is an IT Engineer II at Coalition Inc. He also hangs out at MacAdmins Slack #okta-workflows channel and testing12.org.

David published a guide on how to build a custom Due Auth connection in Workflows Connector Builder.

We are in the midst of implementing Duo within our org and want to use it just about everywhere, including Okta Workflows. We have been building Slack slash commands that do some serious changes (more posts on those later) and we thought prompting the user running the command with Duo would be another layer of security (after verifying they are in the appropriate Okta Groups to perform the action to begin with.)

Here’s how we implemented Duo Auth in Connector builder.

Requirements

Duo

Okta Workflows

Connector Builder Beta

Creating helper flows online meetup recording

In case you missed our online meetup on how use helper flows. Watch the replay where you will learn:

How to use a List For-Each card to process a list
How to use the streaming option to process a list

New community platform for online meetups

We now use a new platform for online events called Crowdcast: http://crowdcast.io/workflows. Here are a few reasons why we love Crowdcast:

A community-focused platform for online events
A central page with all upcoming and past events
Follow a channel to get notified when it goes live
Event replay is available right after an event ends, at the same page
Event chat is available before, during and after the event
Runs in the browser (there is nothing to install)

So, go to http://crowdcast.io/oktaworkflows and click the green Follow button to follow us!

Okta Workflows channel on Crowdcast

Two resources to help you learn more:

🎥 Short how-to Workflows videos to help you become a better automation builder.

📘 Read our Workflows How-To Guides based on community member questions.