topic Re: recipe Airtable and Box in Workato Pros Discussion Board

recipe Airtable and Box

srlakeepic — Mon, 24 Apr 2023 20:52:47 GMT

Hey all, so I'm having some issues, with some logic on my recipe.

The ultimate goal is this: Search Box for existing Year folder first, if there then search for next variable, ClientID, if there then search for MoDaYeBox Folder (All folders based on Airtable fields)Once all those folders are found and or created if NOT found, then finally, a Box shared link is created, and then pasted into an Airtable field (Box Link).

That's the recipe above. The problem is, when search DOES find the folder, how will it know to NOT create the folder, but stay inside that folder as the new parent folder?

YEAR
1. CLIENTID
  1. MoDaYeBox

Year folder, then ClientID folder, finally, MoDaYeBox folder.

From that final MoDaYeBox folder, a Box shared link is generated.

Then that box link is pasted into an Airtable field.

Any ideas how to proceed differently? Right now I get 404 errors because the previous Folder ID doesn't exist, even though it does.

Re: recipe Airtable and Box

gary1 — Mon, 24 Apr 2023 21:21:35 GMT

It's all mostly in place, I think you just need to implement more variables to store the "ID to use" for each tier regardless of whether that ID already existed or was freshly created.

Create variables for YEAR_ID, CLIENT_ID, and MDY_ID
Search for Year folder
If Year folder is found, update YEAR_ID variable (add immediately this after step 3)
If Year folder is NOT found, create folder and then update YEAR_ID variable (add immediately after step 5)
Search for Client folder in YEAR_ID
If Client folder is found, update CLIENT_ID variable (add immediately after step 6)
If Client folder is NOT found, create folder and then update CLIENT_ID variable (add immediately after step 8 )
Search for MDY folder in CLIENT_ID
If MDY folder is found, update MDY_ID variable (add immediately after step 9)
If MDY folder is NOT found, create folder and then update MDY_ID variable (add immediately after step 11)
Generate Box link for MDY_ID

Re: recipe Airtable and Box

srlakeepic — Tue, 25 Apr 2023 22:36:25 GMT

I will build upon that. I knew I was missing something, just wasn't sure what it would be. A few of Workato team built over the top of one of my attempts, and it didn't work either, so I got increasingly frustrated. Used if statements, then if/else, but each trial failed.

I really want to write this correctly, as it'll save a lot of time in the long run of a lot of manual work.

Thanks! I'll give it a whirl, and let ya know!

Re: recipe Airtable and Box

srlakeepic — Tue, 25 Apr 2023 22:41:27 GMT

So when you say implement more variables, you mean create new ones and not write over the initial ones, as they store what Airtable has and would be used eventually in the recipe?

Re: recipe Airtable and Box

srlakeepic — Tue, 25 Apr 2023 22:50:00 GMT

Unfortunately, I'm not given any options to place year fold id found as it's not showing results from search.

Re: recipe Airtable and Box

gary1 — Tue, 25 Apr 2023 23:06:26 GMT

In step 5, you need to first check the box next to which variable you want to update. Then it will give you an input field so you can use a data pill from step 4.

Also, I can't be sure because I don't know the recipe perfectly, but I think you have too many variables. For example, what is the difference between "Client ID BOX" and "ClientID Found" ?

Re: recipe Airtable and Box

gary1 — Tue, 25 Apr 2023 23:07:52 GMT

Based on your initial screenshots, you're very close to having this working. I'm a bit surprised that someone from Workato wouldn't be able to resolve this. If you keep providing updates, I'll help get you over the finish line!

Re: recipe Airtable and Box

srlakeepic — Wed, 26 Apr 2023 15:24:23 GMT

So I'm getting the 404 error, perhaps I implemented your instructions incorrectly?

Re: recipe Airtable and Box

srlakeepic — Wed, 26 Apr 2023 15:25:55 GMT

I'm getting a 404 error still, so it's not finding the folder id, I'm guessing? Not sure.

Re: recipe Airtable and Box

gary1 — Wed, 26 Apr 2023 15:43:05 GMT

The screenshot you provided doesn't show the 404 error. I'm not entirely sure how the Box connector/API works, but I'm guessing if you search by an ID that doesn't exist, it might return a 404. In this case, you can put the Box step in an error handler to catch the error. Once it's caught, you can create the folder.

Think of it like this:

Search by ID, then...
- If ID exists => update the variable
- If ID doesn't exist (404 error) => create the folder/ID => update the variable