In Peliqan you can define and publish API endpoints, in order to share data with partners, customers etc. These API endpoints can also be used to capture incoming webhook events.
Publishing an API endpoint
In Peliqan, go to the Build section, and click the “+” icon when hovering over “API endpoints”:
Add a new endpoint and link it to a Python script of type “API handler”. See below on how to write a low-code Python script to handle the API requests.
Create a JWT web token under Settings > Security, and use this in the Authorization header to authenticate when consuming this API endpoint.
The full URL of your API endpoint is shown on the API endpoint detail screen, as you can see in the above screenshot.
Adding a Python script to handle API requests
In Peliqan, go to the Build section, and click the “+” icon when hovering over “Apps”. Add a script (app) of type “API endpoint handler”:
The new script will have some boilerplate example code, that shows how you can get the details of the incoming request (such as the body, headers, querystring etc.) and how you can send a response:
def handler(request):
# Get request details:
method = request['method']
url = request['url']
path = request['path']
query_string = request['query_string']
headers = request['headers']
data = request['data']
form = request['form']
# Example reading a parameter from the querystring
from urllib.parse import parse_qs
query_string_dict = parse_qs(query_string)
if "param1" in query_string_dict:
param1 = query_string_dict['param1'][0]
# Example reading data from an incoming POST body with JSON
import json
postbody_obj = json.loads(data)
# Example response: read rows from a table (pq = Peliqan module)
dbconn = pq.dbconnect('dw_2')
table_rows = dbconn.fetch('dw_2', 'salesforce', 'accounts')
# Send the API response (e.g. return the table contents)
return table_rows