Closed

Paypal Excel API - repost

Goal: automatically import completed Paypal transactions from Paypal into excel 2003

Requirements:

1. you need to have paypal account and ebay/Etsy account for testing and validation

2. Call from an excel 2003 using macro or other methods

3. Download data from multiple paypal accounts. For each account

3.1 Download the transactions since last download (See figure 1 below).

3.2 Save the file in the format as C:\download [url removed, login to view]

3.3 Save the same file as C:\[url removed, login to view]

4. Need to provide me the original code, explain the function of each part of the API and how the API is coded

Description:

Currently, I do the download manually for multiple Paypal accounts. The following description is for one Paypal account. The API needs to have the ability to setup multiple paypal accounts and save the files as different names of user’s choice.

1) As shown in Fig 1, I select “last download to present”, Comma Delimited-completed payments, including shopping cart details  click download history

2) As shown in Fig 2, on the “Recent Download Logs” page, select the most recent download log  click download log

3) Save the data as C:\download [url removed, login to view]

4) Save the same file as C:\[url removed, login to view]

Note:

 If the step 1) to 4) could be done using other methods such as direct send a query to my Paypal account, it is also OK. But every query need to collect the transaction since last download/query

 It could take a couple of minutes to several hours for the download log generated on Figure 1 to show on Figure 2 “Recent Download Logs”

See attachment for Figure 1. Paypal download page and Figure 2. Paypal download log

Skills: Excel, PayPal API

See more: my paypal account details, how to call ebay, excel macro how to, paypal setup account, log into paypal, how to setup a paypal account, how do you do paypal, how do i setup a paypal account, csv api, api testing, api download, send csv file ebay, ebay api transaction, log api, excel macro download file, excel macro csv, import multiple csv excel macro, import data macro excel, excel 2013 macro, download paypal history excel macro, macro import csv, paypal api transactions, excel query csv file, repost multiple page, csv import excel function

About the Employer:
( 1 review ) corona, United States

Project ID: #5035818

6 freelancers are bidding on average $247 for this job

inoussakabore

There is about 4 years i working with excel, vba doing web scraping, atomate many task. I am a statistician engineer working as a database manager. I am ready to start it

$421 USD in 3 days
(2 Reviews)
3.3
MSExcelPro

Hi. Professional Excel developer here. You range is quite low for this type of projects. Nevertheless, I'll do it for your top value, what will be a great discount into my usual rates. Contact if you would like to shar More

$250 USD in 5 days
(1 Review)
1.4
IslamMinhajul

Hi I am working on PayPal from 10 years and worked many times on Ms-Access Invoice Template many times for my client

$222 USD in 10 days
(0 Reviews)
0.0
Arunr402

I am a new freelancer, ready to [url removed, login to view] give me a chance , i observe your instruction i think it can be done with in 5 days.

$277 USD in 5 days
(0 Reviews)
0.0
techwelfare

hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat..

$147 USD in 3 days
(0 Reviews)
0.0
nileshpatil81

I will use tool called "QTP" which will fetch data from Excel, which contains details credentials of your different Paypal Accounts. And with help of this tool, it will apply this credentials in Internet Explorer an More

$166 USD in 3 days
(0 Reviews)
0.0