Is it possible to retrieve a sheet's Show Condition property using APIs?

[stascher]

Hello,

We're looking for a way to programmatically detect if a sheet has the ability to be hidden based on the existence of a Show Condition expression. I know we can obtain lists of sheets using APIs, but can we obtain this property on individual sheets through APIs as well?

Thanks,

Steven

[rwunderlich · Accepted solution]

Yes you can. It's the "showCondition" property in the Sheet Properties.

-Rob

[hugo_andrade]

Hi @stascher ,

How are you getting the Sheet IDs? Which API are you using?

We can help you get all the way to the sheet property.

Are you on Qlik Sense on Windows or Qlik Cloud?

[Øystein_Kolsrud · Accepted solution]

As @rwunderlich says, that information is available in the sheets properties structure. You will have to go through the Engine API to retrieve that.

https://qlik.dev/apis/json-rpc/qix/

This is what the structure looks like: