Table Excerpt Include - "Show a copy of the source table" not getting enabled via confluence APIs

[Deepa Nair]

I have an HTML content of a confluence page as follows :

<br/><b>DataModel PersistenceDamageCoverage</b> <ac:structured-macro ac:macro-id="c9869bed-35fa-4a49-82bb-be7fc2977cdc" ac:name="table-excerpt" ac:schema-version="1"> <ac:parameter ac:name="name">PersistenceDamageCoverage</ac:parameter> <ac:rich-text-body> <table> <tbody> <tr> <th>Field Name</th> <th>Type</th> <th>Description</th> </tr> <tr> <td>status</td> <td>PersistenceDamageCoverageStatus</td> <td>The current status of the damage coverage.</td> </tr> <tr> <td>reason</td> <td>String</td> <td>The reason associated with the damage coverage.</td> </tr> <tr> <td>overridden</td> <td>boolean</td> <td>Indicates if the coverage has been manually overridden.</td> </tr> <tr> <td>lastAutomatedStatus</td> <td>PersistenceDamageCoverageStatus</td> <td>The last automated status of the damage coverage.</td> </tr> <tr> <td>lastAutomatedCoverageReason</td> <td>String</td> <td>The reason provided for the last automated coverage status.</td> </tr> </tbody> </table> </ac:rich-text-body> </ac:structured-macro> <br/><b>DataModel PersistenceDamagedBuilding</b> <ac:structured-macro ac:macro-id="0179ed2d-5b55-4156-9e50-5206796b1b81" ac:name="table-excerpt" ac:schema-version="1"> <ac:parameter ac:name="name">PersistenceDamagedBuilding</ac:parameter> <ac:rich-text-body> <table> <tbody> <tr> <th>Field Name</th> <th>Type</th> <th>Description</th> </tr> <tr> <td>location</td> <td>PersistenceAddress</td> <td>The address of the damaged building.</td> </tr> <tr> <td>multiDamage</td> <td>boolean</td> <td>Indicates if the building has sustained multiple damages.</td> </tr> </tbody> </table> </ac:rich-text-body> </ac:structured-macro> <br/><b>DataModel PersistenceDamagedContent</b> <ac:structured-macro ac:macro-id="eb095c35-e3d5-4728-99fa-66186db8bef6" ac:name="table-excerpt" ac:schema-version="1"> <ac:parameter ac:name="name">PersistenceDamagedContent</ac:parameter> <ac:rich-text-body> <table> <tbody> <tr> <th>Field Name</th> <th>Type</th> <th>Description</th> </tr> <tr> <td>purchasePrice</td> <td>Double</td> <td>The price at which the item was purchased.</td> </tr> <tr> <td>purchaseDate</td> <td>LocalDate</td> <td>The date on which the item was purchased.</td> </tr> <tr> <td>multiDamage</td> <td>boolean</td> <td>Indicates whether the item has multiple damages.</td> </tr> </tbody> </table> </ac:rich-text-body> </ac:structured-macro> <br/><b>DataModel PersistenceDamagedProperty</b> <ac:structured-macro ac:macro-id="d7063b0d-14e6-4565-bac3-bb3e5a1d2a53" ac:name="table-excerpt" ac:schema-version="1"> <ac:parameter ac:name="name">PersistenceDamagedProperty</ac:parameter> <ac:rich-text-body> <table border="1"> <tbody> <tr> <th>Field Name</th> <th>Type</th> <th>Description</th> </tr> <tr> <td>id</td> <td>String</td> <td>Unique identifier for the damaged property.</td> </tr> <tr> <td>type</td> <td>PersistenceLabeledValue</td> <td>Type of the damaged property.</td> </tr> <tr> <td>typeCoverage</td> <td> <ac:structured-macro ac:name="expand"> <ac:parameter ac:name="title">PersistenceDamageCoverage</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:name="table-excerpt-include"> <ac:parameter ac:name="name">PersistenceDamageCoverage</ac:parameter> <ac:parameter ac:name="excerptSource">current</ac:parameter> <ac:parameter ac:name="show-source-table">true</ac:parameter> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> </td> <td>Coverage information associated with the type of the damaged property.</td> </tr> <tr> <td>entity</td> <td>PersistenceLabeledValue</td> <td>Entity associated with the damaged property.</td> </tr> <tr> <td>items</td> <td>List(PersistenceItem)</td> <td>List of items related to the damaged property.</td> </tr> <tr> <td>coverage</td> <td> <ac:structured-macro ac:name="expand"> <ac:parameter ac:name="title">PersistenceDamageCoverage</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:name="table-excerpt-include"> <ac:parameter ac:name="name">PersistenceDamageCoverage</ac:parameter> <ac:parameter ac:name="excerptSource">current</ac:parameter> <ac:parameter ac:name="show-source-table">true</ac:parameter> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> </td> <td>Coverage details for the damaged property.</td> </tr> <tr> <td>estimate</td> <td> <ac:structured-macro ac:name="expand"> <ac:parameter ac:name="title">PersistenceEstimate</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:name="table-excerpt-include"> <ac:parameter ac:name="name">PersistenceEstimate</ac:parameter> <ac:parameter ac:name="excerptSource">current</ac:parameter> <ac:parameter ac:name="show-source-table">true</ac:parameter> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> </td> <td>Estimated cost or value associated with repairing or replacing the damaged property.</td> </tr> <tr> <td>repair</td> <td> <ac:structured-macro ac:name="expand"> <ac:parameter ac:name="title">PersistenceRepair</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:name="table-excerpt-include"> <ac:parameter ac:name="name">PersistenceRepair</ac:parameter> <ac:parameter ac:name="excerptSource">current</ac:parameter> <ac:parameter ac:name="show-source-table">true</ac:parameter> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> </td> <td>Repair details for the damaged property.</td> </tr> <tr> <td>solutionStatus</td> <td>SolutionStatusEnum</td> <td>Status of the solution process for the damaged property.</td> </tr> </tbody> </table> </ac:rich-text-body> </ac:structured-macro>

I could see when I use this HTML page in the below confluence API : self.confluence.update_page(parent_id=None, page_id=configurations.PAGE_ID, title=configurations.CONFLUENCE_TITLE, body=body, representation='storage' ) where body is the HTML content provided earlier . After the running of this API , the confluence page is updated, but I see the table-excerpt-include for typeCoverage is not having show source table is not ticked eventhough i have given it as True in the input as below :

<ac:parameter ac:name="show-source-table">true</ac:parameter>

What should i change in the input HTML so that the field for show source table will be ticked.

[Deepa Nair · Accepted solution]

I believe it is a generic issue , because i am not able to set a similar option - "Transpose Table" also from API . Can someone please advise if it is a known issue ?

[Stiltsoft support]

Hi @Deepa Nair ,

It seems that you are talking about our app - Table Filter, Charts & Spreadsheets for Confluence.

Try to select all the necessary options in the macro settings and check what you see in the HTML content.

For me the Show a copy of a source table option looks like

<ac:parameter ac:name="copytable">true</ac:parameter>

and the Transpose Table option

<ac:parameter ac:name="transpose">always</ac:parameter>

If you are still stuck, please contact our support portal directly for further investigation.

[Deepa Nair]

Thanks a lot , it works like magic !!!