cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Automation Master
Automation Master

Get XML As Plain Text in Email / Column

Jump to solution

Hey folks!

I'll admit - I don't use O365 very much. And, due to this fact, I struggle with some things that are fairly basic.

Example (and the topic of this post): 

We're using the O365 Search Query to retrieve some data on a Content Type. Neat. We're returning the source as XML. Also neat. HOWEVER! We need to be able to view the XML brought back with all of its tags in tact, and it keeps rendering them and thus disappearing. Here is what we have tried:

- Emailing it to ourselves using the Advanced Lookup to select Workflow Variable, txtXML, and selecting the format as Plain Text

- Writing it to a multi-line SharePoint column set to Plain Text

- Wrapping with the tags XMP

- Sacrificing a keyboard to the gods of XML

What's interesting is that, if we Log To History, all is well - XML, ahoy.

Can you help us out?

CC Amy Grendus

(PS: If you're interested in why we want it as XML, it's because we want to see all the possible tags that we can consume from the search.) 

Reply
19 Replies
Automation Master
Automation Master

Re: Get XML As Plain Text in Email / Column

Jump to solution

‌ | ‌ | ‌ | ‌ | ‌ |

0 Kudos
Reply
Automation Master
Automation Master

Re: Get XML As Plain Text in Email / Column

Jump to solution

I do not have experience with O365, so I'm not aware of its specifics.

but haven't you tried to simply XmlEncode it?

Reply
Automation Master
Automation Master

Re: Get XML As Plain Text in Email / Column

Jump to solution

Ah, sorry ‌ - I didn't know that!

As for XML Encoding... it already is encoded, it's just leaving this world when it's published.. I've updated with a comment below to show specifics.  

0 Kudos
Reply
Automation Master
Automation Master

Re: Get XML As Plain Text in Email / Column

Jump to solution

And remember we still have no inline functions in O365

Reply
Automation Master
Automation Master

Re: Get XML As Plain Text in Email / Column

Jump to solution

just to be sure we're talking about the same encoding: is the string you get in history log one that you meant already encoded?

it looks to me, you mean you have encoded XML node's values, but not XML nodes itself.

 what should effectively be sent to mail or written to plaintext should look like:

<Results hits="2"><Result><Rank>

I do quite believe this is your problem

maybe you could try with a encoded hand-made short piece of (valid) XML

0 Kudos
Reply
courtney_shelto
Nintex Newbie

Re: Get XML As Plain Text in Email / Column

Jump to solution

Interesting, as seen in my use case here:   Where I was using a repeating section and needed to parse that XML, I was able to write it directly into a plain text multi line column with no issues. Can you post some more details of your workflow and what actions you're using and how they're configured?

Reply
Automation Master
Automation Master

Re: Get XML As Plain Text in Email / Column

Jump to solution

For such case I am logging the XML structure to multiline plain text field. Remember, the field has to be plain text. 

Also, when you send it via email, it is just impossible to open it in Outlook Online. I recall I was able to view the XML structure in Outlook Desktop or that I was sending it to my Gmail. 

Anyway, using plain multiline text field does its job. 

Regards 

Tomasz 

Reply
Automation Master
Automation Master

Re: Get XML As Plain Text in Email / Column

Jump to solution

Column Configuration:

Workflow Configuration:

Search Query Output:

The Output Into The Column:

(no XML tags) (email output looks the same)

Output Into Log History:

Is this SharePoint Environment haunted?

Reply
courtney_shelto
Nintex Newbie

Re: Get XML As Plain Text in Email / Column

Jump to solution

Rhia Wieclawek wrote:

Is this SharePoint Environment haunted?

Yes, I believe so. The only option is to burn it down, I'm so sorry.

What if you leave it as a string rather than selecting plain text?

Reply