Skip to content

Python

Basic

Python
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
import requests
import json  # added for output saving

api_key = "xxxx"  
url = "https://xxx.platformaerp.com/api/srs/301/exec.json?datefrom=2024-01-01&dateto=2024-01-03"

headers = {
    "Authorization": f"Token {api_key}",
}

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

if response.ok:
    data = response.json()  # assuming a JSON response
    with open("output.json", "w") as f:
        json.dump(data, f, indent=4)
    print("Output saved to output.json")

    # Iterate and print unique addusername values from data.view
    with open("output.json", "r") as f:
        result = json.load(f)
    unique_users = {item["addusername"] for item in result.get("data", {}).get("view", []) if "addusername" in item}
    print("Unique addusername values:")
    for user in unique_users:
        print(user)
else:
    print("Error:", response.status_code, response.text)