Looking for Example Recipes with Gainsight Custom Connector

[jstudwell]

We're trying to use Workato to extract data from Gainsight objects and load it into an AWS S3 bucket for ingestion into our Redshift data warehouse. There is a Gainsight custom connector, but I haven't been able to find any example recipes of folks actually using it to do things with Gainsight, particularly data extraction. Also, we use custom objects and so will need to navigate creating custom actions against the Gainsight APIs. Anybody have experience or examples they'd be willing to share?

[Sathwik_Malli]

Hi @jstudwell 

Please try this approach once :
You can extract Gainsight data into S3 for Redshift either by (A) using Gainsight’s native S3 export (if available for your object/dataset) or (B) calling Gainsight’s REST APIs from Workato (using the Gainsight connector or a custom/HTTP connector), streaming/paging results out, writing CSV/JSON to S3, then loading into Redshift. For custom objects you’ll typically call the Gainsight Custom Object APIs and implement pagination/incremental pulls in Workato.