Community Challenge Checker - Updated

[MatthewBr]

Does anyone have a workflow that checks what community challenges that you have completed?  I used to have one but it broke at the end of 2021 and can't figure out the cause.  Thought someone would have a new update one.

[Jonathan-Sherman]

I've got one somewhere, let me see if I can dig it out...

[Luke_C · Accepted solution]

Give this a go, the HTML getting downloaded keeps changing so the regex parsing out the completion date and thread ID needs to be switched up a little.

[Carolyn]

Updated:

1. The URL with the list of challenges was updated and the 2rd URL was added

2. RegEx updated since they switched the Thread ID and Posted Date, which Luke called out in his previous post.

3. Parsing updated for the Difficulty level. It was parsing as "Intermediate</TD><TD>Data Preparation". Those were split into 2 categories

Though one thing that I'll call out is that I've found challenges where the v4.1 workflow shows them as complete but the Alteryx official list says they're incomplete. Those are cases where I either forgot to attach my completed workflow to my post or when I hit reply, it wasn't on the main post, but on someone's comment. Even though I attached my solution, it didn't count until I went back and clicked the reply on the initial post.

[Carolyn]

A few minor updates:

1. Changed the version to v4.3 since there was already a v4.2 running around - oops

2. I don't know if it's user error, but I was having issues with the macros not being found when I extracted the .yxzp file. Fixed