Forum Discussion

Silutions's avatar
Silutions
ETL
02-09-2022
Solved

REST API and Python

i'm a Python newbie looking for more REST API script samples using Python.  For example, I'm trying to export a simple user list with email, firstName and lastName with a certain search value using t...
Notebooks
  • harikm007's avatar
    harikm007
    02-09-2022

    Silutions ,

    Please check this python script:

    import requests
import json

username = 'your username'
password = 'your password'
server_name = 'https://XXXXX.YYYYY.com'

login_data =    {  'username' : username,
                        'password' : password
                    }

login_url = server_name + '/api/v1/authentication/login'
login_res = requests.post(url=login_url, data=login_data).json()

access_token = login_res.get('access_token')
if len(access_token) > 0:
    print('login succesful.')
    
api_header = {'Authorization': 'Bearer ' + access_token}

url = server_name + '/api/v1/users?search=ZZZZ&fields=email%2CfirstName%2ClastName'

response = requests.get(url, headers=api_header)

print(json.loads(response.text))

    -Hari

harikm007's avatar
harikm007
Data Warehouse
02-09-2022

Silutions ,

Please check this python script:

import requests
import json

username = 'your username'
password = 'your password'
server_name = 'https://XXXXX.YYYYY.com'

login_data =    {  'username' : username,
                        'password' : password
                    }

login_url = server_name + '/api/v1/authentication/login'
login_res = requests.post(url=login_url, data=login_data).json()

access_token = login_res.get('access_token')
if len(access_token) > 0:
    print('login succesful.')
    
api_header = {'Authorization': 'Bearer ' + access_token}

url = server_name + '/api/v1/users?search=ZZZZ&fields=email%2CfirstName%2ClastName'

response = requests.get(url, headers=api_header)

print(json.loads(response.text))

-Hari

Silutions's avatar
Silutions
ETL
02-09-2022

Hari - worked like champ.  Thank you! - Jim