Beginners Guide To The Gong API - Recap.

  • 21 September 2022
  • 3 replies
  • 856 views
Andrew O'Driscoll
Userlevel 5
Badge +3

Thanks so much for joining our Beginners Guide To The Gong API Meetup.  It was exciting to have such an engaged group ready to get using the Gong API. 

 

If you missed the meetup you can access it here.

 

Top 3 discussion areas:

  1. Why to connect to the Gong API

  2. How to connect to the Gong API

  3. Practical use cases for getting started

 

One attendee shared their API interest was driven by the need to stop the time consuming task of downloading and editing CSV files.

Two different attendees said the API is compelling because they want Gong data in their data warehouse for further analysis and combining with other data. 

 

Resources: 

  • Link to the call

  • We shared a Postman based Gong API Starter Kit, containing the most used Gong API calls — so you can start using the API today. Fast forward to minute 9:14 in the recording to hear more on this.

  • We showed a spreadsheet based tool called Apipheny, that allows you to pull Gong data directly into Google sheets. Fast forward to 27:04 in the recording to see more, or look at this short video.

  • Gong API

Join us for another meetup

Our next meetup continues the API theme, where we will showcase Power BI examples using Gong data retrieved from the API.


Cheers, 

Andrew.

Founder, Growment.

3 replies

Molly Kipnis
Userlevel 6
Badge +1

@Andrew O'Driscoll great recap, thank you for sharing! 

FYI @Ian Gwynne 🙂

N

I watched through this video, and it’s really close to what I’m looking for.  I’m trying to connect the Gong API to PowerBI with an access key.  @Andrew O'Driscoll do you have any instructions on how to use the get/calls/extensive api request to port data to powerbi?

Andrew O'Driscoll
Userlevel 5
Badge +3

@Nicholas Denker Here is some code that will get you closer. The bolded font are parameters you need to swap for your own. You would also paste the code into the advanced editor.

I am not a big proponent of connection Power BI directly to Gong due the need to paginate results. It work’s fine for select use cases but for large data volumes you’d be better off getting the data into a database that Power BI is connected to. 

Have fun.

 

let
    source = Key & ":" & Secret,
    bytes = Text.ToBinary(source),
    TextForm = Binary.ToText(bytes, BinaryEncoding.Base64),
    basic = "Basic " & TextForm,
        body = "{
  ""contentSelector"": {
    ""context"": ""Extended"",
    ""contextTiming"": [
      ""Now""
    ],
    ""exposedFields"": {
      ""collaboration"": {
        ""publicComments"": false
      },
      ""content"": {
        ""pointsOfInterest"": false,
        ""structure"": false,
        ""topics"": false,
        ""trackers"": true
      },
      ""interaction"": {
        ""personInteractionStats"": false,
        ""questions"": false,
        ""speakers"": false,
        ""video"": false
      },
      ""media"": false,
      ""parties"": false
    }
  },
  ""filter"": {    ""fromDateTime"": """&Text.From(FromDateTime)&""",
    ""toDateTime"": """&Text.From(ToDateTime)&"""
  }
}",  json = Json.Document(Web.Contents(
    "https://api.gong.io/v2/calls/extensive",[
        Headers=[#"Authorization"=""&basic&"",
        #"Content-Type"="application/json"],
        Content=Text.ToBinary(body)
        ]
      )
    ),
    #"Converted to Table" = Record.ToTable(json),
    #"Transposed Table" = Table.Transpose(#"Converted to Table"),
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true])
in
    #"Promoted Headers" 

Founder, Growment.

Reply


Terms & ConditionsCookie settings