Hello, has someone tried to connect Amplitude to Qlik via the REST API? I connected it but the results I am getting are not in the wished format. I used the dashboard API to get a simple DAU report, I get the number of users, I get the date, but I can’t connect them together.
Best answer by Saish Redkar
From what it looks like, the join won’t be straightforward without the key, given that there can’t be much done on how the REST API returns the data. Is there any other way Qlik can extract these responses to avoid this issue?
If you are okay not leveraging the REST API and cool playing with raw event data, the long shot would be setting up recurring exports of your project data to the cloud destination of your choice ( S3, Snowflake, GCS ) directly from the Amplitude. Maybe then try to connect Qlik to these destinations and get the desired data using some basic SQL for DAU calculation.
+10Hey
I’m not quite familiar with how Qlik works here, but depending on what call you are making to the /api/2/events/segmentation end point, the raw data points returned would be nested as json lists/objects. The main datapoints to look here are the series and xValues, which you have already extracted in the above data model.
The xValues is an array of string dates in the form "YYYY-MM-DD", one for each date in the specified range depending on time interval you have chosen.The series is an array with one element for each group, in the same order as "seriesLabels", where each element is itself an array that contains the value of the metric on each of the days specified in "xValues".
For a simple DAU chart without any group by, each value in the series array would be the user count ( unique or total depending on the API parameter m you chose) corresponding to the date string value in the xValues array.
I would check if it’s possible in Qlik to just look at the series and xValues array tables and join the two to get the DAU report in a tabular format.
Hi
+10From what it looks like, the join won’t be straightforward without the key, given that there can’t be much done on how the REST API returns the data. Is there any other way Qlik can extract these responses to avoid this issue?
If you are okay not leveraging the REST API and cool playing with raw event data, the long shot would be setting up recurring exports of your project data to the cloud destination of your choice ( S3, Snowflake, GCS ) directly from the Amplitude. Maybe then try to connect Qlik to these destinations and get the desired data using some basic SQL for DAU calculation.
+8Hi
I agree with
I hope this helps! If Amplitude can help any further, please tag me here and I will help as much as I can.
Kind Regards,
Denis
Hi
+8You have the Export API but this is done through zipped JSON files. You could use the Dahsboard REST API which will allow you to query against charts and their data to get the raw data that is returned from them.
For more information on the REST API and it’s capabilities, please see https://developers.amplitude.com/docs/dashboard-rest-api. I hope this helps! Let me know if you need any further clarity.
+10I would go with Denis’ suggestion here.
Export API won’t give you csv files, but zipped JSON files. You will have to crunch the raw data from these to get your desired data.
Using the Dashboard REST API, you can schedule some jobs on extracting the results depending on what chart data you are looking for.
Hi
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
