experssion for string

For the first one you can use a JSONExtractor with the following expression:

json[0]["email"]

This will extract the first element of the outer JSON list, then retrieve the value of the "email" key within that element.

It's pretty much the same for the second one, except that there's no list, so you can query the value directly:

json["token"]

You can read more about these expressions in the documentation: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/jsonfragmenter.htm#JSON_Queries

This one is perhaps the best introduction if you're not too familiar with JSON: https://community.safe.com/s/article/tutorial-getting-started-with-json

its rejecting

 

The configuration of the JSONExtractor is most likely wrong. It should look something like this:

give me same error

fin the attach WS

The attachement only contains the log, not the workspace. Can you please rather post a screenshot of your JSONExtractor settings.

The configuration of the JSONExtractor in the screenshot above is wrong, please compare to the screenshot I posted below.



Check if the quotes (") of the contents of attribute sent_to are doubled, they seem to be in the example at the top of this post, and that's not valid JSON.

If yes, you can use a StringReplacer to replace "" with " before the JSONExtractor.