cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

How to extract data from an XML file

Jump to solution

I have a large xml file with various data i need to extract. Things such as ID Number, Account Number, Date, etc. I am only able to select the whole xml file to target instead of individual text strings. Is there a way I can get a text string save it to a variable and then go to the next data i need to extract?

0 Kudos
Reply
12 Replies
Highlighted
Nintex Newbie

Re: How to extract data from an XML file

Jump to solution

Hi @fshah,

How you exactly get the specific values of the file depends on the file structure. But basically, what I would do is to create the following actions in below order:

  1. Create Variable - found in the action list under "Data" (a text variable with a name like "FileText")
  2. Read File - found in the action list under "Files" (to read your file and store it in your "FileText" variable)
  3. Formula - found in the action list under "Data" (this action you can use now to grab your data using different text formulas)

I hope this makes sense. Let me know if you need additional assistance.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: How to extract data from an XML file

Jump to solution
Hey @mbalslow,
I do not have the 'Read File' action. I do not see it under the 'Files' action list either. I would screenshot it but the Files action list disappears when I'm not hovering over it
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: How to extract data from an XML file

Jump to solution

Hi @fshah,

Please make sure that you have set your account to "Expert" mode in order to be able to see all actions. I have attached two screenshots.Read file.pngExpert method.png

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: How to extract data from an XML file

Jump to solution

Alright so my account was actually on beginner, however I just changed it to expert and still do not see that option. Also I did restart the client as well. @mbalslow

 

 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: How to extract data from an XML file

Jump to solution

@fshah you have to click on "Files" to expand the section to be able to access the "Read File" action.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: How to extract data from an XML file

Jump to solution

Right. That action is not there

@mbalslow

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: How to extract data from an XML file

Jump to solution

@fshah what version are you running?

I'm not sure how it could be that you don't see that action. What other actions from my screenshot don't you see?

Capture.png

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: How to extract data from an XML file

Jump to solution

@mbalslow I'm running 12.3.1, that could be the reason why. Also I attatched a screenshot of what my action list looks like on the previous comment

Along with Read File, i dont have:
Touch file
Write file
Set folder
Touch folder

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: How to extract data from an XML file

Jump to solution

Hi fshah,

 

You will need to upgrade to v15.1.4 to get those missing Actions.

 

Download link:  https://download.nintex.com/Foxtrot/FoxtrotRPASetup_15_1_4.exe

 

You will need to upgrade all machines with v12.3.1 installed, starting with the one that houses your licensing.  If you'd like assistance, feel free to reach out to our support group:  support@nintex.com or 1-800-658-1147.

 

Enjoy the day,

Aaron

0 Kudos
Reply