Next Matter allows to create XML files automatically and place them in a Google Drive folder of your choice.

Requirements

  1. Knowledge of the XML Structure of the output file

  2. 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

Did this answer your question?