How to Parse the XML data along with the URL in Shell Script?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to Parse the XML data along with the URL in Shell Script?
# 1  
Old 01-03-2013
Linux How to Parse the XML data along with the URL in Shell Script?

Hi,

Can anybody help to solve this. I want to parse some xmldata along with the URL in the Shell.

I'm calling the URL via the curl command

Given below is my shell script file
Code:
export url="http://localhost/test/apirequest.php?&apikey=Zm9ybSRAMCMjMjAxMy0wMS0wMyAxNDo0MjoyNg==&reqtype=xml&operation=insertRecords&xmldata=<?xml"\ "version="1.0" encoding="iso-8859-1"?><root><FORM name ="Form1"><row no="0"><FL val="Company">New Company2</FL></row></FORM></root>"

script=$(curl -s "$url")
printf "%s\nDo you want to run this script? [yN]" "$script"
read line
case $line in
[Yy]|[Yy][Ee][Ss])
 sh <<EOF
 $script
EOF
esac


Thanks in Advance

Last edited by Scrutinizer; 01-09-2013 at 07:17 AM..
# 2  
Old 01-03-2013
What is the problem with this script??
# 3  
Old 01-03-2013
The script goal is to ?
As far as I get, your script stores into a variable "script" the result of the curl execution "curl -s "$url" "and then executes that result.+

So, what error do you get?
Is that the purpose of your script?
Can you tell what is the return value of the curl execution?

Regards.
# 4  
Old 01-03-2013
Do you mean you want to parse the data you receive back from curl?
If so, Post some sample data.Smilie
# 5  
Old 01-09-2013
Exact Problem

The Exact prob here is the URL which i parse is getting breaked due to the space in it.

Example:
Code:
myurl="http://localhost/test/apirequest.php?&apikey=Zm9ybSRAMCMjMjAxMy0wMS0wMyAxNDo0MjoyNg==&reqtype=xml&operation=insertRecords&xmldata=<?xml version=\"1.0\" encoding=\"iso-8859-1\"?><root><FORM name=\"Form1\"><row no=\"0\"><FL val=\"Company\">NewCompany2</FL></row></FORM></root>"

Here the url is getting breaked due the space between the strings xml version .And the same prob happens , whevener there is same some in between the strings.


Please do help me soonSmilieSmilie

Last edited by Megala; 01-09-2013 at 08:30 AM..
# 6  
Old 01-09-2013
Threads merged..
# 7  
Old 01-10-2013
Quote:
Originally Posted by Megala
The Exact prob here is the URL which i parse is getting breaked due to the space in it.
Why not enclose string with single quotes so the shell will supply string exactly as you specify?, Example of both ways:
Code:
$ cat test.sh
url="http://localhost/test/apirequest.php?&apikey=Zm9ybSRAMCMjMjAxMy0wMS0wMyAxNDo0MjoyNg==&reqtype=xml&operation=insertRecords&xmldata=<?xml"\ "version="1.0" encoding="iso-8859-1"?><root><FORM name ="Form1"><row no="0"><FL val="Company">New Company2</FL></row></FORM></root>"
echo $url
url='http://localhost/test/apirequest.php?&apikey=Zm9ybSRAMCMjMjAxMy0wMS0wMyAxNDo0MjoyNg==&reqtype=xml&operation=insertRecords&xmldata=<?xml"\ "version="1.0" encoding="iso-8859-1"?><root><FORM name ="Form1"><row no="0"><FL val="Company">New Company2</FL></row></FORM></root>'
echo $url


$ test.sh
http://localhost/test/apirequest.php?&apikey=Zm9ybSRAMCMjMjAxMy0wMS0wMyAxNDo0MjoyNg==&reqtype=xml&operation=insertRecords&xmldata=<?xml version=1.0 encoding=iso-8859-1?><root><FORM name =Form1><row no=0><FL val=Company>New Company2</FL></row></FORM></root>
http://localhost/test/apirequest.php?&apikey=Zm9ybSRAMCMjMjAxMy0wMS0wMyAxNDo0MjoyNg==&reqtype=xml&operation=insertRecords&xmldata=<?xml"\ "version="1.0" encoding="iso-8859-1"?><root><FORM name ="Form1"><row no="0"><FL val="Company">New Company2</FL></row></FORM></root>

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need get data from XML file through shell script..

