Add Support for Paytm Statment

[swarajsomala]

UPI apps are extensively used for the daily payments, can we add the import support for the UPI apps statement. Currently I have Paytm Statement and I wrote simple template to import. Due to some reasons the date format is not proper I fixed the date format manually and Imported.Please find the statement and tempalte.

{{#if (and (isDate ROW.J "DD-MM-YYYY") (not (isBlank ROW.F)))}}
{{ROW.J}} {{ROW.B}}
Expenses:Paytm                 {{ROW.F}} INR
Assets:Checking
{{/if}}

paytm.csv

[ananthakumaran]

@swarajsomala Thanks for sharing the csv file. is this the edited date format or original date format? if it's edited could you upload with the original date format (you can change other fields though), I will see if it can be solved at the template level.

[swarajsomala]

Tested with the latest files it working well but now Paytm enabled a password protected statements. So For every time If I want to open the csv file I need to enter the password which is causing error with the below error.Any way to provide the password as popup?

[ananthakumaran]

Do you mean the XLSX file? I don't think CSV can be protected with a password. Paisa only supports password-enabled PDFs as of now, for XLSX, I haven't checked so far. Please open a new issue if this is an XLSX file, I will also try to do more research on this.

[xXWarMachineRoXx]

why are we relying on csv/xlsx?
can't we just use upi api or something, or listen for payments on a phone with a webhook etc

or maybe just use API's of existing banks ( IndusInd etc) , I do know that would require fitting for every bank provider , but its a smoother approach i think?

[ananthakumaran]

@xXWarMachineRoXx I wish it's that easy to get API access. A random app can't get anywhere near payment APIs. Only registered businesses can apply for it and it's not easy to get it even as a business.

[xXWarMachineRoXx]

@ananthakumaran

https://sandbox.indusind.com/node/1008

I see they do have 100 calls /hour. I don't know the eligibility criterion