Skip to main content
Join the official 2020 Python Developers SurveyStart the survey!

A simple connector to the AMIV SugarCRM

Project description

Connector to the AMIV SugarCRM

SugarCRM provides a SOAP and a REST api. At the time this tool was written the REST api was unfortunately not available. Therefore SOAP is used.

The python library suds is used, more exactly the fork by jurko.

Installation

pip install amivcrm

Usage

You will need a soap username and password. You can find them in the AMIV Wiki. After you got the credentials, its as easy as this:

from amivcrm import AMIVCRM

CRM = AMIVCRM(username, password)
# Optional: Specify `url` and/or `appname`
# CRM = AMIVCRM(username, password, url="...", appname="...")

# Get Companies
CRM.get('Accounts')

# Select only certain fields
# Filter and order with SQL statements
CRM.get('Accounts',
    # Only companies participating in job fair
    query="accounts_cstm.messeteilnahme_c = 1",
    # Order alphabetically
    order_by="accounts.name",
    # Return Name and ID only
    select_fields=['name', 'id'])

# Get a single company by id
CRM.getentry('Accounts', '505404b1-1851-1472-d63e-4d829377e30b',
             # Optional: Limit the returned fields as well
             select_fields=['name'])

# Get a company only if  modified after given date
entry_id = '505404b1-1851-1472-d63e-4d829377e30b'
date = '2016-03-20 08:05:39'
# Be careful to use quotes in query
query = ("accounts.id = '%s' and accounts.date_modified >= '%s'"
         % (entry_id, date))
CRM.get('Accounts', query=query)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for amivcrm, version 0.2.0
Filename, size File type Python version Upload date Hashes
Filename, size amivcrm-0.2.0-py3-none-any.whl (3.4 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size amivcrm-0.2.0.tar.gz (3.1 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page