cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ryantrip-smc
New Member

Searching within a JSON Custom Object to return the instance number

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!

1 ACCEPTED SOLUTION

Accepted Solutions
fraenK
Memorable Member
Memorable Member

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. 

View solution in original post

2 REPLIES 2
fraenK
Memorable Member
Memorable Member

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. 

View solution in original post

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.

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (85,289)