Getting UCC Data from Alabama Secretary of State


Hello there today. We’re going to Alabama and we’re doing UCC searches. So we’ve done a lot of secretary of state work. This is still kind of in the secretary of state range. So instead of doing, you know, what is, what happened? They woke come looks like it’s off of like this.

Oh, I just bumped. That’s why I allowed, sorry, look. It’s like, that’s like look in the wrong direction. Isn’t it. Okay. We’re going to go back to where it was. I dunno, maybe I’m centered. No, I’m off to the side. I don’t know something that doesn’t mean, okay, here we go. UCC now UCC filings are uniform commercial code and the Stanford liens.

And so when someone files a lien, Alaina’s something, when you haven’t paid your bill or even, maybe not, it doesn’t even have to do it that it says, Hey, you were going to do work for me. So I’m going to put a lien on this property, Justin, Justin, making sure I get paid. You finished the property and this ensures that, Hey, I get a chunk of that to make sure you get paid.

So this is something that people, a lot of times use when they’re extending credit. They want to see if there’s a bunch of liens on this person’s name already. All right. So here we are. I’m going to say good checkout ranch. Oh no, it’s good. Checkout B Alabama. There we go. And here we are in Alabama, we’re going to try to get some UCC records.

So they had this search here inside their secretary of state. You can come over, you enter this. I think this is what we’re going to. The first remote search. I think this right here, we’re going to have a copy. We’re in a copy of that baby as no JS fetch, or they call us response equals await, and then paste it.

Okay. Now we have things that we send and it’s probably over here in the body, right?

Okay. Type. All right. So we’re going like this and we’re like that. I’m going to like that. And then we’re going to pass in business name and code. You are a component and we’re gonna say business. Because I’m passing into this function, that business. And so what’s happening. Someone submits the API business name, it goes out and finds it from the secretary of state.

And then once it has, so you can see it here. It’s going to go over. It’s going to get the business details, which is searching for business, whatever it gets, the business name. Once it has this, it’s going to check to make sure it has a title. So make sure we have a valid title, actually, then it’s going to go submit it in here and see what we’ve been refined.

And that’s what we’re trying to do. So this is new to me. And I say new, as in, I know the theory, I haven’t done it very much. We have one example in Idaho and Alabama is the second state we’re working on. So we have some models built out already of what we expect to be there. They seem to be pretty similar in all of them and that’s what we’re going to go through.

So if I go through here, I would want all of those. So I think I’m might to open every single one. So I’m going to go with this first things. First, I’m going to go constant. I need to get the text out of it. It’s going to HTML await response. We’ve got to convert this. There we go. And then we’re going to say constant dollar sign equals bacteria.

Where do you share your for this parts? HTML? Well, PARCC. What does that say?

Where’s this,

what the heck?

I do this. It’s going to mess up everything. I don’t know what version I’m on. What is this?

Okay. I don’t like that. Whatever. I’m not doing it. I’m going to go with the deprecated method one day. We’ll go with that. We’ll go. We’ll probably go through something that talks about this updated. What version of me? I don’t even know day. What does this air

okay. What’s my area. Yeah, look. Oh, cheer it out. Load. Okay. It doesn’t mean. We’ll see what happens. Okay. I’m going to try it out load. I don’t know what I was thinking. Parse HTML. Okay. And then when you get a list of all this stuff, now, this is the hard part. I know this is small. Really apply impossible to read it.

Especially if you’re on mobile, we’re gonna go over here. We’re gonna get the list of this stuff right here. It’s going to be this table. Let’s look over here and see if we can say table, body VR. Is that going to be this all? I think if that’s all there is.

I think what we want, only thing we want is this are these links, because then we’re gonna go to each individual one and get all the data we want.

yeah, I think that’s it. Okay. Here we go. So, first we’re going to say a list of, I want to say URL

Of things. Sure. And it’s going to be string. It’s going to be a Ray of strings like that. And then we’re going to say, Hmm,

it’s rows equals. It’s going to be that just not that this. Simple just T body tablety by tr and then we’re going to loop through these. We’re going to say rose that each one, the index number two, re, and then we’re going to say element. This is where it’s gonna be mad at me. Maybe buy something that auto updated I don’t

can can’t get out of here.

