We have Woopra tracking usage data, and are looking for the best way to pull that data into Gainsight for usage & reporting. Woopra has a webhook feature that allows us to run an HTTP POST anytime a user performs a specific action on our platform.
https://www.woopra.com/docs/manual/creating-triggers/#Option_3_Webhook_Configuration
My question is, what would be the best way to get this data into Gainsight? Should we use webhooks to post to our S3? Should I post to our Matrix Data?
Solved
Woopra usage data in GS
+1Best answer by kendra_mcclanahan
Hi Jason,
Hopefully I'm understand the ask correctly, you are looking for a way to integrate your Woopra data with Gainsight?
We don't have a direct connection to Woopra and we don't support ingest of JSON strings, but I would suggest using one of the following options:
View originalHopefully I'm understand the ask correctly, you are looking for a way to integrate your Woopra data with Gainsight?
We don't have a direct connection to Woopra and we don't support ingest of JSON strings, but I would suggest using one of the following options:
- Gainsight S3 Connector - If you can generate a CSV from Woopra, many customers do this via an ETL tool, and then import this into your S3 bucket. You can then setup your ingest jobs in the S3 connector under Administration -> Connectors.
- Gainsight Bulk API - This option will still require you to generate a CSV, but you'll use a cURL command to ingest the file vs. loading to an S3 bucket. You can configure the setup under Administration -> Connectors 2.0.
+1From the Woopra CS guy:
We have an import/export API which allows you to construct a JSON file with the appropriate data which can be automated on your end as well as an HTTP API that allows you to build your own SDK.
https://www.woopra.com/docs/developer/import-export-api/
https://www.woopra.com/docs/developer/http-tracking-api/
We have an import/export API which allows you to construct a JSON file with the appropriate data which can be automated on your end as well as an HTTP API that allows you to build your own SDK.
https://www.woopra.com/docs/developer/import-export-api/
https://www.woopra.com/docs/developer/http-tracking-api/
+7Hi Jason,
Hopefully I'm understand the ask correctly, you are looking for a way to integrate your Woopra data with Gainsight?
We don't have a direct connection to Woopra and we don't support ingest of JSON strings, but I would suggest using one of the following options:
Hopefully I'm understand the ask correctly, you are looking for a way to integrate your Woopra data with Gainsight?
We don't have a direct connection to Woopra and we don't support ingest of JSON strings, but I would suggest using one of the following options:
- Gainsight S3 Connector - If you can generate a CSV from Woopra, many customers do this via an ETL tool, and then import this into your S3 bucket. You can then setup your ingest jobs in the S3 connector under Administration -> Connectors.
- Gainsight Bulk API - This option will still require you to generate a CSV, but you'll use a cURL command to ingest the file vs. loading to an S3 bucket. You can configure the setup under Administration -> Connectors 2.0.
1 person likes this
Thanks Kendra! Could you tell me where we get the data load access token? I assume using the Generate Curl button allows us to take that code and script it to automate the job on a recurring schedule?
Note from the Generate Curl screen: Replace [ACCESS_KEY] with data load access token
Note from the Generate Curl screen: Replace [ACCESS_KEY] with data load access token
+7Hi Chris,
In Connectors 2.0 did you click on the 'Create a Connection' option and generate an Access Key from there? You're assumption is correct...once you generate the Curl you'll receive the script that you need to insert the data from your end.
Let me know if this helps and if you have any additional questions!
In Connectors 2.0 did you click on the 'Create a Connection' option and generate an Access Key from there? You're assumption is correct...once you generate the Curl you'll receive the script that you need to insert the data from your end.
Let me know if this helps and if you have any additional questions!
1 person likes this
Makes total sense. I see how to do it now. Thanks Kendra!
+7Awesome! Let me know if we can help with anything else.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.