Below you will find examples on how to make “raw” API calls from your Python scripts in Peliqan.

☝

Note: Peliqan provides SaaS API wrapper functions for a wide range of SaaS applications (CRM, ERP, accounting, messaging etc). For these connectors, you do not need to make “raw” API calls. More info:Interacting with SaaS APIs

Comparison between both methods:

Peliqan SaaS API wrapper functions	Raw API calls
Authentication is automatically handled	You have to handle authentication in your script
Headers, body, querystring etc. are automatically built	You have to build up the API request: method (GET, POST…), URL, querystring, headers, body

REST API call

Example on making API calls to a REST API:

import requests

# Get data

url = "https://domain.com/api/companies"
result = requests.get(url)
st.write(results) # show result

# Post data

headers = {
	"Authorization": "Bearer " + token 
}

data = {
	"key": "value"
}

result = requests.post(url, json = data, headers = headers)
st.write(results) # show result

SOAP Webservice API call

Example on making an API call to a SOAP Webservice:

import requests, base64, xmltodict, json

url = "https://domain.com/api/SomeWebService.asmx"

# See the SOAP Webservice documentation for the correct SOAP envelope to use
xml = """<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetData xmlns="http://...">
      <param>xxx</param>
    </GetData>
  </soap:Body>
</soap:Envelope>
"""

headers = {
    "Content-Type": "text/xml; charset=utf-8",
    "SOAPAction": "https://domain.com/api/SomeAction",
    "Authorization": "Basic " + basic_auth # see below
}

result_xml = requests.post(url, data = xml, headers = headers).text
result_dict = xmltodict.parse(result_xml)
rows = result_dict["soap:Envelope"]["soap:Body"]["GetDataResponse"]["Result"]["Rows"]
st.write(rows)

Authentication

Example of using Basic Authentication:

login = 'xxx'
pw = 'xxx'
  
basic_auth = base64.b64encode((login + ":" + pw).encode("ascii")) .decode("ascii") 

headers = {
	"Authorization": "Basic " + basic_auth 
}

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

Example of using a JWT or token:

headers = {
	"Authorization": "Bearer " + token 
}

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

Making raw API calls

REST API call

SOAP Webservice API call

Authentication