Export posts to the excel?

Hey folks, thought I’d chime-in on this one.  @revote One way to accomplish what you’re looking for is to use our API, possibly combined with Zapier.  That is technical solution and so you need someone who is able to do that - but it is possible to set up an automation that directly imports community posts (including the post content) into a Google Sheet on an ongoing basis.  

Thanks @Kenneth R, this might be the best and only way to do it. I dont know how to use API, we have to sort this out somehow.

@Kenneth R can you clarify which API endpoints are required to set up what you describe!? I’ve been poring over the API docs and haven’t found the correct endpoint yet.

This can be achieved with the upcoming BI Connector. You can join the group here….

https://communities.gainsight.com/groups/bi-connector-to-cc-data-lake-silver-layer-beta-207

All of this data (and much more) is available and is incredibly easy to find if you know a bit of SQL.

i don’t have access to view that page, and can’t see how to join the group? is this currently live, or coming soon?

Hi @ryguy99, 

Sorry, I forgot that you need to apply for access. Go to the groups section….

https://communities.gainsight.com/groups

...and search for BI connector to CC Data Lake Silver Layer BETA. You will have to request access to join.

I don’t see that group there. These are the only ones I see relevant to Beta: 

Ah, I wasn’t aware of that @ryguy99. I could always see it before I signed up. I suspect that they may have made it a hidden group. I would speak to your account manager to discuss it. 

i’m not sure how our account manager is… is there not a way to do this today without this Beta feature? i have an API key. im guessing this has to be supported already

@ryguy99 you can do this with the API, but it is much more work. Essentially you need to look at the APIs here….

First you need to get your bearer token. This is explained here...

https://api2-eu-west-1.insided.com/docs/#section/Authentication/OAuth2

Once you have that (it won’t last for long, so this needs to be built into an application or maybe a Google Script) you need to search for your topics. You will need to do this for each type of topic you want to look at. I’ll just describe the “Conversations”, but there are “Questions” and other types you will need to extrapolate for.

The can search for your topics (or get a list) using this endpoint….

https://api2-eu-west-1.insided.com/docs/community/#tag/Conversations/operation/getConversationList

This will give you the IDs you need for the next endpoint, the getConversation …..

https://api2-eu-west-1.insided.com/docs/community/#tag/Conversations/operation/getConversation

This will return your topic (lead post) and the contents. This will need to be called for every id returned by the  getConversationList endpoint.

Next you have the replies endpoint. This can be found here….

https://api2-eu-west-1.insided.com/docs/community/#tag/Conversations/operation/getRepliesForConversation

This will return the replies and the content.

Remember that this will need to be done for “Questions” and “Product Updates”, etc, in similar ways using slightly different endpoints. However, it should follow this way of working.