Next Matter allows to create XML files automatically and place them in a Google Drive folder of your choice.
Requirements
Knowledge of the XML Structure of the output file
A Google Drive folder and NM integration activated to place the files
Integration Step Sample Setup
The following describes how to setup the integration step to generate the file. Please not, that you can add multiple variables to the URL, separated with "?". These are then available to be inserted in the body in the format <%= VARIABLENAME %>
Method: POST
URL:
https://n962q5mp7c.execute-api.eu-central-1.amazonaws.com/g/util/template_text_gdrive/PARENTIDOFGOOGLEDRIVEFOLDER
/DATAREFERENCETOFILENAMEFORXML
?amount=DATAREFERENCETOAMOUNT
&bic=DATAREFERENCETOBIC
&kunde=DATAREFERENCETOCUSTOMERNAME
&iban=DATAREFERENCETOIBAN
&usage=DATAREFERENCETOVERWENDUNGSZWECK
&_fileextension=xml
Headers:
Content-type text/xml
Pre-Configured Integration: Google Drive
Body (Structure of the XML, sample for a DATEV-readable-XML file for SEPA Bank transfers below):
<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03 pain.001.001.03.xsd">
<CstmrCdtTrfInitn>
<GrpHdr>
<MsgId><%= format(new Date(date), "yyMMddHHmm") %></MsgId>
<CreDtTm><%= format(new Date(date), "yyyy-MM-dd'T'HH:mm:ss.SSSxxx") %></CreDtTm>
<NbOfTxs>1</NbOfTxs>
<CtrlSum><%= amount %>
</CtrlSum>
<InitgPty>
<Nm>NAMEHARDCODE
</Nm>
</InitgPty>
</GrpHdr>
<PmtInf>
<PmtInfId><%= format(new Date(date), "yyMMddHHmm") %></PmtInfId>
<PmtMtd>TRF</PmtMtd>
<NbOfTxs>1</NbOfTxs>
<CtrlSum><%= amount %>
</CtrlSum>
<PmtTpInf>
<SvcLvl>
<Cd>SEPA</Cd>
</SvcLvl>
</PmtTpInf> <ReqdExctnDt><%= format(new Date(date), "yyyy-MM-dd") %></ReqdExctnDt>
<Dbtr>
<Nm>NAMEHARDCODE
</Nm>
</Dbtr>
<DbtrAcct>
<Id>
<IBAN>HARDCODESENDERIBAN
</IBAN>
</Id>
</DbtrAcct>
<DbtrAgt>
<FinInstnId>
<BIC>HARDCODESENDERBIC
</BIC>
</FinInstnId> <
/DbtrAgt>
<ChrgBr>SLEV</ChrgBr>
<CdtTrfTxInf> <PmtId>
<EndToEndId><%= format(new Date(date), "yyMMddHHmm") %>-0000001</EndToEndId>
</PmtId>
<Amt>
<InstdAmt Ccy="EUR"><%= amount %>
</InstdAmt>
</Amt> <CdtrAgt>
<FinInstnId>
<BIC>HARDCODESENDERBIC
</BIC>
</FinInstnId>
</CdtrAgt>
<Cdtr>
<Nm><%= kunde %>
</Nm>
</Cdtr>
<CdtrAcct>
<Id>
<IBAN><%= iban %>
</IBAN>
</Id>
</CdtrAcct>
<RmtInf>
<Ustrd><%= usage %>
</Ustrd>
</RmtInf>
</CdtTrfTxInf>
</PmtInf>
</CstmrCdtTrfInitn>
</Document>
Resources