Why Does the is_public Column of the COMMENTS Table Contain true Values for Some Internal Comments?

Question

Why does the is_public column of the COMMENTS table contain true values for some internal comments? How does Fivetran determine this value?

Environment

Connector: Jira

Answer

We use the jsdpublic field of Jira API's get comment endpoint responses to determine the is_public column value. The jsdpublic field defaults to true when you create comments in the Jira Cloud Platform. In addition, we set the is_public column value to true if the jsdpublic field in Jira's API response is empty.

If your project is a Jira Service Desk project, we determine the is_public value by querying the sd.public.comment comment property using the get comment property endpoint.