Forum Discussion

swright's avatar
swright
New Contributor III
5 years ago

Create XML file for Card Transactions from Database Query

We need to create an XML file in Mastercard format for one of our custom cards from a database query that returns transactions with the card number, transaction amount, etc. Some of the header info...
script
rmartyn's avatar
rmartyn
New Contributor II
5 years ago
Copy LinkReport

Hi Vineesha,

Thank you for responding. My SQL is quite a bit more complicated than your example. It includes several “With” statements and such. I’m just wondering if SnapLogic can’t handle that? It runs fine if I put it in SQL Developer.

  • aditya_gupta41's avatar
    aditya_gupta41
    Contributor
    12 months ago
    Copy LinkReport

    Somehow, I am unable to upload my slp pipeline which have the solution, but here I am attaching the SS for your reference.

     

    <html>
    <body>
            <a href="$item.Link_To_SF_CT_Record">Test</a>
    </body>
</html>