Has anyone used Alteryx to extract data from Medallia using the Download Tool?

[jreineck01]

We are wanting to extract data from Medallia using the Download Tool (or python whichever is easier). Has anyone created a connector or API that has performed such a task? Do you have an example?

[bbak91]

It looks like Medallia uses Basic Authentication: https://developer.medallia.com/medallia-apis/reference/authentication 

 "https://${REPORTING_INSTANCE}/oauth/${TENANT_NAME}/token" \ -X POST \ -u 'client_id:client_secret' \ -d 'grant_type=client_credentials'

So you would take client_id:client_secret, base64 encode it, put the word Basic and a space in front of this value in a new field called Authorization and pass that as a header in the download tool which would be configured to do a POST request against the endpoint listed above and also have a grant_type client_credentials in the payload tab. 

If the credentials are valid, this will return a download data column after the download tool which will have a JSON value that looks something like this:

{ "access_token": "2c5822312345678901d21", "token_type": "Bearer", "expires_in": 3600 }

The token can then be used in subsequent API calls. 

You can see examples here: https://community.alteryx.com/t5/Engine-Works/APIs-for-Beginners-Integrate-All-the-Systems/ba-p/8074... 

[apathetichell]

The next question is going to be about how to build GraphQL requests.