cancel
Showing results for 
Search instead for 
Did you mean: 

recipe Airtable and Box

srlakeepic
Deputy Chef II
Deputy Chef II

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

 

srlakeepic_2-1682369281556.png

srlakeepic_3-1682369298423.png

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?

  1. 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.

 

 

 

9 REPLIES 9

srlakeepic
Deputy Chef II
Deputy Chef II

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

srlakeepic_0-1682462965516.png

 

gary1
Executive Chef I
Executive Chef I

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" ?

srlakeepic
Deputy Chef II
Deputy Chef II

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

srlakeepic_0-1682522658015.png

 

srlakeepic
Deputy Chef II
Deputy Chef II

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

srlakeepic_0-1682522725336.png

 

gary1
Executive Chef I
Executive Chef I

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