I have an HTML content of a confluence page as follows : DataModel PersistenceDamageCoverage PersistenceDamageCoverage Field Name Type Description status PersistenceDamageCoverageStatus The current status of the damage coverage. reason String The reason associated with the damage coverage. overridden boolean Indicates if the coverage has been manually overridden. lastAutomatedStatus PersistenceDamageCoverageStatus The last automated status of the damage coverage. lastAutomatedCoverageReason String The reason provided for the last automated coverage status. DataModel PersistenceDamagedBuilding PersistenceDamagedBuilding Field Name Type Description location PersistenceAddress The address of the damaged building. multiDamage boolean Indicates if the building has sustained multiple damages. DataModel PersistenceDamagedContent PersistenceDamagedContent Field Name Type Description purchasePrice Double The price at which the item was purchased. purchaseDate LocalDate The date on which the item was purchased. multiDamage boolean Indicates whether the item has multiple damages. DataModel PersistenceDamagedProperty PersistenceDamagedProperty Field Name Type Description id String Unique identifier for the damaged property. type PersistenceLabeledValue Type of the damaged property. typeCoverage PersistenceDamageCoverage PersistenceDamageCoverage current true Coverage information associated with the type of the damaged property. entity PersistenceLabeledValue Entity associated with the damaged property. items List(PersistenceItem) List of items related to the damaged property. coverage PersistenceDamageCoverage PersistenceDamageCoverage current true Coverage details for the damaged property. estimate PersistenceEstimate PersistenceEstimate current true Estimated cost or value associated with repairing or replacing the damaged property. repair PersistenceRepair PersistenceRepair current true Repair details for the damaged property. solutionStatus SolutionStatusEnum Status of the solution process for the damaged property. 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 : true What should i change in the input HTML so that the field for show source table will be ticked.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Deepa Nair_wmzj8z

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.

Accepted answers

Deepa Nair_wmzj8z

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 ?

All comments

Deepa Nair_wmzj8z

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_wmzj8z

Thanks a lot , it works like magic !!!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

filter

table

table-filter

table-excerpt

table-filter-and-charts

table-filter-charts-spreadsheets

unknown-hosting-type

confluence-unknown-hosting-type

data%20center