Kapalı

Read XML from API and insert and update

We need a jsp file to run this sql to get invoice numbers that have not been tracked

select trans_id from user_trans where ( approve='1' or paypal_approve='1' or google_approve='1') and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= trans_date and (confirmation_no is null or confirmation_no='');

data will have invoice numbers

| 671767 |

| 671769 |

| 671770 |

| 671771 |

| 671772 |

| 671777 |

| 671778 |

| 671779 |

| 671781 |

| 671782 |

| 671784 |

| 671783 |

then it will call this url and get an xml response

[url removed, login to view]

where tracking number is the invoice number

then it will insert the xml data into these 2 tables

create table DHLShipment (

trans_id int not null,

trackingnumber text not null,

deliveryconfirm text not null,

address1 text not null,

address2 text,

city text not null,

state text not null,

zip text not null,

weight double not null,

shipped date not null

)

create table DHLEvent (

code int not null,

eventDate datetime not null,

city text not null,

state text not null,

description text not null,

postalcode text not null,

country text not null

)

and update table user_trans columns - confirmation_no with <deliveryconfirm> and dhl_tracking with <trackingnumber> where

trans_id <customerconfirm>

Beceriler: JSP, XML

Daha fazlasını görün: insert xml, jsp read xml, sql get date, read xml file api, jsp xml read, read xml jsp, tracking api, run update, null, int, insert, insert date, from api, data api, call tracking, sql update text, update sql file, xml invoice, update code sql, double api, update text sql, sql call api, update insert sql, read file zip, datetime

İşveren Hakkında:
( 197 değerlendirme ) Hacienda Heights, United States

Proje NO: #694549

41 freelancer bu iş için ortalamada 95$ teklif veriyor

toinnisfree

pls chk pmb

in 3 gün içinde135$ USD
(60 Değerlendirme)
6.0
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

in 5 gün içinde225$ USD
(22 Değerlendirme)
5.7
eperfections

Please see PMB

in 3 gün içinde90$ USD
(30 Değerlendirme)
5.3
Georgia

I am interested.

in 4 gün içinde120$ USD
(8 Değerlendirme)
5.1
arnab0143

-- Sir, Please check your pm. Thanks --

1 gün içinde 30$ USD
(5 Değerlendirme)
4.1
kudretserin

Hi, Please see PM, Regards

in 3 gün içinde250$ USD
(11 Değerlendirme)
3.6
AshwinSen

Hello, Please view pmb. Ashwin

1 gün içinde 100$ USD
(9 Değerlendirme)
3.6
indivar

Hello We are confident to do this job within the stipulated timeframe and budget. Please check PM. Regards Team Indivar Software Solutions

in 2 gün içinde80$ USD
(3 Değerlendirme)
3.4
hioshi

Hi, I have 7+ years experience in JAVA programming, May I can help u? Regards,

in 2 gün içinde60$ USD
(2 Değerlendirme)
3.2
saumil12345

Hi, I have done the same thing in another project. It was fetching data from a web service and inserting data into database. The website for which I worked is leoslyrics.com. Every Lyrics is fetched from Web Service. Daha fazlası

in 2 gün içinde50$ USD
(6 Değerlendirme)
3.2
nrifriends

Please check your PM.

1 gün içinde 100$ USD
(3 Değerlendirme)
3.1
softwarehandyman

Just need site access/credentials and DHL creds.

1 gün içinde 100$ USD
(5 Değerlendirme)
3.4
genti157

It can be done in less than a day. Let me know if you are interested.

in 0 gün içinde50$ USD
(4 Değerlendirme)
3.0
eslamniazy

Hello , ready to start ,excellent JSP and SQL skills ,Thanks

in 2 gün içinde60$ USD
(2 Değerlendirme)
3.0
outsourcing

Thats piece of my cake. I can do this for you very effectively and in timely manner.

in 2 gün içinde120$ USD
(4 Değerlendirme)
3.0
netadmin

Expert in this, Please check PM for details...

in 3 gün içinde125$ USD
(2 Değerlendirme)
2.6
arunjassiar

I can easily do it.

1 gün içinde 30$ USD
(2 Değerlendirme)
2.7
sreetech2009

After understanding the Complete Requirements of you, i will give the jsp file within 1/2 day.

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0
pinku2312

Sir, please check u r PM

in 2 gün içinde100$ USD
(0 Değerlendirme)
0.0
patrik11

1.worked on 3 Struts 1.1 and JSp projects. 2.Good knowledge of EL,JSTL and other jsp and struts best practices 3.SCWCD certified.

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0