Skip to content
+1-888-319-3663

COMMUNITY FORUM

Folder Data Source and XML Query Error on Smart Connect 2012

oscar87 asked 7 years ago
I am getting the following when using Folder Data Source with XML Query as the File Type. The client is currently on Version 2012 of SmartConnect. Please advise. 

I am getting the following error 

Invalid SELECT statement.
Unexpected token "Transaction" at line 1, pos 26

Below is the XML Query Template.
<?xml version="1.0" encoding="utf-8"?>
<LMSOAPGL>
<SOAPProcessInfo>
<BATCHID>141393</BATCHID>
</SOAPProcessInfo>
<Transactions>
<Transaction>
<SOAP_TRX_ID>12345</SOAP_TRX_ID>
<LICENSE_TYPE>CAT</LICENSE_TYPE>
<COLLECTION_TYPE>FEE</COLLECTION_TYPE>
<AMOUNT>500.00</AMOUNT>
<TRANSACTION_DATE>2014-12-08</TRANSACTION_DATE>
<PAYMENT_MECHANISM>Lockbox</PAYMENT_MECHANISM>
</Transaction>
<Transaction>
<SOAP_TRX_ID>38383</SOAP_TRX_ID>
<LICENSE_TYPE>Web</LICENSE_TYPE>
<COLLECTION_TYPE>SOA</COLLECTION_TYPE>
<AMOUNT>-543.21</AMOUNT>
<TRANSACTION_DATE>2014-12-10</TRANSACTION_DATE>
<PAYMENT_MECHANISM>Lockbox</PAYMENT_MECHANISM>
</Transaction>
</Transactions>
</LMSOAPGL>

If you would like to submit an answer or comment, please sign in to the eOne portal.