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!
Solved! Go to Solution.
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.