Grab the User ID only from a User field in a Fusion scenario

[MichaelLandauer]

I have a custom field where people can select a Workfront User. What I want to do in a Fusion scenario is read that user record and then use the email address associated with that user in a follow-up step. However, when trying to read the user record, I get stuck. 

The field is formatted like this: {"objCode":"USER","name":"Joe Blow",ID":"5ba3fakeID2222a9620b7d6c1173a093"} ... so the Read a Record module returns an error for invalid ID. 

How can I use Switch or String or some other module to only use the ID portion of this string? 

[KristenS_WF · Accepted solution]

Try a Parse JSON module.  You'll need to create a data structure--this is one I created for parsing a custom typeahead user field.

[MichaelLandauer]

Boom! That's it! That's exactly what I needed! Thank you. 

[Lawson02]

In addition, you don't even have to build the data structure. It will auto generate for you if you leave it blank. This is from a field that is the same as yours.