Sage Intacct XML for Custom Interactive Report

[Imran Choudhry]

Hello All,

Does anybody know how  to use the between operator for XML? I am trying to run a custom interactive report via the intacct api. 

See here I have tried using the Between operator for my batch date.  

 

<?xml version="1.0" encoding="UTF-8"?>
<request>
  <control>
    <senderid>{{sender_id}}</senderid>
    <password>{{sender_password}}</password>
    <controlid>{{$timestamp}}</controlid>
    <uniqueid>false</uniqueid>
    <dtdversion>3.0</dtdversion>
    <includewhitespace>false</includewhitespace>
  </control>
  <operation>
    <authentication>
      <sessionid>{{temp_session_id}}</sessionid>
    </authentication>
    <content>
      <function controlid="{{$guid}}">
        <readReport type="interactive">
          <report>GL Detail MB</report>
          <waitTime>0</waitTime>
          <arguments>
            <GL_TRANSACTION.BATCH_DATE>
              <between>
                <value1>2024-01-01</value1>
                <value2>2024-01-02</value2>
              </between>
            </GL_TRANSACTION.BATCH_DATE>
            <GENERAL_LEDGER_DETAIL_ATTRIBUTES.ACCOUNTNO>60010</GENERAL_LEDGER_DETAIL_ATTRIBUTES.ACCOUNTNO>
            <GENERAL_LEDGER_DETAIL_ATTRIBUTES.LOCATIONNAME>Oasis Marinas @ Port Lorain</GENERAL_LEDGER_DETAIL_ATTRIBUTES.LOCATIONNAME>
          </arguments>
        </readReport>
      </function>
    </content>
  </operation>
</request>

 

Thanks

[Steel, Mark]

Hi Imran,

You've posted this question in the Sage Business Cloud Accounts support forum. You'll be more likely to get a response if you post this in the Sage intacct forum. 

Thanks

Mark