These carrots sometimes punch me in the face and I don’t like that. Okay. Yeah.

Okay. Now each one we’re going to go through, it’s going to be the first TD and we’re going to have a,

and we’re going to go common space. Domain equals well it’s openness or I did. This guy right there. Let’s see, rip rubber, add that in there based domains get, include this thing, CGI. Okay. So there’s our base of main and then as a slash after. Okay. So then we’re going to go like this and we’re going to put in these array of strings.

Okay. Now we are going to go dollar sign and we want just really the TV and the type one a, and we’re going to do a sculpted to the element, and we’re going to say attribute HRF. That’s what we’re looking for. And this is going to be the constant path. And then we’re going to say, URLs have been. Push. And we’ve got to push in the base domain with the path.

Dig is what we’re doing here is gonna look like this. We’re gonna get this URL that you can’t see, but it starts with a slash trust me. And then we’re going to get the base to manage is concatenate it in there. We’re gonna have a bunch of rails of.

And I’m going to say, that’d be an index local, right, Alabama here. We’re going to go like this. We’re going to say that UCC data. Ah, not that. And then we’re going to go like this. Wait, get UCC data. Was this business name? This thing.

Huh it auto corrected the ended that for, okay. You can’t run Alabama local. And if we did this right, we should see a bunch of URLs like this.

Beautiful. This is bad. What’s going on here? It’s probably cause this is a row.

Everything else looks good. Needs to be trimmed. I think that’s got like that, that trim. Let me be like this. If path, when I couldn’t do it, if it’s up the fine, like it just happened. All right, let’s go again. And then when we have those things, then we’re gonna look through them for you. URLs of lean knees.


I guess that’s trimmed. It’s probably just cause yeah, that looks better. Okay. Okay. And now we go to that URL. It should take us here and then we’d go do that stuff there. Now, remember we’re making the UCC data. So I think we go like this, right?


okay. And then we go, wherever this, I can just go this honestly in detail, the indeed

await fetch URL that we can do that. Let me say in HTML. It’s almost like lean get it Cheerio or yep. Equals

trying to whatever. Okay. What am I doing? Doing something lean, HTML. I need a dollar. I don’t like doing this because it’s easy to get confused. Okay. We’re going to put it in its own function. I guess I remember Burberry factor to function in module scope, and we’re call this, get lean detail that passing this and look at this.

We can be a lot better than, and, but like this call, this response go. HTML equals await spawn stock, text, look, see how better that is. Cheerio that load HTML. There we go. Now we need to get some stuff who’s with me. Let’s do it now. Like I’m gay. So come on. We’re here. We get this stuff, Stephanie. Yep. And here, what were our goal?

What is I want to see what’s in this, so we’re trying to fight. By the way that fix it. It did look governor that carrot fixed it right up. I showed it who’s boss just stay in the past. It never use the new stuff. Okay. So we want first to file number.

This is our goal ECC data. That’s going to be, I used to see.

That inside this we’re gonna need to file a number, something here. Right?

What else are we gonna need? I have my models because this whole thing.

Let’s go now, let’s go like that. So first we need the file number. Let’s do that. We go over here, get this thing. We can split on that. I’m going to do it.

Okay. Oh, there’s four of them. You end up type one sometimes into type one works here. Sometimes it does it. Nope. That’s not work. Okay. We can figure it out. We want the first one. So. Tables all there’s only one table. That’s not true.

Okay. Then we’re going to say

he had one. Nice. There we go. Let me go like this. We win and then we have to split it. So first things first is we’re going to go.

File number equals this text dot that split. And we’re gonna split on M B S P like that, and read, take the second part right there. And then we’re going to trim it up like that. Hey, guess what? We have a file number. Check you check. No. When you do find dead tours, what other items we have in this though?

Type. Okay. I can get that right here.

I think I want to loop through every single one of these.

Let’s go T body PR all those. Yeah. That’s what I want.

I’m gonna say con Strauss

and things like, oh, we’ll work that out. I’m going to say, and it’s going to be T by tier. Ah, that’s not it key body PR and I’m ready to throw them.

Nope, not that we’re going to do that each cause. That’s how we do it. Cheerio index number, element, Cheerio dot element. NA what’s the,

