Challenge #441: Unlock the Mysteries of Alteryx Server’s API Information

[abbyabbypoon]

Spoiler

[Albert_Vega]

Spoiler

[ScottLewis]

I like things where I have the option of using a tiny amount of RegEx to give me the illusion of proficiency.

That aside, this is an interesting example of finding most recent. Here, we have the versions in order, but no clear endpoint.

In such a case if we strip the version specific naming we can use Last value to find the most value for each field.

[Desmond]

My Solution

[The_Rad_Valentina]

This one might be tedious, but it is often part of what Server Admins have to do to report using data from APIs. Mine is the solution file :)

[mark-spain]

I was too lazy to rename all the columns so used Dynamic Rename to steal them from the expected output. 

Spoiler

[Bennu]

Bonus points for cryptic formula?

left([JSON_Name], Length('versions.0.')) = "versions.0."
OR
left([JSON_Name], Length('versions.')) != "versions."

Spoiler

[Bennu]

Yes agreed.  Actually, quite a bunch of challenges suffer from this same issue.  Instructions are vague and unclear to the point that figuring out what the challenge is asking for and which fields to use in calculations/formulas etc, is harder then the actual building of the workflow!!  If I wanted vague requirements, I can just go to my users! LOL

[cmoussa]

[PhilipMannering]

Solution attached.

Spoiler