Searching within a JSON Custom Object to return the instance number

[ryantrip-smc]

Hello,

I'm trying to parse through a JSON Custom Object to return a specific instance of a report based on the report's title for my project. 
I know I can solve this by creating a loop that checks each instance one by one, however I was hoping there was something more efficient. The only other 'hacky' solution I can come up with is to use the "Parse text" action on the raw JSON to eliminate everything prior to and after the section I want and then rebuild the remaining text back into a JSON Custom Object. Any ideas? Thanks!

[fraenK · Accepted solution]

If you don't like looping then better use cloud flows to do the filtering.

Within PAD you could also split, parse (regex) or get a subtext. 

[ryantrip-smc]

I am currently limited to on-premise and this is more or less a proof-of-concept, but I ended up using "Parse text" and "Get subtext". It ain't pretty, but it works.