Happy Business Starts Here

How to use Create Payment API to perform mass upload payments of all the paid invoices?

AnandG
Zuora Support Moderator

How to use Create Payment API to perform mass upload payments of all the paid invoices?

Please note that this API is deprecated and can be used only when the Invoicesettlement is not turned on, the scenario is Paid Invoices already available in the system and payments are not tagged due to integration issues. Also, this API supports only external payments.

 

REST_CREATEIMPORT_PAYMENT.PNG

ImportType: Payment

Name: Payment Import

TEmplate1.png

Template2.pngINVOICE_NUMBER : Invoice number

BILLING_ACCOUNT_NUMBER: Customer Account Number

PAYMENT_AMOUNT: Invoice payment amount (format should be number not currency, this does not allow special characters like comma)

PAYMENT_DATE: dd/mm/yyyyy

To Get a PaymentMethodId:

  1. POSThttps://rest.apisandbox.zuora.com/v1/action/query

{
"queryString": "SELECT id,AccountId,name,type from paymentmethod"
}

OR

You Can Use Account Datasource to retrieve required information via Zuora UI.

AccountID.png

To Get a Gateway ID

Go to UI-->> Click Payment (Right Corner) -->>PaymentGateway-->>Edit and Select URL id.

 

GatewayID.png

 

To get the Invoice Id use the Invoice Data source,

InvoiceID.png

 

 

 






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √