Introduction
This python package is a set of Salesforce.com, Veeva Network, Veeva Vault, and Veeva Nitro libraries, scripts, and functions used to help expedite the development of Veeva Tools.
Installation / Requirements
Ensure you have at least Python version 3.10 installed. To Check your installation version, type the following commands in the terminal (MacOs) / command prompt (Windows):
python --version
To install python, go to https://www.python.org/ then navigate to the download page of your Operating System.
You will need to have Packager Installer for Python (pip) installed. To install pip, run the following command in the terminal (MacOs) / command prompt (Windows):
curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
python3 get-pip.py
To install the Veeva Tools library:
pip install veevatools
To upgrade to the latest version of Veeva Tools library:
pip install veevatools --upgrade
Installation Options
Install only the modules you need:
# Install everything
pip install veevatools[all]
# Install individual modules
pip install veevatools[vault] # Veeva Vault only
pip install veevatools[salesforce] # Salesforce/CRM only
pip install veevatools[network] # Veeva Network only
pip install veevatools[nitro] # Veeva Nitro only
# Development dependencies
pip install veevatools[dev]
Overview
The Veeva Tools package currently contains 4 major components:
Salesforce library
Authentication:
from veevatools.salesforce import Sf
import pandas as pd
sf = Sf()
sf.authenticate(
sfUsername='yourname@salesforce.com',
sfPassword='password123',
sfOrgId='00D2C0000008jIK',
is_sandbox=False
)
Sidenote on Pandas DataFrames:
Pandas DataFrame (pd) is used to prepare the data for import (i.e. create, update methods) and additional export methods such as pd.to_excel() in order to save the output into an Excel file.
Additionally, Complex data manipuation (joins, merges, groupbys, filters)and data analytics (describe, statistical analysis) can all be performed using Pandas.
To learn more about Pandas DataFrames, go to the Pandas documentation <br > Or just Google tutorials on Pandas DataFrames. This YouTube playlist by Corey Schafer provides an excellent starting point into the world of Pandas!
Data methods:
The salesforce class (Sf) contains methods that can help you interact with data and metadata components:
Query
account_recordtypes = sf.query("SELECT Id, Name, SobjectType from RecordType WHERE SobjectType = 'Account'")
account_recordtypes
Return -> pd.DataFrame():
| Id | Name | SobjectType | |
|---|---|---|---|
| 0 | 012f4000001ArT3AAK | Professional_vod | Account |
| 1 | 012f4000001ArT4AAK | Institution_vod | Account |
| 2 | 012f4000001ArT5AAK | MCO_vod | Account |
| 3 | 012f4000001ArT6AAK | Organization_vod | Account |
| 4 | 012f4000001ArWzAAK | Hospital_vod | Account |
Sidenote:
You can use any Pandas (pd) methods on the return value of the query output. For exampleaccount_recordtypes.to_excel("Account RecordTypes.xlsx")
Will save the results of the DataFrame into an Excel file.
Create
## Takes a DataFrame of CRM records and creates records in CRM
account_records = pd.DataFrame([{'FirstName': 'Test', 'LastName': 'Account'}, {'FirstName': 'Test2', 'LastName': 'Account2'}])
result = sf.create('Account', account_records)
result
Return -> pd.DataFrame():
| success | created | Id | |
|---|---|---|---|
| 0 | True | True | 0010r00000tF7L1AAK |
| 1 | True | True | 0010r00000tF7L2AAK |
Update
### Takes a dataframe that contains at least the Id column
### and any other column to be updated, for example, FirstName
update_account_name = pd.DataFrame(
[{'FirstName': 'Updated', 'Id': '0010r00000tF7L1AAK'},
{'FirstName': 'Name', 'Id': '0010r00000tF7L2AAK'}]
)
result = sf.update('Account', update_account_name)
result
Return -> pd.DataFrame()
| success | created | Id | |
|---|---|---|---|
| 0 | True | False | 0010r00000tF7L1AAK |
| 1 | True | False | 0010r00000tF7L2AAK |
Upsert
### Takes a dataframe that contains an external ID column
### and any other column to be updated, for example, Name
### if the external ID matches an existing record,
### the account is updated, otherwise, a new record is created
upsert_account = pd.DataFrame(
[{'NET_External_Id__c': '242977178138969088', 'Name': 'Updated Hospital Name'},
{'NET_External_Id__c': '555579769212255555', 'Name': 'Create New Hospital'}]
)
result = sf.upsert(object_api='Account', external_id_field_api='NET_External_Id__c', record_dataframe=upsert_account)
result
Return -> pd.DataFrame()
| success | created | id | |
|---|---|---|---|
| 0 | True | False | 001f400000PKOrwAAH |
| 1 | True | True | 0010r00000tF7stAAC |
Delete
### Takes a dataframe that contains the Id column
### deletes records listed based on their SFID.
delete_account = pd.DataFrame([{'Id': '0010r00000tF7stAAC'}, {'Id': '001f400000PKOrwAAH'}])
result = sf.delete(object_api='Account', record_dataframe=delete_account)
result
Return -> pd.DataFrame()
| success | created | Id | |
|---|---|---|---|
| 0 | True | False | 0010r00000tF7stAAC |
| 1 | True | False | 001f400000PKOrwAAH |
Metadata Methods
Metadata methods (Read, Create, Update, Rename, Delete, List) -- coming soon.
Vault library
Authentication:
from veevavault import VaultClient, DocumentService
client = VaultClient()
client.authenticate(vaultURL='https://myvault.veevavault.com', vaultUserName='user@vault.com', vaultPassword='password123')
# Services take the authenticated client as their argument
docs = DocumentService(client)
all_docs = docs.retrieval.retrieve_all_documents()
Network library
Authentication:
from veevanetwork import NetworkClient
# NetworkClient requires url, username, and password at construction
client = NetworkClient(
url='https://mynetwork.veevanetwork.com',
username='user',
password='pass',
)
client.authenticate()
# Services are accessed as properties on the client
results = client.search.search(q='Smith')
objects = client.metadata.retrieve_object_types()
Nitro library
Authentication:
from veevanitro import Nitro
# Nitro wires the client and all services together
n = Nitro()
n.auth.login(server_url='https://mycompany.veevanitro.com', username='user', password='pass')
# Access services directly
tenant = n.admin.get_tenant()
users = n.admin.get_users()
1 maintainer
Metadata
1 maintainer
Release files for veevatools 1.0.18
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| veevatools-1.0.18.tar.gz | 237.8 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| veevatools-1.0.18-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 554.2 kB
Release files / veevatools-1.0.18.tar.gz
| Download URL | veevatools-1.0.18.tar.gz |
|---|---|
| Size | 237.8 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
2eb0b0e06abb219a9073f719f7a926912eb407a8acba6a1ac74ddd7c87a48f35
|
|
BLAKE2b-256 checksum How to use checksums |
40b68158ecb4fd4d1e01f1c86b6b142faa744611631b0d1fc38c8fc0b3d3f448
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.13.1
|
Release files / veevatools-1.0.18-py3-none-any.whl
| Download URL | veevatools-1.0.18-py3-none-any.whl |
|---|---|
| Size | 316.4 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
7dc3a801d00b216a1332cb158fa12e82832793c1f4cdab2ef2e86a0745600ca6
|
|
BLAKE2b-256 checksum How to use checksums |
943334854de14dbf8accc864219661400dd97614bb6be7a75fe9feba83b5b274
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.13.1
|
Security for veevatools 1.0.18
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
