Read JSON from Email Body (IMAP)

[eonofrey (Emily Onofrey)]

Hi everyone,

I am trying to read the body of an email containing a JSON. When I disable activities I was able to figure out the error is being thrown in my Deserialize JSON array activity.

Here is the error I am getting: Deserialize JSON Array: Unexpected character encountered while parsing value: <. Path ‘’, line 0, position 0.

Please help!

Thanks,
Emily

[bcorrea (Bruno Correa)]

you will need to remove this

<pre> and </pre>

from the body first…

[YAZIDI (YAZIDI Abdelhadi)]

Hi @eonofrey,

Try removing the “<pre>” and “</pre>” before deserialization.

Cheers

[cmolina (Carlos Molina)]

Hi @eonofrey,

Try removing < pre> and < /pre> a JSON have to start with “{” and ends with “}” and JSON ARRAY have to start with “[” and ends with “]”. So, in your particular case (because you are using Deserialize JSON Array activity) you shoud replace
< pre> by [ and < /pre> by ]
I hope it helps you

[eonofrey (Emily Onofrey)]

Thank you all. I made some updates to the email format. I am not able to split the email body to

emailBodyTrim(0) → which is the JSON (attached in message box screenshot)
emailBodyTrim(1) → my email signature

Here is the error I am getting now: Deserialize JSON Array: Error reading JArray from JsonReader. Current JsonReader item is not an array: StartObject. Path ‘’, line 1, position 1.

Again, my goal is to parse through the JSON to get each data value.

[bcorrea (Bruno Correa)]

change activity deserialize array to the normal one…

[eonofrey (Emily Onofrey)]

That worked but now I have a new issue.

Do I need to change the Type Argument?

[bcorrea (Bruno Correa)]

you should remove the for each i guess, unless you want to print every value in that json…

[eonofrey (Emily Onofrey)]

I need to assign each individual value to a variable.

I am trying to figure out a string conversion because this is the error I am getting: Message Box: Cannot access child value on Newtonsoft.Json.Linq.JProperty.

[bcorrea (Bruno Correa)]

YourJsonVariable(“tenant”)(“firstname”) and so on…

[eonofrey (Emily Onofrey)]

I am still getting the error: Message Box: Object reference not set to an instance of an object.

[bcorrea (Bruno Correa)]

Go into debug mode and see what you have in your jsonobject after deserialize.

[eonofrey (Emily Onofrey)]

[bcorrea (Bruno Correa)]

I meant use this one, opening the object in Locals:

[eonofrey (Emily Onofrey)]

Here is the JsonObject expanded from debug mode…

[bcorrea (Bruno Correa)]

Your object seems ok, the keys are case sensitive tho… YourJsonVariable(“tenant”)(“firstName”) should work

[eonofrey (Emily Onofrey)]

Good point, however I still have the same error. Any other ideas?

[bcorrea (Bruno Correa)]

firstName is in tentant so you need to access that first…
MyFirstName = parseMsg(“tenant”)(“firstName”)
MyLastName = parseMsg(“tenant”)(“lastName”)

[eonofrey (Emily Onofrey)]

Assign Activity
fn = parseMsg(“tenant”)(“firstName”).ToString

Worked for me… thank you for all your help!