Forum Discussion

kgor's avatar
kgor
New Contributor
5 years ago

XML not getting populated with all Data from Source

Hi, I have run into an interesting situation where my XML generator is not populating entire CSV file I reading. Basically, I am reading CSV file and trying to send that as one batch to SAGE Intacc...
kgor's avatar
kgor
New Contributor
5 years ago
Copy LinkReport

Hi,

Thank you, So I did what you suggested, Below are the screenshots for your ref and I still get multiple documents

Mapper

XML Formatter

Binary to document

Error returned by XML formatter

I am trying to achieve this , where all my lines should get populated in between tags.

            <create>
                <GLBATCH>
                    <JOURNAL>PYRJ</JOURNAL>
                    <BATCH_DATE>$BatchDate</BATCH_DATE>
                    <BATCH_TITLE>$BatchTitle</BATCH_TITLE>
                    <ENTRIES>
                        <GLENTRY>
                            <ACCOUNTNO>$GLAccount</ACCOUNTNO>
                            <DEPARTMENT>$Dept</DEPARTMENT>
                            <LOCATION>$Location</LOCATION>
                            <PROJECTID>$Project</PROJECTID>
                            <TR_TYPE>-1</TR_TYPE>
                            <AMOUNT>$Credit</AMOUNT>
                            <DESCRIPTION>$Description</DESCRIPTION>
                            <GLDIMEVENT>$Event</GLDIMEVENT>
                            <REFERENCENO>$ReferenceNo</REFERENCENO>
                        </GLENTRY>
                    </ENTRIES>
                </GLBATCH>
            </create>
  • mbowen's avatar
    mbowen
    Employee
    5 years ago
    Copy LinkReport

    It looks like the XML Formatter will only collect input documents into one output if a “Root element” is defined, otherwise, it will generate a separate binary document for each input document. So, maybe try that. It is my understanding that you want one XML payload to submit to Sage Intacct API. Thank you for the screen shots BTW.