Hi,

Send request to one of below URLs. Please not that if URL respond with list (0,1,2,3 items) you need to reference it by (json, orient='columns') if the data is one level below (f.e. list of items is part of "data" column) you need to reference it by (jsonn"data"], orient='columns')

A) https://<team_name>.celonis.cloud/api/user-analysis/users-stickiness?from=2022-09-01&to=2022-09-30&period=MONTH

It's to get user stickness values for specific dates and periods

B) https://<team_name>.celonis.cloud/api/user-analysis/users-and-logins-during-period

To get aggregated login counts per period

c) https://<team_name>.celonis.cloud/api/user-analysis/user-login-count?from=2021-10-01&to=2022-10-01

To get aggregated login counts per user

d) https://<team_name>.celonis.cloud/api/external/authentication-events

To receive just whole login history with all information use URL above - please note that you'll need to write additional code to loop through pages, as single page can hold up to 200 records (in that case, 200 login attempts). To interact with pages, just add ?pageNumber=0&pageSize=1 at the end of the request URL, and just iterate through pageNumber values, it's good to always set pageSize to 200.

Standard code snippet:

URL = "<PUT URL HERE>"

celonis = get_celonis(url='https://<team_name>.try.celonis.cloud',key_type='APP_KEY', permissions=False)

json = celonis.api_request(URL, message=None, method='auto', timeout='default', get_json=True)

df = pd.DataFrame.from_dict(jsono'<dictionaryKey>'], orient='columns')

#Pushing data to CElonis

data_pool = celonis.pools.find("<DataPoolID>")

data_pool.create_table(table_name="<NewTableName>",

                      df_or_path=df,

                     if_exists="drop")

#Viewing data frame

df

If that helped, please select that answer as best, if not share some screenshots and errors description with us.

Best Regards,

Mateusz Dudek

Thank You Mateusz.

Also, the following URL enables to extract complete user details from user adoption page.

https://<team_name>.celonis.cloud/api/team/platform-adoption/events/csv?eventType=STUDIO_ASSET

Hi Sree, What you did to push this platform adoption csv file to data model? Have you used any action flows?

Hi Muthappan,

To push Adoption table, used Machine learning capability of Celonis.

Regards,

Sree C

Is it possible to share the Jupiter python notebook code in an email muthappan12@gmail.com

Hi Mateusz,

The following URL was used to extract the login counts. However, it is giving error for the past 1 week.

"https://<team_name>.celonis.cloud/api/user-analysis/user-login-count?from=2021-10-01&to=2022-10-01 "

Can you please suggest on how to extract the updated url?

Below URL works:

https://<team_name>.celonis.cloud/platform-adoption/api/user-analysis/user-login-count?"+"from=2022-01-01&to= 2023-01-31"

Hello I want to set an adoption dashboard but I'm not sure how can I access the adoption platform data. Do you have any suggestions where to start?

Hi Romayssa,

URL - https://<team_name>.celonis.cloud/api/team/platform-adoption/events/csv?eventType=STUDIO_ASSET

Above URl can be used in python to extract adaption platform data.