Skip to content

Python wrapper for working with the Creatio OData API, featuring authentication and CRUD operations on object collections. Ideal for developers working with Creatio environments

License

Notifications You must be signed in to change notification settings

YisusChrist/creatio-api-py

Creatio

            Tests Passing    GitHub pull requests    License


Report Bug · Request Feature · Ask Question · Report security bug


Alt


This Python library is designed for testing the OData API of Creatio. It includes functionality for authentication, making generic HTTP requests to the OData service, and performing various operations on object collections.

Table of Contents

Features

  • Authentication: Authenticate and obtain a session cookie for subsequent requests.
  • HTTP Requests: Make generic HTTP requests (GET, POST, PATCH, DELETE) to the OData service.
  • Collection Operations: Interact with object collections, including adding, modifying, and deleting records.
  • Logging: Enable debugging to log detailed information about HTTP requests and responses.

Requirements

Here's a breakdown of the packages needed and their versions:

Note

The software has been developed and tested using Python 3.12.1. The minimum required version to run the software is Python 3.6. Although the software may work with previous versions, it is not guaranteed.

Installation

From PyPI

creatio-api-py can be installed easily as a PyPI package. Just run the following command:

pip3 install creatio-api-py

Important

For best practices and to avoid potential conflicts with your global Python environment, it is strongly recommended to install this program within a virtual environment. Avoid using the --user option for global installations. We highly recommend using pipx for a safe and isolated installation experience. Therefore, the appropriate command to install creatio-api-py would be:

pipx install creatio-api-py

Manual installation

If you prefer to install the program manually, follow these steps:

Note

This will install the version from the latest commit, not the latest release.

  1. Download the latest version of creatio-api-py from this repository:

    git clone https://github.com/YisusChrist/creatio-api-py
    cd creatio-api-py
  2. Install the package:

    poetry install --only-main

Uninstall

If you installed it from PyPI, you can use the following command:

pipx uninstall creatio-api-py

Usage

The package allows you to stablish connection to any Creatio environment using the credentials of a user with the necessary permissions. The following steps will guide you through the process of setting up the environment and running the script.

  1. Set up your environment variables by creating a .env file with the following content:

    CREATIO_USERNAME=your_username
    CREATIO_PASSWORD=your_password
  2. Authenticate to the Creatio environment:

    from creatio_api_py.api import CreatioODataAPI
    from creatio_api_py.utils import print_exception
    
    creatio_url: str = "https://your-environment.creatio.com"
    api = CreatioODataAPI(base_url=creatio_url)
    try:
       # Authenticate with the API
       api.authenticate()
    except Exception as e:
       print_exception(e, f"Unable to authenticate on {creatio_url}")

    If you don't want to use the .env file, you can pass the credentials directly to the authenticate method:

    api.authenticate(username="your_username", password="your_password")

    The authenticate method will return an HTTP response object. If the status code is 200, the authentication was successful, and the session cookie is stored in the api object. Therefore, your don't need to pass the cookie to the other methods, it will be used automatically for the next requests.

    However, if you want to check the cookie value, you can access it using the cookie attribute:

    cookie = api.session_cookies
    print(cookie)

    Response Cookie:

    {
       "BPMLOADER": "lima0ugkfcecqs23bdeio1k4",
       ".ASPXAUTH": "7AE0D4CDCD7DCB01A65ACAF85D8DAC0D842B41745CB17A4AEF4C6F18701757AEA7EAFA90565091E61A54E5559A2B1113C6A6EDA78EFEDECD10176937BBD7F9FEBCAC9210963D42AC059C9858A29F7C903E9CB5FAC3B36CF273B8FF94850CDC01D21F69874990586EEDE392900D87C9D09DF3053D7E5AEDB0D79E0F9172634C9F2566424A5B5F38BD58C2EF1BC06E98ED9168488F7ADE262147E73A3A082CB8CAC74C6A4F6B50555D1ED2A93FC05070E0607B79B32F4ED8B8306918E1F2CCAC1C88CB651DFDF795A36E0A03EFFE0A8AA960BDCD358065C8FDABBF9C59A3FC0B2FEFD77C7E1FC484B6CDAB162F2A5EFB0084FDAA6404AF2773C3DBB8147F83E7040400172E332523BB415AC9432269BF5ED53E2BD70C336CDA513228617AC7A2C9BAD79CBEFE1DE193B1C8E5D6EC836D9F67F4F4033F759CA7E7EDBC433C72441110ECCBD386E05E960822BE049D7BACE51EDFA6B47E57BC654C4B7B3D047AEF9F14F92ACAB37D4286FC9494656B489DE1512DB33869291366E70DA77C9BEDB67706F5896F65B3F835D3C6B4D3367FC7FD086556E1B6F7777FD123848A7038F0AF923758AE398705069FF295D4C0CC180710DC2DE26DD91C09025F0093784241B60757937FEE936A2B80995617DFBB7FE54262F85F7AD4D5465413554A1C67BB0FD21793826C050E8AB83D39747A049C138792E079",
       "BPMCSRF": "ezBoM358i3BgxRyW1kKF0u",
       "UserType": "General",
       "UserName": "83|117|112|101|114|118|105|115|111|114"
    }

