Skip to main content
Nintex Community Menu Bar

Workflow Document Generation: Converting XML to table keeps "&" and won't work with just "&"

  • November 4, 2021
  • 1 reply
  • 2 views
  • Translate
O
Forum|alt.badge.img+4

Hello all,

I am using the Nintex Workflow Document Generation action in one of the workflows for my company.  It works great except for one area.

The XML notation for special characters, specifically & and ', has to be stored as "&" and "'" respectively.  I know there are many more, but I'm sure the resolution to this would also fix those as well.

I tried to use a Regular Expression action to replace the two XML syntax, but fixing that made the XML code invalid and error.  The invalid XML did not create tables correctly in the Document Generation action.

What I am really looking for is the best of both worlds: being able to show the values in the XML in tabular format while also replacing the XML syntax with regular special characters.  Can this be done?

Thank you!

Owen

    Did this topic help you find an answer to your question?

    1 reply

    nico
    Forum|alt.badge.img+10
    • nico
    • Rookie
    • 152 replies
    • November 9, 2021

    Hi,

    The exemple that you show is encoded twice.

     

    The encoded value for & is &

    The encoded value for ' is '

     

    And so with a double encode your ' is encoded : ' and your & is encoded &

     

    So, to have a valide XML you should :

    1. Replace & by &
    2. Replace & by &
    3. Replace ' by "
    4. ... all other special char

     

    Else, you can try to fond a webservice that decode your XML (And use CallWebService action). But you need to find the webservice that make your decode.

     

    Don't forget to check the nintex gallery : https://gallery.nintex.com/

    you can find some usefull workflow.

    For exemple :  

    https://gallery.nintex.com/60abb27049c81e0035b3ede5/Convert%20O365%20Repeating%20Section%20XML%20to%20JSON?tenant=null

     

     

    Just for clarification, why you send XML to your document generation ?

    Translate

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings