def get_a_client(id):
base_url = current_app.config["DATABASE_URL"]
response = requests.get(
"{}/Clients/{}".format(base_url, id),
headers={"Authorization": str(os.environ.get("API_KEY"))},
)
# Convert to JSON
response_json = response.json()
# Validation check
if (response.status_code // 100) != 2:
return response_json["error"], response.status_code
# Get object's parameters
id_number = response_json["id"]
name = response_json["fields"].get("Name")
notes = response_json["fields"].get("Notes")
email = response_json["fields"].get("Client Email")
attachments = response_json["fields"].get("Attachments")
if name is None or email is None:
return "There is no client with this id. Please try again.", 422
# Create and return object
c = Client(
name=name,
email=email,
id_number=id_number,
notes=notes,
attachments=attachments,
)
return jsonify(c.serialize()), 200
def get_all_clients():
response = requests.get(
"https://api.airtable.com/v0/appw4RRMDig1g2PFI/Clients",
headers={"Authorization": str(os.environ.get("API_KEY"))},
)
response_json = response.json()
list_of_clients = []
for r in response_json["records"]:
name = r["fields"].get("Name")
notes = r["fields"].get("Notes")
attachments = r["fields"].get("Attachments")
if name is not None:
m = Client(name=name, notes=notes, attachments=attachments)
list_of_clients.append(m.serialize())
return jsonify(list_of_clients)
def getResponse():
for r in response_json["records"]:
id_number = r["id"]
name = r["fields"].get("Name")
notes = r["fields"].get("Notes")
email = r["fields"].get("Client Email")
attachments = r["fields"].get("Attachments")
if name is not None and email is not None:
m = Client(
name=name,
email=email,
id_number=id_number,
notes=notes,
attachments=attachments,
)
list_of_clients.append(m.serialize())
def get_a_client_from_email(email):
response = requests.get(
"https://api.airtable.com/v0/appw4RRMDig1g2PFI/Clients?filterByFormula=SEARCH('{}'"
.format(email) + ", {Client Email})",
headers={"Authorization": str(os.environ.get("API_KEY"))},
)
response_json = response.json()
list_of_clients = []
for r in response_json["records"]:
name = r["fields"].get("Name")
notes = r["fields"].get("Notes")
attachments = r["fields"].get("Attachments")
if name is not None:
m = Client(name=name, notes=notes, attachments=attachments)
list_of_clients.append(m.serialize())
return jsonify(list_of_clients)
else:
return "There is no client with that email, please try again."
def get_a_client(id):
response = requests.get(
"https://api.airtable.com/v0/appw4RRMDig1g2PFI/Clients/{}".format(id),
headers={"Authorization": str(os.environ.get("API_KEY"))},
)
if response.status_code == 200:
response_json = response.json()
client = []
name = response_json["fields"].get("Name")
notes = response_json["fields"].get("Notes")
email = response_json["fields"].get("Client Email")
attachments = response_json["fields"].get("Attachments")
if name is not None:
m = Client(name=name,
email=email,
notes=notes,
attachments=attachments)
client.append(m.serialize())
return jsonify(client)
else:
return "This client does not exist in the database."
def get_a_client_from_email(email):
base_url = current_app.config["DATABASE_URL"]
response = requests.get(
"{}/Clients?filterByFormula=SEARCH('{}'".format(base_url, email)
+ ", {Client Email})",
headers={"Authorization": str(os.environ.get("API_KEY"))},
)
# Convert to JSON
response_json = response.json()
# Validation check
if (response.status_code // 100) != 2:
return response_json["error"], response.status_code
error = handleEmailResponse(response_json["records"])
if error is not None:
return error, 422
# Get object's parameters
id_number = response_json["records"][0]["id"]
name = response_json["records"][0]["fields"].get("Name")
email = response_json["records"][0]["fields"].get("Client Email")
notes = response_json["records"][0]["fields"].get("Notes")
attachments = response_json["records"][0]["fields"].get("Attachments")
if name is None or email is None:
return "There is no client with that email. Please try again.", 422
# Create and return object
c = Client(
name=name,
email=email,
id_number=id_number,
notes=notes,
attachments=attachments,
)
return jsonify(c.serialize()), 200