what is that thing? Checkup, phone number. What was that? Even. We’re going, we’re getting the rose. Now we’re going to look through each one. I think we got to switch case here. Right? I think we did this already switch. I like that. Hmm. This go with that. We’re going to go constant label.

I like how they do this in Arizona. It’s going to be this scope to the element that text to thank you very much. And the value will be right outside of that.

All right. No. I’m glad that we default the only you fault break like that. Something you switch gates in a while, but I think I do need to break out each one of these. All right. So first things first, and I want to trim all these cause I liked it better that way.

So first things we’re going to say, filing date 10 filing type, right?

What’s the difference here. Wonder

filing type at means. I’m going to go.

I mean, is it not supposed to be like that value?

there we go. Maybe it is. Okay. Now go like this. We keep rolling. Next on the list is going to be original filing date, time like that, and this is going to be filing date.

But find it people’s lists. I see there’s all this stuff in here. I don’t want that. I’m gonna replace them with them, these spaces. So we’re going to value dot replace. It’s going to be this in D S P N G a that’s replacement single spaces, but we can also do this S. Like that. So any if there’s multiple spaces, it’s also in the group place with single spaces.

So that should be pretty. And it’s going to be filing type by lien date. Right, right there. Okay. And now we keep going, what else do I want on my list? Status probably sat us. Yeah.

And then we’re going to go this, I don’t know how good this is to do this, but I tell him do it. Now we’re going to say status equals value status. Is there anything funky there? I don’t think so. Looking great. Looking great. Now what else do I care about lap state, which is my expiration date. Okay.

Lapsed date. And I’m gonna come over here to status and say, okay, this needs to be expiration date. And I’m going to go with lap state medicals that I think we’re all good there too. So it doesn’t have any weird stuff in it for now. We’re going to come down here. We’re good here. We’re good here. Now, if now we get to the funky stuff here, dead tour.

And for me. Got to break that up and that’s not going to be that fun.

Okay. Maybe also bad. And maybe I can do that. You probably have something to, I mean, we’ll see here, we have our debtor information. This is when we’re going to go like this constant debt tours. I DEC tour,

I got my models. Yeah. Give me that guff. I know you exist


dead Tor. Nah, there we go. Now, if it’s dead information,

then we are going to say.

Well, what just happened here? Let’s say

parse address. How are we doing address BR your line? How are we doing that then? How are we doing this? The nice thing is, is okay. So I think what we need to do is strip off the first one, right? That tour. Yeah. So if we hit a debtor information, we’re going to have this constant split on VR,

const debtor name

equals value dot split on VR. Split on BR equals this. Okay. And that’s going to be like that. And the debtor name is going to be split on BR zero. That trim it’s going to be the first one. And then we’re going to go like this split on VR dot splice removes element from array zero and one. I think that means we.

The first one. So we’re going to pop out the first one, and then we’re going to say cons like this, right? Isn’t it like this? And we say equals parse. I just be on the line and we’re going to sentence, but on VR and magically, why, why does it look like this? Oh, I just want value. Wait, I’m already split. This is weird.

This is, wait, are we doing it now with the BR, but the BR back after we take it off, very strange.

Whoa, what just happened here? Now we should have a street city, state, air, city, state, and zip from this. And then we can go like this, that doors dot push. I think in here we have a name it’s going to be a better name and we have a street that’s going to be street address. And then we have a city city, and then we have that state that’s going to state.

What else you got the person’s name? There was zip.

Is there anything else that needs to be in a debtor information? Nope, that’s it. Okay. Now we go secured party. So that should take care of this and it should push each one of them in there. So now we go again. We’re going to go that information here. Yeah. Yeah. I know this is going to be secured, secured party information, and it’s going to be.


maybe add this

secure to parties. I secured party like that.

Nope. That’s wrong.

Same thing I think here,

and I like these very much, but it’s something. And then

if I could say to that,

hi, fine. Whatever const debtor address.

Yeah, I know.

Yep. Come on. You’re getting there. There we go. And then we go get this, let secured party address info.

Big question marks here. If this is going to work, this needs to be secured. This needs to be just named.

No. Okay. Now we’re going to go

