Parsing xml string

  • 3 July 2016
  • 1 reply
  • 2 views

Badge +2

Hi,

 

We have a workflow that calls a webservice that connects to our LOB system and return us a 1 big xml string.

 

We tried the smartobject tester and we were able to receive the full xml in 1 string.

 

Our goal is to parse that xml string and extract 8 different values from different nodes and update sharepoint fields with these values from the xml.

 

My question is once we receive the xml string from webservice, how do we parse it to extract the nodes we want? Is this something that needs to be done as a step on the workflow side?

 

Thank you for any help or ideas.

 


1 reply

Userlevel 1
Badge +8

One thing you can try is get a copy of the XML string that your service returns. Create an XML Process Data field using that xml string as the template (there is an option in the dialogue (XML Schema tab) where you can hit browse and pick XML or XSD).

 

Then in the workflow, make the smart object call and assign the return to the XML field. If it worked, you can then see the nodes of the XML in the object browser and use the specific values you are interested in.

 

Something to try.

 

S.

 

 

Reply