Supporting live connections to cloud files (Box)

[ausiddiqui]

I have an issue with updating the connections to a workbook once I added a live connection to an Excel file via Box. I was using the Rest API v2.8 using server-client-python package have an open issue in that repo as well.

I am sharing what the xml snippet looks like in my published workbook for this connection to see if there's any modification that can be suggested to update the connection / traverse the ETree. What would be the bare minimum fields that need to be repopulated every time to publish to server, i.e. what is the Desktop client doing to the xml when we click publish with a live connection like this?

      <connection class="federated">
        <named-connections>
          <named-connection caption="Reporting_Commentary" name="cloudfile:box-excel-direct.1bk2zjd1uefpc71dfvxop1xj4y0b">
            <connection class="cloudfile:box-excel-direct" cleaning="no" cloudFileExtension="xlsx" cloudFileId="318391143483" cloudFileMetadata_-_folder="53478632394" cloudFileName="Reporting_Commentary.xlsx" cloudFileProvider="box" cloudFileRequestURL="https://api.box.com/2.0/files/318391143483/content" compat="no" dataRefreshTime="" filename="Reporting_Commentary.xlsx" interpretationMode="0" server="" server-oauth="server-custom" userLanguage="en" username="[email protected]" validate="no" workgroup-auth-mode="prompt"/>
          </named-connection>
        </named-connections>
        <relation connection="cloudfile:box-excel-direct.1bk2zjd1uefpc71dfvxop1xj4y0b" name="Content" table="[Content$]" type="table">
          <columns gridOrigin="A1:D91:no:A1:D91:0" header="yes" outcome="6">
            <column datatype="date" name="Fiscal week start" ordinal="0"/>
            <column datatype="string" name="Aggregation" ordinal="1"/>
            <column datatype="string" name="Calculation Type" ordinal="2"/>
            <column datatype="string" name="Commentary" ordinal="3"/>
          </columns>
        </relation>
        <metadata-records>
        ...
        </metadata-records>
      </connection>