hi all, here is the sample log file and these errors are repeated in log file.. i need all the repeated time stamp ,severity and message tags needs to print in output file.. through shell script <log-message> <timestamp>2019-03-13T04:52:49.648-05:00</timestamp> <severity>ERROR</severity>... (17 Replies)
Discussion started by: ravi
17 Replies

2. Shell Programming and Scripting

Parse xml in shell script and extract records with specific condition

Hi I have xml file with multiple records and would like to extract records from xml with specific condition if specific tag is present extract entire row otherwise skip . <logentry revision="21510"> <author>mantest</author> <date>2015-02-27</date> <QC_ID>334566</QC_ID>... (12 Replies)
Discussion started by: madankumar.t@hp
12 Replies

3. Shell Programming and Scripting

Extract and parse XML data (statistic value) to csv

Hi All, I need to parse some statistic data from the "measInfo" -eg. 25250000 (as highlighted) and return the result into line by line, and erasing all other unnecessary info/tag. Thought of starting with grep "measInfoID="25250000" but this only returns 1 line. How do I get all the output... (8 Replies)
Discussion started by: jackma
8 Replies

4. Shell Programming and Scripting

Shell script (not Perl) to parse xml with awk

Hi, I have to make an script according to these: - I have couples of files like: xxxxxxxxxxxxx.csv xxxxxxxxxxxxx_desc.xml - every xml file has diferent fields, but keeps this format: ........ <defaultName>2011-02-25T16:43:43.582Z</defaultName> ........... (2 Replies)
Discussion started by: Pluff
2 Replies

5. Shell Programming and Scripting

Parse XML file in shell script

Hi Everybody, I have an XML file containing some data and i want to extract it, but the specific issue in my file is that the data is repeated some times like the following example : <section1> <subsection1> X=... Y=... Z=... <\subsection1> <subsection2> X=... Y=... Z=...... (2 Replies)
Discussion started by: yassine
2 Replies

6. Shell Programming and Scripting

regex/shell script to Parse through XML Records

Hi All, I have been working on something that doesn't seem to have a clear regex solution and I just wanted to run it by everyone to see if I could get some insight into the method of solving this problem. I have a flat text file that contains billing records for users, however the records... (5 Replies)
Discussion started by: Jerrad
5 Replies

7. Shell Programming and Scripting

parse data between parenthesis using shell script

Hi I am using shell script and i need to parse the data between parenthesis.How do i do it using shell script. Ex: section(name). I want to extract name from the above string using shell script. (4 Replies)
Discussion started by: julie_s
4 Replies

8. Shell Programming and Scripting

Help!!! Shell script to parse data file.

I am faced with a :confused: tricky problem to parse a data file ( May not be a tricky problem to the scripting guru's ). Here is what I am faced with. I have a file with multiple rows of data and the rows are not of fixed length. "|" is used as a delimiters for individual columns and each row... (3 Replies)
Discussion started by: yajaykumar
3 Replies

9. Shell Programming and Scripting

Help with shell script to extract data from XML file

Hello Scripting Gurus, I need help with extracting data from the XML file using shell script. The data is in a large XML and I need to extract the id values of all completedworkflows. Here is a sample of it. Input and output data is also in the attached text files. <wfregistry>... (5 Replies)
Discussion started by: yajaykumar
5 Replies

10. Shell Programming and Scripting

Parse a string in XML file using shell script

Hi! I'm just new here and don't know much about shell scripting. I just want to ask for help in creating a shell script that will parse a string or value of the status in the xml file. Please sample xml file below. Can you please help me create a simple script to get the value of status? Also it... (46 Replies)
Discussion started by: ayhanne
46 Replies
Login or Register to Ask a Question

Featured Tech Videos