secured party named like that deal with it. Okay. All right. Now we’ve got a file number. We have our debt tours are secured parties at no semi-colon though. Just calmness. We have our type filing type. All right. You just call the type. I prefer filing type by far

lean type. There we go.

Filing date status X or lap state image URL. That’s interesting. I don’t think we’re going to have that here. That’s why I say, okay, perfect. Now let’s see what we get. I don’t need those question marks that’s for sure. These are not optional parameters and then you return it.

It’s a lockout. Okay. Now we’ll get these stuff. We’ve got like this. I’m going to remember when we turn, see Veda. And I think I just want to push.

Air or giving Lina details

when you R L sure. And then where we just Nothing. Right. Aren’t we already MTA your’e here we are. Now I need to push it though. UCC data push like that. Sure. What we got now, I want this.

five. Why do I have five pages of package luck? Okay. Okay. We’ve got some errors. Yep. We definitely got some hairs here. What’s going on?

Where? Gross. Oh.

Don’t split on that.

The fact that it’s

File number. I need that.

Get it from the URL. Let’s try that. Let’s go. A URL dot split on C easy C equals.

And then we split again now one right, split on M ampersand.

Put that. I like that.

dun, dun dun. Hey, if we get this done in 29 minutes or 35 minutes, that’s pretty good for, I first stab at UCC data. Keep hydrated people. Yo, no secured parties. Hold up.


that looks good.

Oh, well they all have secure parties. They might not, I guess, but no, none of these deal, which is wrong. Okay. So we need to change.

oh, look at that.

That would do it. Can we stratify this maybe so we can see it. It’s going to be a lot and ugly. I don’t know, zero and I don’t know what six, three. Sure. So that on for size, this is nice. I can do it locally. Alaska is next on the list and that’s going to be a little bit slower.

Not to not work it.

Okay. This weird thing I’m doing obviously is messed up. So we go over here. We’ll get this.

when I say edit it’s HTML. I want the whole thing, please. That is techs. Yeah, there we go. This whole thing, we’re going to say clear. And we’re going to say info equals tactics like that. And then if we say info dot split on VR, or do we good? Yep. Before you break. Okay. And then we say

that’s going to be split on VR because of that. And then what if we say split on BR zero, that looks just fine. Let’s look at this value.

It’s just getting the text. I get it. Right. Right. Makes sense. Gotta go ahead. This homies, it’s not HTML. We gotta go like this.

I’m a mum, mum dot HTML like that.

They’re both or they got

UCC data for Alabama OPA. Okay. Yep. Oh yeah. Oh yeah. Yes, yes. Oh yeah. Look at that. That looks great.

What what’s going on here?

Like this? I just wanna go right to this, maybe.

Hey, what? This is even here.

Well, I’m going to solve that right now. How do they even happen? Okay. Whatever we’re gonna say, give the police anytime there’s any extra spaces we can just get rid of them. Thank you very much.

Yeah. Now let’s try that. Emphasize. We should also deploy. Let’s go get commit, Alabama search, Alabama, UCC data. And we’re pushing this guy in the meantime.

Okay. How are we looking over here? Oh, it’s all shrunk because it’s hard to see whatever run it again.

My mum, my mum, what are those put the I’m looking at? I didn’t care about that. Okay. Actions. I would like to see this thing building it’s going okay. Okay. Good. Beautiful, beautiful, beautiful. Yes, yes, yes. Yeah. Yes. They’re called different names. That concern.

real concern.

Okay. Now it’s deploying right now. We’ve got our SDK out here.

You lose a business in Idaho called swords of honor. Pretty new.

I think I’m passing in. I don’t even know my, here we go. It’s gone. Knew it. That’s good. And Deb,

we did this right. I should’ve returned here. Did we do it right? I’ll say.

I couldn’t find this exact business thinking. That’s why I was afraid of

I won’t, I won’t fix this one out of Nafion. Okay. Oh, Idaho, hold up. Ooh. Maybe there’s still chance thinking I need to publish a new API. Do I even want that, man? I got really make decision here. Hmm. Should UCC data be included in all requests? I could slow it down. I’m not charging extra for it, but I’m saying it could slow it down because then as to go also get a UCC.

If you don’t need it. My fellows look, see, check, check, check. We’re done. This video is done, Alabama. Done. Thanks. That’s it.