Here are some examples of how to interact with the Creatio API using this package:

Authentication

from creatio_api_py.api import CreatioODataAPI
from creatio_api_py.utils import print_exception

creatio_url: str = "https://your-environment.creatio.com"
api = CreatioODataAPI(base_url=creatio_url)
try:
   # Authenticate with the API
   api.authenticate()
except Exception as e:  # pylint: disable=broad-except
   print_exception(e, f"Unable to authenticate on {creatio_url}")
  • Response code: 200 OK
  • Response body:
{
  "Code": 0,
  "Message": "",
  "Exception": null,
  "PasswordChangeUrl": null,
  "RedirectUrl": "/0/Shell",
  "UserType": "General"
}

Add a Record to a Collection

payload: dict[str, str] = {
   "UsrEmail": "test@test.com",
   "UsrTelefono": "123456789",
   "UsrDescripcionBienContratado": "Test",
   # ... other fields ...
}

response = api.add_collection_data("Case", data=payload)
  • Response code: 201 Created
  • Response body:
{
   "@odata.context": "https://your-environment.creatio.com/0/odata/$metadata#Case/$entity",
   "Id": "cf8c6558-9e3e-48ca-a237-765b0f54b798",
   "CreatedOn": "2024-06-17T15:28:32.7013964Z",
   "CreatedById": "410006e1-ca4e-4502-a9ec-e54d922d2c00",
   "ModifiedOn": "2024-06-17T15:28:32.7013964Z",
   "ModifiedById": "410006e1-ca4e-4502-a9ec-e54d922d2c00",
   "ProcessListeners": 0,
   "Number": "SR00005250",
   "UsrDescripcionBienContratado": "Test",
   "UsrEmail": "test@test.com",
   "UsrTelefono": "123456789"
   // ... other fields ...
}

Creatio returns the created record with the Id field. You can use this ID to modify or delete the record later.

Modify a Record in a Collection

payload: dict[str, str] = {
   "UsrDescripcionBienContratado": "New test description",
}

record_id = "cf8c6558-9e3e-48ca-a237-765b0f54b798"
response = api.modify_collection_data("Case", record_id=record_id, data=payload)
  • Response code: 204 No Content
  • Response body: None

The response code 204 indicates that the record has been successfully updated. Creatio does not return a body in this case.

Get Data from a Collection

record_id = "cf8c6558-9e3e-48ca-a237-765b0f54b798"
response = api.get_collection_data("Case", record_id=record_id)
  • Response code: 200 OK
  • Response body:
{
   "@odata.context": "https://your-environment.creatio.com/0/odata/$metadata#Case/$entity",
   "Id": "cf8c6558-9e3e-48ca-a237-765b0f54b798",
   "CreatedOn": "2024-06-17T15:28:32.7013964Z",
   "CreatedById": "410006e1-ca4e-4502-a9ec-e54d922d2c00",
   "ModifiedOn": "2024-06-17T15:28:32.7013964Z",
   "ModifiedById": "410006e1-ca4e-4502-a9ec-e54d922d2c00",
   "ProcessListeners": 0,
   "Number": "SR00005250",
   "UsrDescripcionBienContratado": "New test description",
   "UsrEmail": "test@test.com",
   "UsrTelefono": "123456789",
   // ... other fields ...
}

As you can see, the field UsrDescripcionBienContratado has been updated and we have retrieved the last value.

Delete a Record from a Collection

record_id = "cf8c6558-9e3e-48ca-a237-765b0f54b798"
response = api.delete_collection_data("Case", record_id=record_id)
  • Response code: 204 No Content
  • Response body: None

The response code 204 indicates that the record has been successfully deleted. Creatio does not return a body in this case.

If we try to get the record again, we will get a 404 Not Found response:

record_id = "cf8c6558-9e3e-48ca-a237-765b0f54b798"
response = api.get_collection_data("Case", record_id=record_id)
  • Response code: 404 Not Found
  • Response body: None

Handle information from the API session

It is possible to retrieve information like the total number of requests made, the base url used for the class instance, and the session cookies.

total_requests = api.total_requests
# 6
base_url = api.base_url
# 'https://your-environment.creatio.com'
session_cookies = api.session_cookies
# {...}

Additionally, you can modify the object's base url if needed:

api.base_url = "https://another-environment.creatio.com"

Contributors

How do I contribute to creatio-api-py?

Before you participate in our delightful community, please read the code of conduct.

I'm far from being an expert and suspect there are many ways to improve – if you have ideas on how to make the configuration easier to maintain (and faster), don't hesitate to fork and send pull requests!

We also need people to test out pull requests. So take a look through the open issues and help where you can.

See Contributing Guidelines for more details.

License

creatio-api-py is licensed under the GNU General Public License v3.0.

About

Python wrapper for working with the Creatio OData API, featuring authentication and CRUD operations on object collections. Ideal for developers working with Creatio environments

Topics

Resources

License

Code of conduct

Security policy

Stars

Watchers

Forks

Packages

No packages published

Contributors 3

  •  
  •  
  •