locked
Paypal Express Checkout: How to check the automatic recurring payment status using NVP API RRS feed

  • Question

  • User-782344923 posted

    Hi seniors,

    I used the Paypal express checkout (NVP) API in an application for Create a Recurring Customer Profile along with Billing information. I set the subscription date as June 10, 2014. So when the date came, Paypal server automatically occurs the payment from payer's account into sellers account. 

    Here my question lies on this point that from API call is there any method or function available? From where I check the status of recurring payment done or not?

    Basically I want to update the status of user's subscription in my application database. That's why I need to know whether Paypal done the recurring process or failed the process.

    I already gone through the Paypal Express Checkout NVP API from Paypal documentation portal. Help me out may be I'm missing something from there.

    Cheers.

    Tuesday, June 10, 2014 9:14 AM

Answers

  • User-1909662045 posted

    Hi Atif,

    Please check the link below.

    https://developer.paypal.com/docs/classic/api/merchant/GetRecurringPaymentsProfileDetails_API_Operation_NVP/

    regards

    Qasim

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 10, 2014 9:39 AM
  • User-782344923 posted

    Hi again,

    After reading the documentation (https://developer.paypal.com/docs/classic/express-checkout/integration-guide/ECRecurringPayments/) from Paypal portal, I think I found a solution of last issue remaining in my question.

    Here present these paragraphs:

    Getting Recurring Payments Profile Information
    
    Use the GetRecurringPaymentsProfileDetails API to obtain information about a profile.
    
    Note: You can also get information about recurring payments profiles from the PayPal website.
    Along with the information that you specified in the CreateRecurringPaymentsProfile request, GetRecurringPaymentsProfileDetails also returns the following summary information about the profile:
    
    Profile status
    Next scheduled billing date
    Number of billing cycles completed in the active subscription period
    Number of billing cycles remaining in the active subscription period
    Current outstanding balance
    Total number of failed billing cycles
    Date of the last successful payment received (This is the field to get to know about the payment status)
    Amount of the last successful payment received

    Thanks Qasim for your help. 

    Cheers

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 10, 2014 10:54 AM

All replies

  • User-1909662045 posted

    Hi Atif,

    Please check the link below.

    https://developer.paypal.com/docs/classic/api/merchant/GetRecurringPaymentsProfileDetails_API_Operation_NVP/

    regards

    Qasim

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 10, 2014 9:39 AM
  • User-782344923 posted

    Thanks Qasim for the answer. GetRecurringPaymentsProfileDetails method is the solution from where you can extract the last payment date as well as next payment date. Also you can get the Total number of billing cycles completed.

    But there is no way you get the status of payment either 'Completed' or other status message. Just sharing with you the response received from that NVP API method:

    PROFILEID=DUMMYPROFILE
    &STATUS=Active
    &AUTOBILLOUTAMT=NoAutoBill
    &DESC=Profile Creation
    &MAXFAILEDPAYMENTS=3
    &SUBSCRIBERNAME=Test Person
    &PROFILESTARTDATE=2014-06-10T07%3a00%3a00Z
    &NEXTBILLINGDATE=2014-06-11T10%3a00%3a00Z
    &NUMCYCLESCOMPLETED=1
    &NUMCYCLESREMAINING=18446744073709551615
    &OUTSTANDINGBALANCE=0.00
    &FAILEDPAYMENTCOUNT=0
    &LASTPAYMENTDATE=2014-06-10T07%3a03%3a49Z
    &LASTPAYMENTAMT=35.00
    &TRIALAMTPAID=0.00
    &REGULARAMTPAID=35.00
    &AGGREGATEAMT=35.00
    &AGGREGATEOPTIONALAMT=0.00
    &FINALPAYMENTDUEDATE=1970-01-01T00%3a00%3a00Z
    &TIMESTAMP=2014-06-10T13%3a51%3a26Z
    &CORRELATIONID=58606686af686
    &ACK=Success
    &VERSION=84.0
    &BUILD=10958405
    &SHIPTOSTREET=1 Main St
    &SHIPTOCITY=San Jose
    &SHIPTOSTATE=CA
    &SHIPTOZIP=95131
    &SHIPTOCOUNTRYCODE=US
    &SHIPTOCOUNTRY=US
    &SHIPTOCOUNTRYNAME=Unite States
    &SHIPADDRESSOWNER=PayPal
    &SHIPADDRESSSTATUS=Unconfirmed
    &BILLINGPERIOD=Day
    &BILLINGFREQUENCY=1
    &TOTALBILLINGCYCLES=0
    &CURRENCYCODE=USD
    &AMT=35.00
    &SHIPPINGAMT=0.00
    &TAXAMT=0.00
    &REGULARBILLINGPERIOD=Day
    &REGULARBILLINGFREQUENCY=1
    &REGULARTOTALBILLINGCYCLES=0
    &REGULARCURRENCYCODE=USD
    &REGULARAMT=35.00
    &REGULARSHIPPINGAMT=0.00
    &REGULARTAXAMT=0.00

    Cheers

    Tuesday, June 10, 2014 10:44 AM
  • User-782344923 posted

    Hi again,

    After reading the documentation (https://developer.paypal.com/docs/classic/express-checkout/integration-guide/ECRecurringPayments/) from Paypal portal, I think I found a solution of last issue remaining in my question.

    Here present these paragraphs:

    Getting Recurring Payments Profile Information
    
    Use the GetRecurringPaymentsProfileDetails API to obtain information about a profile.
    
    Note: You can also get information about recurring payments profiles from the PayPal website.
    Along with the information that you specified in the CreateRecurringPaymentsProfile request, GetRecurringPaymentsProfileDetails also returns the following summary information about the profile:
    
    Profile status
    Next scheduled billing date
    Number of billing cycles completed in the active subscription period
    Number of billing cycles remaining in the active subscription period
    Current outstanding balance
    Total number of failed billing cycles
    Date of the last successful payment received (This is the field to get to know about the payment status)
    Amount of the last successful payment received

    Thanks Qasim for your help. 

    Cheers

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 10, 2014 10:54 AM
  • User-1909662045 posted

    Hello Atif,

    I am glad that you have found the solution. 

    best regards

    Qasim Nazir

    Tuesday, June 10, 2014 10:58 AM